How to Configure OEM 10g DB Control after Clone

In this post, I would like to share the way of bringing up the database Enterprise Manager control 10g from cloned Oracle Apps test instance.
[oratest@testdb ~]$ emctl start dbconsole
TZ set to Asia/Dubai
OC4J Configuration issue. /oracle/testdb/10.2.0/oc4j/j2ee/OC4J_DBConsole_test.apps.local_TEST not found.
[oratest@testdb ~]$
In this stage, I know DB Console wasn't configured to this instance yet.
Then using emca I have tried to recreate the DB Control configuration files as follows:
[oratest@testdb ~]$ emca -config dbcontrol db
STARTED EMCA at May 11, 2010 7:16:31 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TEST
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
---------------------------
You have specified the following settings
Database ORACLE_HOME ................ /oracle/testdb/10.2.0
Database hostname ................ test.apps.local
Listener port number ................ 1521
Database SID ................ TEST
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
May 11, 2010 7:18:34 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/testdb/10.2.0/cfgtoollogs/emca/TEST/emca_2010-05-11_07-16-31-AM.log.
May 11, 2010 7:18:41 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
May 11, 2010 7:18:50 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
May 11, 2010 7:18:50 AM oracle.sysman.emcp.EMDBPostConfig
performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://test.apps.local:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 11, 2010 7:18:50 AM
[oratest@testdb ~]$
When I have tried to opened the DB Console using http://test.apps.local:5500/em, getting the following error message
error:
java.lang.Exception: Exception in sending Request :: null

This will not solve this issue, the right method of configuration of Enterprise Manager Control 10g is as follows. After the cloning procedure completed in db tier, do these steps one bye one.
There are two issues need to fix in the env_sysman.mk file, then need to relink manually for Agent component



1.Stop DB Console: 

emctl stop dbconsole 

2. cd $ORACLE_HOME/sysman/lib 

  

3. Edit env_sysman.mk and look for "JRE_LIB_DIR" 
In my instance JRE_LIB_DIR was populated with the old environment name.. 
I changed it from: 
JRE_LIB_DIR=/oracle/prod/db/proddb/10.2/jdk/jre/lib/i386 
To: 
JRE_LIB_DIR=/oracle/test/db/testdb/10.2/jdk/jre/lib/i386


4. One more issue for env_sysman.mk, look for "$(LIBNMEM)  $(LIBNMER)" 
And change from: 

$(LIBNMEM)  $(LIBNMER) \
To: 
$(LIBNMEM)  $(LIBNMER) $(LIBNMO) \


5. Now relink the Agent component by issuing this command: 
make -f ins_sysman.mk agent


6. Recreate the DB Control configuration files once again, if already done it 
emca -config dbcontrol db 


Now Enterprise Manager control is configured perfectly and coming up as usual from cloned instance and I can able to see everything fine in that screen.

Related Posts by Categories