My Oracle Support Banner

Metric Collection Errors with Message: ORA-01012: not logged on (Doc ID 1081741.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Checked for relevance on 26-Jul-2013

Symptoms

Many metric collection errors are appearing for a database target:

Error Type - Collection Failure
Message - ORA-01012: not logged on

The emagent.trc files shows the following error:

2010-02-10 10:31:07,690 Thread-3921660832 ERROR fetchlets.sql: ORA-01012: not logged on
2010-02-10 10:31:07,690 Thread-3921660832 ERROR engine: [oracle_database,<DB_TARGET_NAME>,sga_pool_wastage] : nmeegd_GetMetricData failed : ORA-01012: not logged on

2010-02-10 10:31:07,690 Thread-3921660832 WARN collector: <nmecmc.c> Error exit. Error message: ORA-01012: not logged on
2010-02-10 10:31:07,691 Thread-3921660832 WARN vpxoci: OCI Error -- ErrorCode(1012): ORA-01012: not logged on

SQL = "/* OracleOEM */
SELECT /*+ ORDERED */
TO_CHAR(CAST(d.end"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_HOSTNAME>)(PORT=<DB_LISTENER_PORT>))(CONNECT_DATA=(SID=<DB_TARGET_NAME>)))
2010-02-10 10:31:07,691 Thread-3921660832 WARN vpxoci: OCI Error -- ErrorCode(1012): ORA-01012: not logged on

SQL = "/* OracleOEM */
SELECT /*+ ORDERED */
TO_CHAR(CAST(d.end"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_HOSTNAME>)(PORT=<DB_LISTENER_PORT>))(CONNECT_DATA=(SID=<DB_TARGET_NAME>)))
2010-02-10 10:31:07,691 Thread-3921660832 ERROR fetchlets.sql: ORA-01012: not logged on

2010-02-10 10:31:07,691 Thread-3921660832 ERROR engine: [oracle_database,<DB_TARGET_NAME>,UserBlock] : nmeegd_GetMetricData failed : ORA-01012: not logged on

2010-02-10 10:31:07,691 Thread-3921660832 WARN collector: <nmecmc.c> Error exit. Error message: ORA-01012: not logged on
2010-02-10 10:31:07,988 Thread-4018138016 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-01012: not logged on
2010-02-10 10:31:07,991 Thread-3996089248 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-01012: not logged on
2010-02-10 10:31:07,991 Thread-4005538720 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-01012: not logged on
2010-02-10 10:31:07,991 Thread-3992939424 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-01012: not logged on
2010-02-10 10:31:07,992 Thread-4095736736 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-01012: not logged on

Changes

The DBSNMP user profile was changed recently.

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
Changes
Cause
Solution


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