quarta-feira, 23 de maio de 2012

ORA-28368: cannot auto-create wallet

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/wallet
[oracle@ocm wallet]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 23 14:15:34 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set encryption key identified by "welcome1";
 System altered.
SQL> exit

quinta-feira, 10 de maio de 2012

12c Management Agent Silent Installation

http://gavinsoorma.com/2012/05/12c-management-agent-silent-installation/

quarta-feira, 9 de maio de 2012

Error - Please set the credentials for the target racprod-cluster:cluster

emcli create_credential_set -set_name=CredentialOraoem -target_type=cluster -auth_target_type=cluster -supported_cred_types=HostCreds -monitoring -description='Credential Oraoem Cluster'

emcli set_monitoring_credential -target_name=racprod-cluster -target_type=cluster -set_name=CredentialOraoem -cred_type=HostCreds -auth_target_type=host -attributes='HostUserName:oraoem;HostPassword:password'

segunda-feira, 7 de maio de 2012

ASM instance not registered on LISTENER

sqlplus / as sysasm
show parameter local_listener
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.247.135)(PORT=1521))))"

 It's wrong ip address
Change: alter system set local_listener="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.247.130)(PORT=1521))))";

alter system register;

EM12c - Deinstalling Oracle Management Agent

http://docs.oracle.com/cd/E24628_01/install.121/e24089/deinstall_agent.htm#CBBCEJHG

sexta-feira, 4 de maio de 2012

EM12C - create_credential_set

./emcli login -username=sysman emcli create_credential_set -set_name=CredentialOraoem -target_type=host -auth_target_type=host -supported_cred_types=HostCreds -monitoring -description='Credential Oraoem' 

emcli set_monitoring_credential -target_name=target1 -target_type=host -set_name=CredentialOraoem -cred_type=HostCreds -auth_target_type=host -attributes='HostUserName:oraoem;HostPassword:password%'

Oracle Enterprise Manager 12c - Create and Use Metric Extensions

http://www.oracle.com/webfolder/technetwork/tutorials/obe/em/em12c/metric_extensions/Metric_Extensions.html

quinta-feira, 3 de maio de 2012

Release Schedule of Current Enterprise Manager Releases and Patch Sets

Document ID: 793512.1

Move the EM12c repository database

http://martincarstenbach.wordpress.com/2011/10/17/move-the-em12c-repository-database/

How to Download New Agent Software for Oracle Cloud Control 12c

http://www.gokhanatil.com/2012/03/how-to-download-new-agent-software-for-oracle-cloud-control-12c.html

Installing Oracle Management Agent Using RPM File

http://docs.oracle.com/cd/E24628_01/install.121/e24089/install_agent_usng_rpm.htm http://martincarstenbach.wordpress.com/2011/11/22/installing-oem-12c-agents-in-rpm-format/

EM12c:Automated discovery of Targets

http://askdba.org/weblog/2012/02/em12c-automated-discovery-of-targets/