• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

Oracle Management Server Service

The Oracle version I am using is 9i. When I attempt to start the Oracle Management Server service it fails with the following error:
Event Type:      Error
Event Source:      OracleOraHome92ManagementServer
Event Category:      None
Event ID:      113
Date:            4/12/2006
Time:            11:41:30 AM
User:            N/A
Computer:      USROORACLE
Description:
The process termination failed for JRE.  %2.


Event Type:      Error
Event Source:      OracleOraHome92ManagementServer
Event Category:      None
Event ID:      112
Date:            4/12/2006
Time:            11:41:30 AM
User:            N/A
Computer:      USROORACLE
Description:
The service has terminated abnormally.  See the file G:\oracle\ora92\sysman\log\oms.nohup for details.
Here is the contents of the oms.nohup
OEMCTL for Windows NT: Version 9.2.0.1.0 Production
Copyright (c) 1998, 2002, Oracle Corporation.  All rights reserved.
Starting the Oracle Management Server...VXA-3008 : Starting OMS Services, Wait.


The OMS is now started and ready.
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-06550: line 1, column 25:\nPLS-00201: identifier \'SMP_VDM_NOTIFICATION_PKG.PURGE_UI_NOTIFICATION\' must be declared\nORA-06550: line 1, column 25:\nPL/SQL: Statement ignored\n";long oracleError=6550;long errorCode=3;wstring sqlStmt="";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeDML(VdbStatement.java:1570)
      at oracle.sysman.vdb.VdbReadWriteTransaction.executeDML(VdbReadWriteTransaction.java:59)
      at oracle.sysman.vdm.VdmNotificationManager.purgeNotification(VdmNotificationManager.java:1741)
      at oracle.sysman.vdm.VdmNotificationManager.processOperation(VdmNotificationManager.java:1052)
      at oracle.sysman.vdiBaseComps.VdiExecuter.run(VdiExecuter.java:132)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-06550: line 1, column 29:\nPLS-00201: identifier \'SMP_VDU.GETUSERDETAIL\' must be declared\nORA-06550: line 1, column 23:\nPL/SQL: Statement ignored\n";long oracleError=6550;long errorCode=3;wstring sqlStmt="";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbCallableStatement.execute(VdbCallableStatement.java:227)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:577)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1724)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1796)
      at oracle.sysman.vds.VdsImpl.principalLogin(VdsImpl.java:1174)
      at oracle.sysman.vds.VdsImpl.secureLogonEx(VdsImpl.java:1417)
      at oracle.sysman.vds._tie_Vds.secureLogonEx(_tie_Vds.java:134)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:129)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:92)
      at com.visigenic.vbroker.orb.SkeletonDelegateImpl.execute(SkeletonDelegateImpl.java:108)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java:290)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:462)
      at com.visigenic.vbroker.orb.ThreadPoolDispatcher.run(ThreadPoolDispatcher.java:155)
      at com.visigenic.vbroker.orb.WorkerThread.run(WorkerThread.java:146)
exception VdbSQLException{wstring reason="ORA-06550: line 1, column 29:\nPLS-00201: identifier \'SMP_VDU.GETUSERDETAIL\' must be declared\nORA-06550: line 1, column 23:\nPL/SQL: Statement ignored\n";long oracleError=6550;long errorCode=3;wstring sqlStmt="";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbCallableStatement.execute(VdbCallableStatement.java:227)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:577)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1724)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1796)
      at oracle.sysman.vds.VdsImpl.principalLogin(VdsImpl.java:1174)
      at oracle.sysman.vds.VdsImpl.secureLogonEx(VdsImpl.java:1417)
      at oracle.sysman.vds._tie_Vds.secureLogonEx(_tie_Vds.java:134)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:129)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:92)
      at com.visigenic.vbroker.orb.SkeletonDelegateImpl.execute(SkeletonDelegateImpl.java:108)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java:290)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:462)
      at com.visigenic.vbroker.orb.ThreadPoolDispatcher.run(ThreadPoolDispatcher.java:155)
      at com.visigenic.vbroker.orb.WorkerThread.run(WorkerThread.java:146)
exception VdbSQLException{wstring reason="ORA-06550: line 1, column 29:\nPLS-00201: identifier \'SMP_VDU.GETUSERDETAIL\' must be declared\nORA-06550: line 1, column 23:\nPL/SQL: Statement ignored\n";long oracleError=6550;long errorCode=3;wstring sqlStmt="";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbCallableStatement.execute(VdbCallableStatement.java:227)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:577)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1724)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1796)
      at oracle.sysman.vds.VdsImpl.principalLogin(VdsImpl.java:1174)
      at oracle.sysman.vds.VdsImpl.secureLogonEx(VdsImpl.java:1417)
      at oracle.sysman.vds._tie_Vds.secureLogonEx(_tie_Vds.java:134)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:129)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:92)
      at com.visigenic.vbroker.orb.SkeletonDelegateImpl.execute(SkeletonDelegateImpl.java:108)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java:290)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:462)
      at com.visigenic.vbroker.orb.ThreadPoolDispatcher.run(ThreadPoolDispatcher.java:155)
      at com.visigenic.vbroker.orb.WorkerThread.run(WorkerThread.java:146)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VdbSQLException{wstring reason="ORA-06550: line 1, column 29:\nPLS-00201: identifier \'SMP_VDU.GETUSERDETAIL\' must be declared\nORA-06550: line 1, column 23:\nPL/SQL: Statement ignored\n";long oracleError=6550;long errorCode=3;wstring sqlStmt="";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbCallableStatement.execute(VdbCallableStatement.java:227)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:577)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1724)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1796)
      at oracle.sysman.vds.VdsImpl.principalLogin(VdsImpl.java:1174)
      at oracle.sysman.vds.VdsImpl.secureLogonEx(VdsImpl.java:1417)
      at oracle.sysman.vds._tie_Vds.secureLogonEx(_tie_Vds.java:134)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:129)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:92)
      at com.visigenic.vbroker.orb.SkeletonDelegateImpl.execute(SkeletonDelegateImpl.java:108)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java:290)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:462)
      at com.visigenic.vbroker.orb.ThreadPoolDispatcher.run(ThreadPoolDispatcher.java:155)
      at com.visigenic.vbroker.orb.WorkerThread.run(WorkerThread.java:146)
exception VdbSQLException{wstring reason="ORA-06550: line 1, column 29:\nPLS-00201: identifier \'SMP_VDU.GETUSERDETAIL\' must be declared\nORA-06550: line 1, column 23:\nPL/SQL: Statement ignored\n";long oracleError=6550;long errorCode=3;wstring sqlStmt="";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbCallableStatement.execute(VdbCallableStatement.java:227)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:577)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1724)
      at oracle.sysman.vdu.VduImpl.authenticate(VduImpl.java:1796)
      at oracle.sysman.vds.VdsImpl.principalLogin(VdsImpl.java:1174)
      at oracle.sysman.vds.VdsImpl.secureLogonEx(VdsImpl.java:1417)
      at oracle.sysman.vds._tie_Vds.secureLogonEx(_tie_Vds.java:134)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:129)
      at oracle.sysman.vds._VdsImplBase._execute(_VdsImplBase.java:92)
      at com.visigenic.vbroker.orb.SkeletonDelegateImpl.execute(SkeletonDelegateImpl.java:108)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java:290)
      at com.visigenic.vbroker.orb.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:462)
      at com.visigenic.vbroker.orb.ThreadPoolDispatcher.run(ThreadPoolDispatcher.java:155)
      at com.visigenic.vbroker.orb.WorkerThread.run(WorkerThread.java:146)
exception VdbSQLException{wstring reason="ORA-00942: table or view does not exist\n";long oracleError=942;long errorCode=3;wstring sqlStmt="/* OracleOEM */ select nodename, status, processing, agentstate, agenttz,        (sysdate-timestamp)*24*60*60 as pingingSince,        agentname, agentversion from smp_vdg_node_list where   (nodename IN     (select node from smp_vdp_node_oms_map where oms = ?)) and   (agentstate != \'BAD\') order by (sysdate-timestamp) desc";}
      at oracle.sysman.vdb.VdbStatement.processError(VdbStatement.java:471)
      at oracle.sysman.vdb.VdbStatement.executeQuery(VdbStatement.java:1496)
      at oracle.sysman.vdb.VdbAutoCommitSession.executeQuery(VdbAutoCommitSession.java:629)
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:392)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
exception VniAgentException{long type=4033;wstring description="ORA-00942: table or view does not exist\n";}
      at oracle.sysman.vdg.vdgStore.VdgNodeStore.getPingNodes(VdgNodeStore.java:413)
      at oracle.sysman.vdg.VdgPingManager.getNodes(VdgPingManager.java:411)
      at oracle.sysman.vdg.VdgPingManager.run(VdgPingManager.java:661)
      at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)
*** VDD: INITIATING OMS SHUTDOWN : OMS REPOSITORY SESSION LOST ***
VXA: Doing a shutdown and restart
Restarting the Oracle management Server....
OEMCTL for Windows NT: Version 9.2.0.1.0 Production
Copyright (c) 1998, 2002, Oracle Corporation.  All rights reserved.
Starting the Oracle Management Server...VXA-3008 : Starting OMS Services, Wait.
0
jroldan1
Asked:
jroldan1
1 Solution
 
harisrashidCommented:
You need to reinstall OMS. It is unable to find the tables / views used by OMS.
Regards,
Haris
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now