Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



Enterprise Manager

Lost emkey.ora

We have an 11g on Linux. The previous DBA left silently and I need to dig out what are there. One of the problem is Enterprise Manager. I believe we are use database control not grid control. Have problem to make it work  emctl Start dbconsole  - ok  go to web browser to connect to the service, get message: Service is not initialized correctly. The Em Key is not configured properly. Run "emctl status emkey" for more details  [oracle@cchdb config]$ emctl status emkey Oracle Enterprise Manager 11g Database Control Release Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved. Please enter repository password:  The Em Key is not configured properly or is corrupted in the file system and does not exist in the Management Repository. To correct the problem: 1) Copy the emkey.ora file from another OMS or backup machine to the OH/sysman/config directory. 2) Configure the emkey.ora file by running "emctl config emkey -emkeyfile <emkey.ora file location>".  Not sure if there is 1 or more OMS installed. What is the best to do next?  Related questions: 1) how to I find if there are OMS installed or running? what is OMS the installation location and process on Linux. 2) If recreate repository, would it be created in the target database, or another database dedicated to OEM?  THANKS.

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?  Thanks

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 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   Accessibility Mode  Disabled   Why the Accessibility Mode is disabled. Is this the right mode?  Thanks

Yes this expected ,please check the doc.


Related Links

monitor exclusive lock on a table and send notification email through EM
Job Scheduler used for "other" tasks
11g loopback adapter static ip, dbconsole fails after install wired LAN NIC
Question about Grid Control Agents on a Veritas Cluster (or any cluster)
Oracle 10g EM DB console Host Preferred Credentials for linux:::::HELP
Oracle 10g EM DB console Host Preferred Credentials for linux:::::HELP
GridControl ( shows Standby DB's as "Database instance"
Issues when upgrading to Release 4
Is agent install software available on SLES10
Change Manager standalone repository create failing
Error message when creating export Job via GRID
Service Level Management (SLM) pack?
Update:: New OTN Mass Agent Deployment page
Grdi on Windows 2008 Servers
disk full
Database is not appearing OMS.