Enterprise Manager

Hi,

I have installed Oracle Enterprise Manager 10g Release 2 (10.2.0.2) on Windows 2003 server service pack 2.Everything works fine, but when I go for switchover/failover operation firstly error comes as “500 Internal Server Error” and then after refreshing the page “503 Service Unavailable”. Following are the logs.

I applied the patch Grid Control Release 3 (10.2.0.3.0), but still same error occurs.
Both database status is up and EM console home shows 100% up.

Some Collected errors from emoms.trc

*************************************************************************************************************

2007-11-03 12:24:35,453 [Thread-25] ERROR em.dataguard updateDGStatus.453 - ConfigBean:updateDGStatus(): Exception java.lang.NullPointerException
2007-11-03 12:25:01,703 [Thread-26] ERROR em.dataguard updateDGStatus.453 - ConfigBean:updateDGStatus(): Exception java.lang.NullPointerException
2007-11-03 12:25:11,156 [Thread-27] ERROR em.dataguard updateDGStatus.453 - ConfigBean:updateDGStatus(): Exception java.lang.NullPointerException
2007-11-03 12:25:17,906 [EMUI_12_25_17_/console/targets] ERROR jdk.NLSUtil getFormattedDateWithTZ.407 - Invalid region name format: GMT+05:30
2007-11-03 12:25:17,906 [EMUI_12_25_17_/console/targets] ERROR jdk.NLSUtil getFormattedDateWithTZ.407 - Invalid region name format: GMT+05:30
2007-11-03 12:25:19,343 [EMUI_12_25_19_/console/home] ERROR jdk.NLSUtil getFormattedDateWithTZ.407 - Invalid region name format: GMT+05:30

*************************************************************************************************************

2007-11-03 12:30:16,562 [Thread-34] ERROR db.rac getEMDFromRep.806 - Closed Connection
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:239)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:928)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:824)
at oracle.jdbc.OracleConnectionWrapper.prepareStatement(OracleConnectionWrapper.java:72)
at oracle.sysman.util.jdbc.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:467)
at oracle.sysman.db.rac.util.ClusterUtil.getEMDFromRep(ClusterUtil.java:795)
at oracle.sysman.db.rac.util.ClusterUtil.getEMD(ClusterUtil.java:888)
at oracle.sysman.emo.util.DBVerify.getDBProperties(DBVerify.java:2454)
at oracle.sysman.emo.util.DBStateUtil.doDatabaseShutdown(DBStateUtil.java:703)
at oracle.sysman.db.dg.util.RemoteCtrl.shutdownDB(RemoteCtrl.java:596)
at oracle.sysman.db.dg.util.ClientOperation.doClientOp(ClientOperation.java:368)
at oracle.sysman.db.dg.util.ClientOperation$BounceThread.run(ClientOperation.java:215)
at java.lang.Thread.run(Thread.java:534)
2007-11-03 12:30:16,562 [Thread-34] ERROR emo.util verifyDBProperties.2073 - DBStateUtil.verifyDBProperties: EMD URL was null or empty.
2007-11-03 12:30:23,265 [EMUI_12_30_23_/console/database/dataguard] ERROR em.dataguard onEvent.1233 - Data Guard: found errors during role change: Unable to retrieve the URL from repository. Check the specified target name and its corresponding target type. Other possible causes: remote EMD is not pointing to the web server, or remote target information has not been loaded.
2007-11-03 12:30:41,328 [ApplicationServerThread-5] ERROR app.SessionObjectManager sessionDestroyed.128 - java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only


*************************************************************************************************************


2007-11-03 12:30:42,968 [PingHeartBeatRecorder] WARN emdrep.pingHBRecorder resetConnection.305 - SQLException caught while resetting connection ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only


************************************************************************************************************


2007-11-03 12:30:43,093 [Job Dispatcher Thread] ERROR em.jobs mainTask.2346 - encountered error:
java.sql.SQLException: ORA-01092: ORACLE instance terminated. Disconnection forced


*************************************************************************************************************


2007-11-03 12:30:44,046 [SeverityLoad https://ashok:3872/emd/main/] ERROR eml.XMLLoader markFileAsError.854 - Error repeated 2 times: ERROR-400|ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only

*************************************************************************************************************


2007-11-03 12:30:46,796 [AJPRequestHandler-ApplicationServerThread-6] ERROR eml.OMSHandshake processFailure.806 - OMSHandshake failed.(AGENT URL = https://ashok:3872/emd/main/)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only
)

**************************************************************************************************************

2007-11-03 12:33:29,843 [AJPRequestHandler-ApplicationServerThread-6] ERROR conn.ConnectionService verifyRepositoryEx.817 - Invalid Connection Pool. ERROR = ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only

**************************************************************************************************************


Regards,
S Reddy