EM 12c: Enterprise Manager 2c Cloud Control Database Monitoring User DBSNMP Triggers ORA-2004 and ORA-904 Errors in Database Audit Logs every 60 Seconds when Calling dbms_lock.sleep(60)

(Doc ID 2159738.1)

Last updated on JULY 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


Every 60 seconds the Enterprise Manager (EM) 12c Cloud Control database monitoring user, DBSNMP, is issuing a call to sys.dbms_lock.sleep(60) which is failing with error code 2004 and 904
and filling the audit table dba_audit_trail.

The following query can be executed against the audit trail table to verify the issue:

Example output


'oracle','DBSNMP','testhost.oracle.com',31444351,'2016-07-11 11.09.34','SYS','DBMS_LOCK','PL/SQL EXECUTE',,2004,,'BEGIN dbms_lock.sleep(60); END;
'oracle','DBSNMP','testhost.oracle.com',31444351,'2016-07-11 11.09.34','SYS','DBMS_LOCK','PL/SQL EXECUTE',,2004,,'BEGIN dbms_lock.sleep(60); END;
'oracle','DBSNMP','testhost.oracle.com',31444351,'2016-07-11 11.09.34','DBSNMP','DBMS_LOCK','PL/SQL EXECUTE',,904,,'BEGIN dbms_lock.sleep(60); END;







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