My Oracle Support Banner

EM 13c : ORA-00942 Error In The DBA_AUDIT_TRAIL For The User DBSNMP (Doc ID 2513520.1)

Last updated on JULY 26, 2019

Applies to:

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

Symptoms

In 12.2.0.1 Database, the DBSNMP user tries to execute this select SQL:

SELECT trans_count FROM (SELECT 'def_trans_err' name, COUNT(*) trans_count FROM sys.deferror
UNION ALL
SELECT 'def_trans_noerr' name, COUNT(*) trans_count FROM sys.deftran) ORDER BY name;

Which fails with "ORA-00942: table or view does not exist" as the two database objects "sys.deferror" and "sys.deftran" in the database does not exist. 

Changes

 

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.