Link to home
Start Free TrialLog in
Avatar of jroldan1
jroldan1

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of harisrashid
harisrashid
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial