Link to home
Start Free TrialLog in
Avatar of kaypoo
kaypoo

asked on

Cannot install ORACLE OEM TOOL- Not able to run OEM after Oracle 10G install;SEVERE: Error instantiating EM conf

Problem Description:
Linux ES 4.0
Oracle 10G Production edition

Oracle database up and running, able to SQL. Not able to bring up EM console via port 1158 or
5500; Executed emctl status and emctl Start. Also ran DBCA to configure the
database. Please give me a call.

Error Log;
CONFIG: Failed to deploy state dirs
Jul 21, 2009 4:09:50 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at /cm4/oracle/cfgtoollogs/dbca/put8/emConfig.log for more
details.
Jul 21, 2009 4:09:50 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error instantiating EM configura
tion files

I have Deleted DB Control Configuration Files and Repository Objects using EMCA using
emca -deconfig dbcontrol db -repos drop
but when i am trying to create the same using
emca -config dbcontrol db -repos create

Also tried + To delete the dbconsole :- Drop the repository users -

drop user sysman cascade;
drop user mgmt_view cascade;

- Drop the role mgmt_user :

drop role mgmt_user;

- Drop all public synonyms on repository objects -
You can create a sql script to generate the drop statements and then
execute the script
created -

set ver 0
set echo off
set pages 999
set feed 0
set heading off
Spool del_public_synonym_mgmt.sql
Select 'Drop public synonym ' || synonym_name || ';'
from dba_synonyms
where synonym_name like 'MGMT%' OR
synonym_name like 'SMP_EMD%' OR
synonym_name like 'SMP_MGMT%' OR
synonym_name in ('SETEMVIEWUSERCONTEXT' ,'DBMS_SHARED_POOL','EMD_MNTR'
,'ECM_UTIL') ;

SQL> spool off

Then execute the script del_public_synonym_mgmt.sql

Also tried;
ACTION PLAN
============
1.- remove the following directories from your filesystem:
<ORACLE_HOME>/<hostname_sid>
<ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>

Note: On Windows you aslo need to delete the DB Console service:
- run regedit
- navigate to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services
- locate the OracleDBConsole<sid> entry and delete it

OR you can delete the service as per following command
1. Run the command:
'sc delete <service_name>'
- where <service_name> is the DB Control service name (typically: OracleDBConsole<sid>)

B) To delete the repository

Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and mangement objects:


* SHUTDOWN IMMEDIATE;
* STARTUP RESTRICT;
* EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
* EXEC sysman.setEMUserContext('',5);
* REVOKE dba FROM sysman;
* DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN'
;
BEGIN
FOR r1 IN c1 LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;
* DROP USER mgmt_view CASCADE;
* DROP ROLE mgmt_user;
* DROP USER sysman CASCADE;
* ALTER SYSTEM DISABLE RESTRICTED SESSION;

Note: The above will completely delete the DB Control repository from the database; under cert
ain circumstances (e.g. you

want to recreate the repository later on) the following statemnts may be sufficient to remove the repository:

a. drop user sysman cascade;
b. drop role MGMT_USER;
c. drop user MGMT_VIEW cascade;
d. drop public synonym MGMT_TARGET_BLACKOUTS;
e. drop public synonym SETEMVIEWUSERCONTEXT;
ACTION PLAN
============
Please perform following and check if the issue is resolved.

1. Open the file $ORACLE_HOME/sysman/config/emd.properties.emca
2. Check if that file contains the correct ORACLE_HOME path and replace the wrong path.
3. Re--install the DBConsole.
3.1 Remove the existing configuration if needed: emca -deconfig dbcontrol db -repos drop
3.2 Re-config DBConsole: emca -config dbcontrol db -repos create

Same error message Aug 5, 2009 4:13:09 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files


ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kaypoo
kaypoo

ASKER

Hi Schwertner

Tried you solution still getting same error; I stopped and restarted listener
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at /cm4/oracle/cfgtoollogs/emca/put8/emca_2009-08-17_03-03-46-PM.log for more details.
Could not complete the configuration. Refer to the log file at /cm4/oracle/cfgtoollogs/emca/put8/emca_2009-08-17_03-03-46-PM.log for more details.

Here is the last few lings from the log;

Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /build.local/dm10_tools/oracle10202/perl/bin/perl /cm4/
oracle/bin/targetdeploy.pl /cm4/oracle/t06tcscmu.tcs.com_put8 t06tcscmu.tcs.com
put8
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFile
s
CONFIG: Failed to deploy state dirs
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at /cm4/oracle/cfgtoollogs/emca/put8/emca_2009-08-17_03-03
-46-PM.log for more details.
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error instantiating EM configura
tion files
        at oracle.sysman.emcp.EMAgentConfig.updateAgentConfigFiles(EMAgentConfig
.java:2578)
        at oracle.sysman.emcp.EMAgentConfig.performConfiguration(EMAgentConfig.j
ava:1184)
        at oracle.sysman.emcp.EMAgentConfig.invoke(EMAgentConfig.java:214)
        at oracle.sysman.emcp.EMAgentConfig.invoke(EMAgentConfig.java:192)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:146)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.jav
a:479)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAss
istant.java:1123)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.jav
a:463)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)


Is there anything else I can try?

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kaypoo

ASKER

I have set LD_LIBRARY_PATH, ORACLE_SID and ORACLE_HOME.  I did change the install to reflect the correct path.  Does anyone have the original install script of the EM that I can run?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kaypoo

ASKER

Still not resolved. Working with Oracle corp to resolve
Good luck!