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.EMConfi g perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at /cm4/oracle/cfgtoollogs/db ca/put8/em Config.log for more
details.
Jul 21, 2009 4:09:50 PM oracle.sysman.emcp.EMConfi g perform
CONFIG: Stack Trace:
oracle.sysman.emcp.excepti on.EMConfi gException : 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.sq l
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_M NTR'
,'ECM_UTIL') ;
SQL> spool off
Then execute the script del_public_synonym_mgmt.sq l
Also tried;
ACTION PLAN
============
1.- remove the following directories from your filesystem:
<ORACLE_HOME>/<hostname_si d>
<ORACLE_HOME>/oc4j/j2ee/OC 4J_DBConso le_<hostna me>_<sid>
Note: On Windows you aslo need to delete the DB Console service:
- run regedit
- navigate to HKEY_LOCAL_MACHINE/SYSTEM/ CurrentCon trolSet/Se rvices
- 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.rem ove_em_dbm s_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.prope rties.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.EMConfi g perform
SEVERE: Error instantiating EM configuration files
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.EMConfi
SEVERE: Error instantiating EM configuration files
Refer to the log file at /cm4/oracle/cfgtoollogs/db
details.
Jul 21, 2009 4:09:50 PM oracle.sysman.emcp.EMConfi
CONFIG: Stack Trace:
oracle.sysman.emcp.excepti
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.sq
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_M
,'ECM_UTIL') ;
SQL> spool off
Then execute the script del_public_synonym_mgmt.sq
Also tried;
ACTION PLAN
============
1.- remove the following directories from your filesystem:
<ORACLE_HOME>/<hostname_si
<ORACLE_HOME>/oc4j/j2ee/OC
Note: On Windows you aslo need to delete the DB Console service:
- run regedit
- navigate to HKEY_LOCAL_MACHINE/SYSTEM/
- 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.rem
* EXEC sysman.setEMUserContext(''
* 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
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.EMConfi
SEVERE: Error instantiating EM configuration files
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Still not resolved. Working with Oracle corp to resolve
Good luck!
ASKER
Tried you solution still getting same error; I stopped and restarted listener
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMConfi
SEVERE: Error instantiating EM configuration files
Refer to the log file at /cm4/oracle/cfgtoollogs/em
Could not complete the configuration. Refer to the log file at /cm4/oracle/cfgtoollogs/em
Here is the last few lings from the log;
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.util.Pl
WARNING: Error executing /build.local/dm10_tools/or
oracle/bin/targetdeploy.pl
put8
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMAgent
s
CONFIG: Failed to deploy state dirs
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMConfi
SEVERE: Error instantiating EM configuration files
Refer to the log file at /cm4/oracle/cfgtoollogs/em
-46-PM.log for more details.
Aug 17, 2009 3:07:57 PM oracle.sysman.emcp.EMConfi
CONFIG: Stack Trace:
oracle.sysman.emcp.excepti
tion files
at oracle.sysman.emcp.EMAgent
.java:2578)
at oracle.sysman.emcp.EMAgent
ava:1184)
at oracle.sysman.emcp.EMAgent
at oracle.sysman.emcp.EMAgent
at oracle.sysman.emcp.EMConfi
at oracle.sysman.emcp.EMConfi
a:479)
at oracle.sysman.emcp.EMConfi
istant.java:1123)
at oracle.sysman.emcp.EMConfi
a:463)
at oracle.sysman.emcp.EMConfi
Is there anything else I can try?