How to configure Enterprise Manager 11gR2 for RAC environment
Posted by Kamran Agayev A. on March 2nd, 2014
After migrating 10gR2 single instance to 11gR2 RAC db, the next step should be configuring Enterprise Manager (if you don’t use centralized Grid Control)
It can be done by a simple command. But as usual (at least for me) it didn’t go smooth and I got some errors :). In this article I will show you solutions for some of them.
The command should be run is as follows:
emca -config dbcontrol db -repos create –cluster
It will ask you to provide the following information:
db-bash-$ emca -config dbcontrol db -repos create -cluster
STARTED EMCA at Mar 2, 2014 3:03:19 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database unique name:
Service name:
Listener port number:
Listener ORACLE_HOME
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Cluster name:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME :
ASM port :
ASM username [ ASMSNMP ]:
ASM user password:
– Get Database unique name from db_unique_name parameter from the database
SQL> show parameter db_unique_name
– To provide a service name, get the SCAN listener name from the host (ps –ef | grep tns), get the status of SCAN listener by running lsnrctl status LISTENER_SCAN1 command from $GRID_HOME and get the service name from the output
Service “RACDB.MYCOMP.COM” has 3 instance(s).
Instance “RACDB1”, status READY, has 1 handler(s) for this service…
Instance “RACDB2”, status READY, has 1 handler(s) for this service…
Instance “RACDB3”, status READY, has 1 handler(s) for this service…
– Make sure all password files at all nodes – orapwNODE1[2-3] – are same. If not, create a password file at each node and provide the same password
– As a Cluster Name, provide the name of the cluster. To get the cluster name, use the following command:
cd $GRID_HOME/bin
./cemutlo –n
– Make sure you’ve ASMSNMP user created at ASM instance and SYSDBA privilege is granted. Do it in the first node, then copy ora+ASM1 to the different nodes under $GRID_HOME/dbs/+ASM[1-2]
Hope above mentioned notes will help you to create EM db control successfully for your RAC environment.
To get more information from metalink, use the following MOS:
How to manage DB Control 11.x for RAC Database with emca (Doc ID 578011.1)
October 12th, 2016 at 11:49 am
Hi Kamaran,
11.2.0.1 database was managed by Enterprise Manager (Database Control)
Database has been upgaded from 11.2.0.1 to 11.2.0.4
ORACLE_HOME for 11.2.0.1 => /u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_HOME for 11.2.0.4 => /u01/app/oracle/product/11.2.0/dbhome_2
Now , i wanna upgrade Enterprise manager to 11.2.0.4
From which path i need to upgrade OEM (following command) ?
$ emca -upgrade db
STARTED EMCA at Oct 12, 2016 3:50:19 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved
Enter the following information:
ORACLE_HOME for the database to be upgraded: /u01/app/oracle/product/11.2.0/dbhome_1
Database SID: ******
Listener port number: 1521
Password for SYS user: …..
Do you wish to continue? [yes(Y)/no(N)]: Y
…
October 12th, 2016 at 11:54 am
Hello. Yes, there’s no need to drop and recreate the dbconsole, you ca use emca -upgrade option to upgrade the database control. Check the following MOS notes for more information:
How To Manually Upgrade DBConsole Configuration After Database Upgrade (Doc ID 1293264.1)
How to Upgrade Database Control Configuration Using EMCA (Doc ID 465518.1)