Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Managing OEM Database Control with emca for RAC 11gR2

Managing OEM Database Control with emca for RAC 11gR2

In the article you will have a look at using emca with Oracle RAC for managing OEM DC. OEM Database control can be configured either with dbca or with emca.

Starting with Oracle 10gR1 RAC upon configuring OEM DC one DC console and agent was running on each node of the cluster. After Oracle 10gR2 the behavior changed so that by default a console is started only on the node where dbca or emca was started to configure OEM DC. However, OEM DC is configured to run on each of the cluster nodes where RAC database has configured instances ( 11gR2 administrator-managed). Starting OEM DC starts OEM DC console and the agent on the default node, whereas on the all other nodes only OEM agent is started. Oracle RAC also supports running OEM DC consoles on more than one node, though it makes sense on multi-nodes clusters.

  1. Recreate OEM DC configuration after change (IP) or in general if nothing else works.

    emca -deconfig dbcontrol db -repos drop -cluster

    emca -config dbcontrol db -repos create -cluster

    or

    emca -deconfig dbcontrol db -cluster

    emca -config dbcontrol db -repos recreate -cluster

  2. Change port

    emca -reconfig ports -DBCONTROL_HTTP_PORT port# port_number -cluster

    emca -reconfig ports -JMS_PORT port# -cluster

    emca -reconfig ports -RMI_PORT port# -cluster

    emca -reconfig ports -AGENT_PORT port_number –cluster

  3. Enabling OEM DC on two nodes.

    An additional console will be created and started on the second node. The initial configuration is follows.

    -bash-3.00$ emca -displayConfig dbcontrol -cluster

    STARTED EMCA at Jul 6, 2011 12:16:31 AM

    EM Configuration Assistant, Version 11.2.0.0.2 Production

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:

    Database unique name: RACDB

    Service name: RACDB

    Do you wish to continue? [yes(Y)/no(N)]: y

    Jul 6, 2011 12:16:48 AM oracle.sysman.emcp.EMConfig perform

    INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/RACDB/e mca_2011_07_06_00_16_29.log.

    Jul 6, 2011 12:16:58 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMes sage

    INFO:

    **************** Current Configuration ****************

    INSTANCE NODE DBCONTROL_UPLOAD_HOST

    ———- ———- ———————

    RACDB sol1 sol1

    RACDB sol2 sol1

    Agents on each node are uploading to sol1 host.

    On each node of the cluster (sol1,sol2) status is as follows:

    sol2

    -bash-3.00$ emctl status dbconsole

    Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

    Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

    https://sol1:1158/em/console/aboutApplication

    EM Daemon is running.

    ——————————————————————

    Logs are generated in directory /u01/app/oracle/product/11.2.0.2/db_1/sol2_RACDB/sysman/log

    -bash-3.00$

    sol1

    -bash-3.00$ emctl status dbconsole

    Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

    Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

    https://sol1:1158/em/console/aboutApplication

    Oracle Enterprise Manager 11g is running.

    ——————————————————————

    Logs are generated in directory /u01/app/oracle/product/11.2.0.2/db_1/sol1_RACDB/sysman/log

    -bash-3.00$

    It might be useful for multi node clusters to have more than one console on different nodes. Having more than one console allows to split the upload from the cluster agents into the available OEM DC consoles. Each console will r be used for uploads from a portion of cluster nodes. Each cluster node agent can upload to only one console. Node sol2 will be used to start a second OEM DC console and for upload a portion ( sol2 in case of two node cluster if multi-node cluster nodes can be split equally) . EM_NODE is the node for the additional console. EM_NODE_LIST is a list of the agent nodes that will upload to EM_NODE console. An agent can upload to only one console and local agents upload to the console of the same node if exists.

    -bash-3.00$ emca -reconfig dbcontrol -cluster -EM_NODE sol2 -EM_NODE_LIST sol2

    STARTED EMCA at Jul 6, 2011 2:07:29 AM

    EM Configuration Assistant, Version 11.2.0.0.2 Production

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:

    Database unique name: RACDB

    Service name: RACDB

    Do you wish to continue? [yes(Y)/no(N)]: y

    Jul 6, 2011 2:08:02 AM oracle.sysman.emcp.EMConfig perform

    INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/RACDB/emca_2011_07_06_02_06_38.log.

    Jul 6, 2011 2:10:01 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

    INFO: Stopping Database Control (this may take a while) …

    Jul 6, 2011 2:10:25 AM oracle.sysman.emcp.EMAgentConfig performDbcReconfiguration

    INFO: Propagating /u01/app/oracle/product/11.2.0.2/db_1/sol2_RACDB/sysman/config/emd.properties to remote nodes …

    Jul 6, 2011 2:10:26 AM oracle.sysman.emcp.util.DBControlUtil startOMS

    INFO: Starting Database Control (this may take a while) …

    Jul 6, 2011 2:12:04 AM oracle.sysman.emcp.EMDBPostConfig performDbcReconfiguration

    INFO: Database Control started successfully

    Jul 6, 2011 2:12:32 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage

    INFO:

    **************** Current Configuration ****************

    INSTANCE NODE DBCONTROL_UPLOAD_HOST

    ———- ———- ———————

    RACDB sol1 sol1

    RACDB sol2 sol2

    Enterprise Manager configuration completed successfully

    FINISHED EMCA at Jul 6, 2011 2:12:32 AM

    -bash-3.00$

    The status changes as follows:

    Sol2

    -bash-3.00$ emctl status dbconsole

    Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

    Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

    https://sol2:1158/em/console/aboutApplication

    Oracle Enterprise Manager 11g is running.

    ——————————————————————

    Logs are generated in directory /u01/app/oracle/product/11.2.0.2/db_1/sol2_RACDB/sysman/log

    -bash-3.00$

    sol1

    -bash-3.00$ emctl status dbconsole

    Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

    Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

    https://sol1:1158/em/console/aboutApplication

    Oracle Enterprise Manager 11g is running.

    ——————————————————————

    Logs are generated in directory /u01/app/oracle/product/11.2.0.2/db_1/sol1_RACDB/sysman/log

    -bash-3.00$

    Access and login from node sol1

    Access and login from node sol2.

Reference:

Oracle® Real Application Clusters Installation Guide 11g Release 2 (11.2) for Linux and UNIX

NOTE:289966.1 – How to Change the Port Numbers for DB Control 10.1.x.x

NOTE:330130.1 – Overview Of The EMCA Commands Available for DB Control 10.2 Installations

NOTE:330689.1 – How to Trace / Debug the EMCA Tool in 10g and 11g

NOTE:362524.1 – Configure DB Control 10.2, 11g for use in Active/Passive High Availability Environments

NOTE:375946.1 – Running EMCA Results in Database quiesce And No New Connections or Operations Can Be Performed During the DB Control Repository Creation

NOTE:395162.1 – How to manage DB Control 10.2 for RAC Database with emca

NOTE:395755.1 – How to Change Ports for DBControl

NOTE:400476.1 – How to change a 10.2.0.x Database from Locally Managed to Centrally Managed

July 6, 2011 - Posted by | oracle

1 Comment »

  1. very good Post , I really appreciate ……….

    Comment by DDS | August 23, 2012 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 779 other followers

%d bloggers like this: