The Enterprise Manager console will not work when database host name and / or IP address changes. We must run EMCA tool for reconfiguring the OEM database console. To do this, use the following commands.
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
or
emca -deconfig dbcontrol db
emca -config dbcontrol db -repos recreate
TNS konfigürasyonumuz değişir ise (Örneğin dinleyici(listener) portumuz değişirse), bu durumda yine EMCA aracı ile aşağıdaki gibi tekrar konfigürasyonumuzu yapabiliriz.
If our TNS configuration changes (for example, the listener (listener) port is changed), in this case we can still configure with the EMCA tool as follows.
emca -config dbcontrol db
Example: EMCA wants some information during repository drop and create operation. Such as SID, listener port number, SYS and SYSMAN passwords.
talip /oracle/ora11gR2> emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
http://dbtalip:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control … … Stopped.
talip /oracle/ora11gR2> emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Nov 29, 2011 9: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 SID: TEST11GR2
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
———————————————————————- WARNING : While repository is dropped the database will be put in quiesce mode. ———————————————————————-
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at
/oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_16_30.log.
Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) …
Nov 29, 2011 9:16:55 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) …
Nov 29, 2011 9:19:15 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Nov 29, 2011 9:19:18 AM
talip /oracle/ora11gR2> emca -config dbcontrol db -repos create
STARTED EMCA at Nov 29, 2011 9:19:25 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: TEST11GR2
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/ora11gR2 ]:
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/ora11gR2
Local hostname ……………. dbtalip
Listener ORACLE_HOME ……………. /oracle/ora11gR2
Listener port number ……………. 1521
Database SID ……………. TEST11GR2
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 29, 2011 9:19:46 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at
/oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_19_24.log.
Nov 29, 2011 9:19:47 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Nov 29, 2011 9:26:16 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 29, 2011 9:26:22 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) …
Nov 29, 2011 9:27:19 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 29, 2011 9:27:21 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://dbtalip:1158/em <<<<<<<<<<<
Nov 29, 2011 9:28:13 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in th file:
/oracle/ora11gR2/dbtalip_TEST11GR2/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will becom unusable if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 29, 2011 9:28:13 AM
talip /oracle/ora11gR2> 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://dbtalip:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running. ——————————————————————
Logs are generated in directory /oracle/ora11gR2/dbtalip_TEST11GR2/sysman/log talip /oracle/ora11gR2>
Now, OEM is available.
Talip Hakan Öztürk
Talip Hakan Ozturk's ORACLE BLOG 