EMAGENT.TRC Errors Shows SQL = "/* ORACLEOEM */ SELECT S.SID, S.SERIAL# FROM V$SESSION (Doc ID 456318.1)

Last updated on MARCH 09, 2016

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
Enterprise Manager Grid Control - Version: 10.2.0.0 to 10.2.0.0
EM Agent 10.2.0.X
Checked for relevance on 23-NOV-2013

Symptoms


The Grid Control Agent is monitoring Oracle Applications.

Once started the emagent.trc file shows the following errors:

2007-08-24 14:13:36 Thread-223 ERROR fetchlets.sql: Error in  getting session id and serial number for session 16ef368, = ORA-00942: table or view does not exist
LOGIN = em_monitor/<PW>@(DESCRIPTION=(ADDRESS=(PROTO   =TCP)(HOST=<hostname>)(PORT=1525))(CONNECT_DATA=(SID=oa04)))
2007-08-24 14:19:01 Thread-143 WARN  vpxoci: OCI Error -- ErrorCode(942): ORA-00942:  table or view does not exist

SQL = "/* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select s"...
LOGIN = em_monitor/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1525))(CONNECT_DATA=(SID=oa04)))
2007-08-24 14:19:01 Thread-143 ERROR fetchlets.sql: ORA-00942: table or view does not exist

2007-08-24 14:19:01 Thread-143 ERROR fetchlets.sql: Error in getting session id and serial number for session e6d368, = ORA-00942: table or view does not exist

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms