Enterprise Manager

Hi,

I recently upgraded my database from 10.1.0.2 to 10.1.0.5. The patches were sussessfully appliied. But after all the upgrades, the enterprise manager has stopped to work. The agent is also not responding.

When I restart the dbconsole service and try to logon to the database using EM, it shows Agent Unreachable.

The output of emctl status dbconsole is


C:\Documents and Settings\Administrator.VECTRA>emctl status agent
Oracle Enterprise Manager 10g Database Control Release 10.1.0.5.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.1.0.5.0
OMS Version : 10.1.0.5.0
Protocol Version : 10.1.0.2.0
Agent Home : D:\oracle\product\10.1.0\Db_1\Database.vectra.com
Agent binaries : D:\oracle\product\10.1.0\Db_1
Agent Process ID : 5304
Agent Process ID : 5304
Agent URL : http://Database.vectra.com:1830/emd/main
Started at : 2009-04-11 12:44:14
Started by user : SYSTEM
Last Reload : 2009-04-11 12:44:14
Last successful upload : (none)
Last attempted upload : 2009-04-11 12:44:39
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 133
Size of XML files pending upload(MB) : 53.34
Available disk space on upload filesystem : 89.61%
---------------------------------------------------------------
Agent is Running and Ready

The error recorded in the enoms.log is as follows:

2009-04-12 19:26:12,490 [MetadataLoad http://Database.vectra.com:1830/emd/main:A0000000011.xml] ERROR eml.XMLLoader markFileAsError.780 - Failed to load A0000000011.xml because of errors; moving to errors directory
2009-04-12 19:26:12,490 [HttpRequestHandler-26655428] ERROR eml.FxferRecv doPost.828 - Upload repsonse header :-FATAL_ERROR::500|ORA-20603: Updating timezone region of a target is not supported. Use mgmt_target.set_agent_tzrgn() API to modify the timezone region.(target name = Database.vectra.com:1830)(target type = oracle_emd)(new tzrgn = +05:30)(old tzrgn = UTC)
ORA-06512: at "SYSMAN.CHECK_DUPLICATE_TARGETS", line 86
ORA-04088: error during execution of trigger 'SYSMAN.CHECK_DUPLICATE_TARGETS'
-
2009-04-12 19:26:23,990 [MetadataLoad http://Database.vectra.com:1830/emd/main:A0000000012.xml] ERROR eml.FxferRecv DirectLoad.1029 - java.sql.SQLException: ORA-20603: Updating timezone region of a target is not supported. Use mgmt_target.set_agent_tzrgn() API to modify the timezone region.(target name = Database.vectra.com:1830)(target type = oracle_emd)(new tzrgn = +05:30)(old tzrgn = UTC)
ORA-06512: at "SYSMAN.CHECK_DUPLICATE_TARGETS", line 86
ORA-04088: error during execution of trigger 'SYSMAN.CHECK_DUPLICATE_TARGETS'

java.sql.SQLException: ORA-20603: Updating timezone region of a target is not supported. Use mgmt_target.set_agent_tzrgn() API to modify the timezone region.(target name = Database.vectra.com:1830)(target type = oracle_emd)(new tzrgn = +05:30)(old tzrgn = UTC)
ORA-06512: at "SYSMAN.CHECK_DUPLICATE_TARGETS", line 86
ORA-04088: error during execution of trigger 'SYSMAN.CHECK_DUPLICATE_TARGETS'

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:184)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:632)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3000)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3073)
at oracle.sysman.util.jdbc.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:670)
at oracle.sysman.emdrep.dbjava.loader.MultiTableInsertHandler.handle(MultiTableInsertHandler.java:373)
at oracle.sysman.emdrep.dbjava.loader.MultiTableInsertHandler.handleDocument(MultiTableInsertHandler.java:162)
at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.handleSubDocument(XMLLoaderContext.java:1472)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.endElement(XMLDocumentSplitter.java:770)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1211)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:300)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:267)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:149)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.split(XMLDocumentSplitter.java:391)
at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.loadFromStream(XMLLoaderContext.java:1320)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.DirectLoad(XMLLoader.java:442)
at oracle.sysman.emdrep.receiver.FxferRecv.DirectLoad(FxferRecv.java:1013)
at oracle.sysman.emdrep.receiver.FxferRecv.processFile(FxferRecv.java:1393)
at oracle.sysman.emdrep.receiver.FxferRecv.receiveFile(FxferRecv.java:1513)
at oracle.sysman.emdrep.receiver.FxferRecv.doPost(FxferRecv.java:820)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:269)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
2009-04-12 19:26:23,990 [MetadataLoad http://Database.vectra.com:1830/emd/main:A0000000012.xml] ERROR eml.XMLLoader markFileAsError.780 - Failed to load A0000000012.xml because of errors; moving to errors directory
2009-04-12 19:26:24,005 [HttpRequestHandler-25971327] ERROR eml.FxferRecv doPost.828 - Upload repsonse header :-FATAL_ERROR::500|ORA-20603: Updating timezone region of a target is not supported. Use mgmt_target.set_agent_tzrgn() API to modify the timezone region.(target name = Database.vectra.com:1830)(target type = oracle_emd)(new tzrgn = +05:30)(old tzrgn = UTC)
ORA-06512: at "SYSMAN.CHECK_DUPLICATE_TARGETS", line 86
ORA-04088: error during execution of trigger 'SYSMAN.CHECK_DUPLICATE_TARGETS'
-


Please Help.

Regards.