This content has been marked as final. Show 9 replies
I appreacte you reply.
emkey.ora is not in OH/sysman/config, nor the repository. I am planning to do as you sugegsted.
To remove the dbconsole, did you mean to run emca -deconfig?
To configure dbconsole, using emca -config, I guess, should I use -config create or recreate. The manual says that create/recreate will create a database to hold the repository. If I priovide my target database SID for the parameter, will the target database get dropped/recreated, or just overwrittern the SYSMAN schema?
I tried to deconfig like below:
[oracle@cchdb archivelog]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Jun 12, 2009 11:20:35 AM
EM Configuration Assistant, Version 188.8.131.52.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: TDEV
Listener port number: 1521
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: yes
Jun 12, 2009 11:33:59 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/TDEV/emca_2009_06_12_11_20_35.log.
Jun 12, 2009 11:34:00 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jun 12, 2009 11:34:04 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Jun 12, 2009 11:34:04 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
It took quite long time and block any connections to the database (session already open can still query the database).
Did I do anything wrong?