Home » RDBMS Server » Enterprise Manager » Cannot create EM on oracle 11gR2
Cannot create EM on oracle 11gR2 [message #474127] Fri, 03 September 2010 00:21 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

I have migrated my oracle 10g database to 11gR2. After migration, em was not starting due to OC4J Configuration issue:

oracle:/oracle/app/oracle/product/11gdb/network/admin:sun1#emctl start dbconsole
OC4J Configuration issue. /oracle/app/oracle/product/11gdb/oc4j/j2ee/OC4J_DBConsole_sun1_cnp1 not found.


I run the command below:

oracle:/oracle/app/oracle/product/11gdb/network/admin:sun1#emca -config dbcontrol db -repos recreate

STARTED EMCA at Sep 3, 2010 9:07:48 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: cnp1
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/app/oracle/product/11gdb ]:
Password for SYS user:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /oracle/app/oracle/product/11gdb

Local hostname ................ sun1
Listener ORACLE_HOME ................ /oracle/app/oracle/product/11gdb
Listener port number ................ 1521
Database SID ................ cnp1
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 3, 2010 9:08:09 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/cfgtoollogs/emca/cnp/emca_2010_09_03_09_07_46.log.
Sep 3, 2010 9:08:11 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
Refer to the log file at /oracle/app/oracle/cfgtoollogs/emca/cnp/emca_2010_09_03_09_07_46.log for more details.
Could not complete the configuration. Refer to the log file at /oracle/app/oracle/cfgtoollogs/emca/cnp/emca_2010_09_03_09_07_46.log for more details.


I am able to connect using tnsnames.ora:

sun1#sqlplus mnsroc/mnsroc@cnp

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 3 09:19:07 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>



------------------

please find my listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/11gdb)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.64)(PORT = 1521))
)
)
----------------

tnsnames.ora

CNP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sun1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = cnp.intnet.mu)
(INSTANCE_NAME = cnp1)
)
)


Thanks,

sailesh
Re: Cannot create EM on oracle 11gR2 [message #474190 is a reply to message #474127] Fri, 03 September 2010 08:15 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Try adding the database sid to the listener.ora file:
#...Etc...
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/app/oracle/product/11gdb)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = cnp1.world)
      (SID_NAME = cnp1)
      (ORACLE_HOME = /oracle/app/oracle/product/11gdb)
    )
  )
#...Etc...

And remember to...lsnrctl reload



[Updated on: Fri, 03 September 2010 10:10] by Moderator

Report message to a moderator

Re: Cannot create EM on oracle 11gR2 [message #474449 is a reply to message #474127] Mon, 06 September 2010 08:48 Go to previous messageGo to next message
ramsaym1
Messages: 13
Registered: September 2010
Location: London
Junior Member
Silly question, but have you checked to see if the listener and DB are actually running. Also, you may wish to try a two step approach. A deinstall, followed be a reinstall.

My site oracle-wiki.net has a useful topic on this.

Check out the How to Guides.

Regards
icon6.gif  Re: Cannot create EM on oracle 11gR2 [message #474481 is a reply to message #474449] Mon, 06 September 2010 12:48 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
ramsaym1 wrote on Mon, 06 September 2010 09:48
Silly question, ...etc... Also, you may wish to try a two step approach. A deinstall, followed be a reinstall.

Typical WinDoze approach, why not re-boot also?
Laughing
Re: Cannot create EM on oracle 11gR2 [message #474535 is a reply to message #474449] Tue, 07 September 2010 00:07 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,


My listener is up and running together with my DB.


Thanks,


Sailesh
Re: Cannot create EM on oracle 11gR2 [message #474564 is a reply to message #474535] Tue, 07 September 2010 04:30 Go to previous messageGo to next message
ramsaym1
Messages: 13
Registered: September 2010
Location: London
Junior Member
Can you connect to the sysman and dbsnmp user okay?
Re: Cannot create EM on oracle 11gR2 [message #474571 is a reply to message #474564] Tue, 07 September 2010 05:30 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
hi,

Yes i am able to connect through sysman, dbsnmp.

oracle:/oracle/app/oracle/product/11gdb:sun1#sqlplus sysman/password@cnp

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 7 14:28:16 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


oracle:/oracle/app/oracle/product/11gdb:sun1#sqlplus dbsnmp/password@cnp

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 7 14:28:53 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


thanks,

sailesh


Thanks,

Sailesh
Re: Cannot create EM on oracle 11gR2 [message #474573 is a reply to message #474127] Tue, 07 September 2010 05:51 Go to previous messageGo to next message
ramsaym1
Messages: 13
Registered: September 2010
Location: London
Junior Member
Have you tried the uninstall first? Also can you post or send me the contents of the log file.
Re: Cannot create EM on oracle 11gR2 [message #474589 is a reply to message #474573] Tue, 07 September 2010 07:32 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

I had drop it a number of times.

Please see log file.

Thanks,


Sailesh
Re: Cannot create EM on oracle 11gR2 [message #474592 is a reply to message #474589] Tue, 07 September 2010 07:48 Go to previous messageGo to next message
ramsaym1
Messages: 13
Registered: September 2010
Location: London
Junior Member
So have you managed to reinstall now?
Re: Cannot create EM on oracle 11gR2 [message #474596 is a reply to message #474592] Tue, 07 September 2010 07:55 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

I have just redrop it and i am recreating it. I will post you the log file shortly. Every time, i have drop it, it drops successfully.

Let's hope it works this time.


Thanks,


Sailesh
Re: Cannot create EM on oracle 11gR2 [message #474669 is a reply to message #474592] Wed, 08 September 2010 01:02 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

Please find log files while creation.
Re: Cannot create EM on oracle 11gR2 [message #474670 is a reply to message #474669] Wed, 08 September 2010 01:02 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
hi,

second log file
Re: Cannot create EM on oracle 11gR2 [message #474671 is a reply to message #474670] Wed, 08 September 2010 01:03 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
hi,

Please find 3rd log file.


Thanks,

Sailesh
Re: Cannot create EM on oracle 11gR2 [message #474694 is a reply to message #474671] Wed, 08 September 2010 04:59 Go to previous messageGo to next message
ramsaym1
Messages: 13
Registered: September 2010
Location: London
Junior Member
The error is to do with TZ: ORA-01882: timezone region not found

I would log a call with Oracle support as you may be hitting a bug around timezones. Bug 9480056 mentions that some supported TZ don't work for 11.2.0.1 dbconsole.

Regards
Re: Cannot create EM on oracle 11gR2 [message #474703 is a reply to message #474694] Wed, 08 September 2010 06:12 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
HI,

Please if you can update me once you get a solution.


Thanks,

Sailesh
Re: Cannot create EM on oracle 11gR2 [message #474708 is a reply to message #474703] Wed, 08 September 2010 06:35 Go to previous messageGo to next message
ramsaym1
Messages: 13
Registered: September 2010
Location: London
Junior Member
LOL Too funny!!! You will have to log the call with Oracle.
Re: Cannot create EM on oracle 11gR2 [message #474814 is a reply to message #474708] Thu, 09 September 2010 02:32 Go to previous message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

I have been able to config my em. The problem was with TIMEZONE setting. It is not a bug as you have mentioned.

first my default time zone while installation solaris 10 was Indian/mauritius.But unfortunately Indian/mauritius is not recognised as a time zone in oracle. see command below:

SQL> SELECT unique(TZNAME) FROM v$timezone_names where upper(TZNAME) like upper( '%mauritus%');

no rows selected

SQL>

i have changed my time zone in /etc/TIMEZONE file on solaris 10 from Indian/Mauritius to Asia Dubai.

SQL> SELECT unique(TZNAME) FROM v$timezone_names where upper(TZNAME) like upper('%Asia/Dubai%');

TZNAME
----------------------------------------------------------------
Asia/Dubai


To be able to know all the information above, i have run this script:

begin
for v_rec in (select tzname,tz_offset(tzname) v_offset from v$timezone_names
where tzabbrev='LMT') loop
dbms_output.put_line('tzname '||v_rec.tzname||', offset '||
v_rec.v_offset);
end loop;
end
;

On oracle 11gR2 i had to drop these synomyms for em.

DROP USER sysman CASCADE;
DROP USER mgmt_view CASCADE;
DROP ROLE MGMT_USER;
ALTER USER dbsnmp ACCOUNT UNLOCK;
ALTER USER dbsnmp identified by dbsnmp;
DROP PUBLIC SYNONYM SETEMVIEWUSERCONTEXT;
DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
DROP PUBLIC SYNONYM MGMT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_CURRENT_AVAILABILITY;
DROP PUBLIC SYNONYM MGMT_SEVERITY_OBJ;
DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY;
DROP PUBLIC SYNONYM MGMT_GUID_OBJ;
DROP PUBLIC SYNONYM MGMT_GUID_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ;
DROP PUBLIC SYNONYM SMP_EMD_TARGET_OBJ_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_DELETE_REC_ARRAY;
DROP PUBLIC SYNONYM MGMT_METRICS;
DROP PUBLIC SYNONYM MGMT_TARGETS;
DROP PUBLIC SYNONYM MGMT_TYPE_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_TARGET_PROPERTIES;
DROP PUBLIC SYNONYM MGMT_METRICS_RAW;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRICS;
DROP PUBLIC SYNONYM MGMT_STRING_METRIC_HISTORY;
DROP PUBLIC SYNONYM MGMT_LONG_TEXT;
DROP PUBLIC SYNONYM MGMT_METRICS_COMPOSITE_KEYS;
DROP PUBLIC SYNONYM MGMT_METRICS_1HOUR;
DROP PUBLIC SYNONYM MGMT_METRICS_1DAY;
DROP PUBLIC SYNONYM MGMT_METRIC_ERRORS;
DROP PUBLIC SYNONYM MGMT_CURRENT_METRIC_ERRORS;
DROP PUBLIC SYNONYM EMD_MNTR;
DROP PUBLIC SYNONYM MGMT_METRIC_COLLECTIONS;
DROP PUBLIC SYNONYM MGMT_COLLECTION_PROPERTIES ;
DROP PUBLIC SYNONYM MGMT_METRIC_THRESHOLDS;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR;
DROP PUBLIC SYNONYM SMP_EMD_NVPAIR_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_STRING_ARRAY_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY;
DROP PUBLIC SYNONYM SMP_EMD_INTEGER_ARRAY_ARRAY;
DROP PUBLIC SYNONYM MGMT_DELTA_IDS;
DROP PUBLIC SYNONYM MGMT_DELTA_ID_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY;
DROP PUBLIC SYNONYM MGMT_DELTA_ENTRY_VALUES;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUE;
DROP PUBLIC SYNONYM MGMT_DELTA_VALUES;
DROP PUBLIC SYNONYM MGMT_NAME_VALUE;
DROP PUBLIC SYNONYM MGMT_NAME_VALUES;
DROP PUBLIC SYNONYM ECM_UTIL;

DROP PUBLIC SYNONYM MGMT_DELTA;
DROP PUBLIC SYNONYM MGMT_TARGET_MEMBERSHIPS;
DROP PUBLIC SYNONYM MGMT_JOB;
DROP PUBLIC SYNONYM MGMT_JOB_PARAMETER;
DROP PUBLIC SYNONYM MGMT_JOB_TARGET;
DROP PUBLIC SYNONYM MGMT_JOB_SCHEDULE;
DROP PUBLIC SYNONYM MGMT_JOB_EXECPLAN;
DROP PUBLIC SYNONYM MGMT_JOB_EXEC_SUMMARY;
DROP PUBLIC SYNONYM MGMT_JOB_OUTPUT;
DROP PUBLIC SYNONYM MGMT_JOB_EXECUTION;
DROP PUBLIC SYNONYM MGMT_LOG;
DROP PUBLIC SYNONYM MGMT_ADMIN;
DROP PUBLIC SYNONYM MGMT_GLOBAL;
DROP PUBLIC SYNONYM MGMT_TARGET;
DROP PUBLIC SYNONYM MGMT_CREDENTIAL;
DROP PUBLIC SYNONYM MGMT_JOBS;
DROP PUBLIC SYNONYM MGMT_PREFERENCES;
DROP PUBLIC SYNONYM MGMT_USER;
DROP PUBLIC SYNONYM MGMT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_CURRENT_SEVERITY;
DROP PUBLIC SYNONYM MGMT_PAF_PROCS_LATEST;
DROP PUBLIC SYNONYM MGMT_PAF_JOBS;
DROP PUBLIC SYNONYM MGMT_PAF$PROCEDURES;
DROP PUBLIC SYNONYM MGMT_PAF$INSTANCES;
DROP PUBLIC SYNONYM MGMT_PAF$STATES;
DROP PUBLIC SYNONYM MGMT_PAF$APPLICATIONS;
DROP PUBLIC SYNONYM MGMT_VIEW_UTIL;
DROP PUBLIC SYNONYM MGMT_MESSAGES;


Thanks for your valuable suuport.


Thanks,


Sailesh
Previous Topic: Enterprise manager console for 11g
Next Topic: Connect Enterprise Manager
Goto Forum:
  


Current Time: Tue Mar 19 03:30:49 CDT 2024