Kamran Agayev's Oracle Blog

Oracle Certified Master

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)

 

2 Responses to “How to configure Enterprise Manager 11gR2 for RAC environment”

  1. SB Says:

    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

  2. Kamran Agayev A. Says:

    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)

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>