Dropping and rebuilding dbconsole

Steps to drop DB Console:

• emca -deconfig dbcontrol db
  
  STARTED EMCA at May 12, 2009 1:44:07 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: ora02

  Do you wish to continue? [yes(Y)/no(N)]: Y
  May 12, 2009 1:44:11 AM oracle.sysman.emcp.EMConfig perform
  INFO: This operation is being logged at /opt/local/oracle/product/10.2.0.4/cfgtoollogs/emca/ora02/emca_2009-05-12_01-44-07-AM.log.
  May 12, 2009 1:44:12 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
  INFO: Stopping Database Control (this may take a while) …
  Enterprise Manager configuration completed successfully
  FINISHED EMCA at May 12, 2009 1:44:28 AM
  [oracle@dbrv2 bdump]$ /opt/local/oracle/product/admin/ora02/bdump->:dbrv2::[ora02]

 

Steps to create database dbconsole:

• emca -config dbcontrol db

 
STARTED EMCA at May 12, 2009 1:46:05 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: Database SID: ora02
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 ……………. /opt/local/oracle/product/10.2.0.4

Database hostname ……………. dbrv2
Listener port number ……………. 1521
Database SID ……………. ora02
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………

—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: Y
May 12, 2009 1:46:26 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/local/oracle/product/10.2.0.4/cfgtoollogs/emca/ora02/emca_2009-05-12_01-46-05-AM.log.
May 12, 2009 1:46:28 AM oracle.sysman.emcp.EMReposConfig updateReposVars
SEVERE: File/directory /opt/local/oracle/product/10.2.0.4/sysman/emdrep/config/repository.variables does not exist
May 12, 2009 1:46:36 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
May 12, 2009 1:46:43 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /opt/local/oracle/product/10.2.0.4/bin/emctl config emkey -repos
May 12, 2009 1:46:43 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed.
May 12, 2009 1:46:43 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
WARNING: Error securing Database control.
May 12, 2009 1:46:43 AM oracle.sysman.emcp.EMDBPostConfig setWarnMsg
INFO: Error securing Database Control, Database Control has been brought up in non-secure mode. To secure the Database Control execute the following command(s):

1) Set the environment variable ORACLE_SID to ora02
2) /opt/local/oracle/product/10.2.0.4/bin/emctl stop dbconsole
3) /opt/local/oracle/product/10.2.0.4/bin/emctl config emkey -repos -sysman_pwd <>
4) /opt/local/oracle/product/10.2.0.4/bin/emctl secure dbconsole -sysman_pwd <>
5) /opt/local/oracle/product/10.2.0.4/bin/emctl start dbconsole

To secure Em Key, run /opt/local/oracle/product/10.2.0.4/bin/emctl config emkey -remove_from_repos -sysman_pwd <>
May 12, 2009 1:46:43 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
May 12, 2009 1:48:28 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
May 12, 2009 1:48:28 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://dbrv2:1158/em <<<<<<<<<<<>
4) /opt/local/oracle/product/10.2.0.4/bin/emctl secure dbconsole -sysman_pwd <>
5) /opt/local/oracle/product/10.2.0.4/bin/emctl start dbconsole

To secure Em Key, run /opt/local/oracle/product/10.2.0.4/bin/emctl config emkey -remove_from_repos -sysman_pwd <>
[oracle@dbrv2 bdump]$ /opt/local/oracle/product/admin/ora02/bdump->:dbrv2::[ora02]
> emctl status dbconsole
TZ set to US/Central
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://dbrv2:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
——————————————————————
Logs are generated in directory /opt/local/oracle/product/10.2.0.1/dbrv2_ora02/sysman/log
[oracle@dbrv2 bdump]$ /opt/local/oracle/product/admin/ora02/bdump->:dbrv2::[ora02]

On another note, for Linux servers make sure that Listener is not listening on loop back address.

If you have listener is using loop back (lo0) address, then its possible that dbconsole show status of listener as down.

Advertisements