| Cannot create EM on oracle 11gR2 [message #474127] |
Fri, 03 September 2010 00:21  |
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  |
 |
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 |
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
|
|
|
|
|
|
|
|
|
|
| Re: Cannot create EM on oracle 11gR2 [message #474571 is a reply to message #474564] |
Tue, 07 September 2010 05:30 |
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 #474596 is a reply to message #474592] |
Tue, 07 September 2010 07:55 |
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 #474694 is a reply to message #474671] |
Wed, 08 September 2010 04:59 |
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 #474814 is a reply to message #474708] |
Thu, 09 September 2010 02:32 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
