OAM 11g Audit error - ORA-00942: table or view does not exist

(Doc ID 1371035.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Access Manager - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11g]
Information in this document applies to any platform.
OAM 11g 11.1.1.5 Audit Database


Symptoms

After setting up Auditing for OAM 11g (11.1.1.5). Per the document:

Setting Up the Audit Database Store


The RCU script creates the Audit user in the db, and updates the schema etc.

When the Weblogic server is started.  You may get this error:

<Sep 14, 2011 7:00:21 PM EDT> <Error> <Default> <BEA-000000> <IAU:IAU-5047:
Problem in transferring audit record from
file:/www/oracle/oss-uat/user_projects/domains/iam-uat/servers/oam_server1/log
s/auditlogs/OAM/audit.log position:8,822 will retry in next cycle. caught
exception oracle.security.audit.AuditException:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


No audit entries are seen in the audit DB
.

Eventually all the DB connection pools are used up, and this error will show up:

<Sep 14, 2011 7:03:01 PM EDT> <Error> <Default> <BEA-000000> <IAU:IAU-5047:
Problem in transferring audit record from
file:/www/oracle/oss-uat/user_projects/domains/iam-uat/servers/oam_server1/log
s/auditlogs/OAM/audit.log position:8,822 will retry in next cycle. caught
exception oracle.security.audit.AuditException: java.sql.SQLException: Pool
connect failed : weblogic.common.ResourceException:
AuditDB(AuditDB-rac1): No resources currently available in pool
AuditDB-rac1 to allocate to applications, please increase the size of the
pool and retry..
AuditDB(AuditDB-rac0): No resources currently available in pool
AuditDB-rac0 to allocate to applications, please increase the size of the
pool and retry..

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