IAU:Unable to write Audit Event for Type: OAM (Doc ID 1619644.1)

Last updated on NOVEMBER 01, 2016

Applies to:

Oracle Access Manager - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

Enabled OAM audit but it is not working. oam-server_diagnostic.log shows

[2014-01-29T21:58:01.720+00:00] [oam_server] [ERROR] [] [oracle.security.audit.logger] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: 0000KFVlIKEATOs5Kjp2ie1IuMa8000004,0] IAU:Unable to write Audit Event for Type: OAM

 

with JDBC debug enabled, oam-server.log shows

 

####<30-Jan-2014 23:15:03 o'clock GMT> <Debug> <JDBCSQL> <hostname> <oam_server> <AuditLoaderRunner> <<WLS Kernel>> <> <0000KFVlIKEATOs5Kjp2ie1IuMa8000004> <1391123703146> <BEA-000000> <[weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper@ae6] executeUpdate(unknown) throws: java.sql.SQLSyntaxErrorException: ORA-00904: "IAU_USERTENANTID": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at oracle.security.audit.ajl.loader.standard.OracleStandardComponentDataWriter.write1(OracleStandardComponentDataWriter.java:228)
at oracle.security.audit.ajl.loader.standard.OracleStandardComponentDataWriter.write(OracleStandardComponentDataWriter.java:80)
at oracle.security.audit.ajl.loader.ChainComponentDataWriter.write(ChainComponentDataWriter.java:75)
at oracle.security.audit.ajl.loader.JDBCLogWriter.write(JDBCLogWriter.java:116)
at oracle.security.audit.ajl.loader.AuditLoader.readMessages(AuditLoader.java:488)
at oracle.security.audit.service.AuditLoaderManager.readMessages(AuditLoaderManager.java:260)
at oracle.security.audit.service.AuditLoaderManager$Runner.run(AuditLoaderManager.java:335)



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