This content has been marked as final. Show 9 replies
check emkey.ora exist in the OH/sysman/config/emkey.ora
also if not there then check in the repos it exist or not
and if both places it not there then you have to remove the dbconsole and configure it again
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?
you need to follow the steps as below
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
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 126.96.36.199.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?
Please stop the running dbconsole/isqlplus, bounce the database and try again
Yes. This works. I drop/create the repository and beable to see the OEM page. But in the welcome page, it says
Oracle Enterprise Manager Database Console 188.8.131.52.0
Accessibility Mode Disabled
Why the Accessibility Mode is disabled. Is this the right mode?
Yes this expected ,please check the doc.
Thanks, I had a problem setting up EM on my laptop - the console service was not starting after the domain on my laptop was changed. Your tip did the trick.