My Oracle Support Banner

Error Messages: "LOGIN = odssm/<PW> ORA-00942: table or view does not exist" In Emagent.trc File (Doc ID 579240.1)

Last updated on FEBRUARY 20, 2020

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.
***Checked for relevance on 12-March-2012***
Checked for relevance on 13-Aug-2013

Symptoms

Following errors occur in emagent.trc file:

Case 1:
=====
LOGIN = <LDAP_USER>/<PW>@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=<port>))(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=<port>))(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=<port>))(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=<port>))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVICE_NAME=OIM_TEST)))
2008-05-23 14:14:58 Thread-117427120 WARN vpxoci: OCI Error -- ErrorCode(942): ORA-00942: table or view does not exist

SQL = "/* OracleOEM */
SELECT COUNT(DISTINCT ET.ENTRYID)
FROM
"...
LOGIN = <LDAP_USER><PW>@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>))(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>))(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>))(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVICE_NAME=<service name>)))
2008-05-23 14:14:58 Thread-117427120 ERROR fetchlets.sql: ORA-00942: table or view does not exist

2008-05-23 14:14:58 Thread-117427120 ERROR engine: [oracle_ldap,<target name>_LDAP,OIDserverSecRefSuLoginSuccCC] : nmeegd_GetMetricData failed : ORA-00942: table or view does not exist

2008-05-23 14:14:58 Thread-117427120 WARN collector: <nmecmc.c> Error exit. Error message: ORA-00942: table or view does not exist

Case 2:
=====
SQL = "/* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select s"... LOGIN = 
 <LDAP_USER>/<PW>@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))(CONNECT_DATA=(SERVICE_NAME=<service name>)))

2006-04-20 14:18:18 Thread-338430896 WARN vpxoci: OCI Error -- ErrorCode(942): ORA-942: table or view does not exist

SQL = "/* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select s"... LOGIN =  <LDAP_USER>/<PW>@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))(CONNECT_DATA=(SERVICE_NAME=<service_name>)))

2006-04-20 14:18:18 Thread-338430896 ERROR fetchlets.sql: ORA-942: table or view does not exist
2006-04-20 14:18:18 Thread-338430896 ERROR fetchlets.sql: Error in getting session id and serial number for session 8f57b10, = ORA-942: table or view does not exist

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.