Search This Blog

Monday, September 12, 2011

SEVERE: Dbcontrol Repository already exists. Oracle 10gr2

When trying to create oracle enterprise manager console on linux oracle 10gr2 emca command ended with the following error
-bash-3.00$ export ORACLE_SID=orcl
-bash-3.00$ ./emctl status dbconsole
TZ set to Asia/Dubai
OC4J Configuration issue. /db/app/oracle/Db_1/oc4j/j2ee/OC4J_DBConsole_spioradev                                                                             .dummy.local_orcl not found.
-bash-3.00$ ./emca -config dbcontrol db -repos create

STARTED EMCA at Sep 12, 2011 3:39:49 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
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 ................ /db/app/oracle/Db_1

Local hostname ................ spioradev.dummy.local
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 12, 2011 3:42:06 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /db/app/oracle/Db_1/cfgtoollogs/emca/orc                                                                             l/emca_2011-09-12_03-39-49-PM.log.
Sep 12, 2011 3:42:07 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Config                                                                           uration Assistant again in standalone mode.

This error occurred because we are trying to create enterprise repository and configuration files both. but in this case "oem repository is already exist" (sysman user already exist).

Solution: just remove the following parameter from the emca command

./emca -config dbcontrol db -repos create
and reexecute the emca command like below

-bash-3.00$ emca -config dbcontrol db

STARTED EMCA at Sep 12, 2011 4:11:05 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN 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 ................ /db/app/oracle/Db_1

Local hostname ................ spioradev.dummy.local
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 12, 2011 4:11:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /db/app/oracle/Db_1/cfgtoollogs/emca/orcl/emca_2011-09-12_04-11-05-PM.log.
Sep 12, 2011 4:11:33 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 12, 2011 4:12:33 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Sep 12, 2011 4:12:33 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 12, 2011 4:14:30 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 12, 2011 4:14:30 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://spioradev.dummy.local:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 12, 2011 4:14:30 PM

No comments: