My Oracle Support Banner

OPSS - Auditing run-time event with database audit store not working as expected showing IAU:Unable to write Audit Event (Doc ID 2216161.1)

Last updated on MAY 10, 2018

Applies to:

Oracle Platform Security for Java - Version to [Release Oracle11g]
Information in this document applies to any platform.


OAM auditing run-time event with database audit store , not working as expected

After set up the database audit store to audit user login activities in the database according to this guide

9.7.1 Setting Up the Audit Database Store

Observing On average, once a day, sometimes once every two days, the database audit would stop.
The log file continues to log the user's login activities, but the database store stops.
Every time this happens, it is necessary restart the OAM server to restore the service.

Observing these errors in logs

[2016-11-01T10:58:46.329-05:00] [oam_server1] [ERROR] [] [] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: <ECID>] IAU:Unable to write Audit Event for Type: OAM
[2016-11-01T10:58:46.330-05:00] [oam_server1] [ERROR] [] [] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: <ECID>] IAU:Unable to prepare statement:INSERT INTO OAM COLUMNS ( IAU_ID, IAU_ApplicationDomainName, IAU_AuthenticationSchemeID, IAU_AgentID, IAU_SSOSessionID, IAU_AdditionalInfo, IAU_AuthorizationScheme, IAU_UserDN, IAU_ResourceID, IAU_AuthorizationPolicyID, IAU_AuthenticationPolicyID, IAU_PolicyObjectID, IAU_ReadOnly, IAU_PolicyAdminContext, IAU_PolicyType, IAU_UserID, IAU_ResourceHost, IAU_RequestID, IAU_Impersonator, IAU_ProtectionLevel, IAU_ResourceType, IAU_ServiceURI, IAU_ServiceIdentifier, IAU_ServiceOperation, IAU_AdminRoleName, IAU_ClientIPAddress, IAU_SessionCreationTime, IAU_SessionExpirationTime, IAU_SessionLastUpdateTime, IAU_SessionLastAccessTime, IAU_IdentityDomain, IAU_GenericAttribute1, IAU_GenericAttribute2, IAU_GenericAttribute3, IAU_GenericAttribute4, IAU_GenericAttribute5, IAU_PolicyName, IAU_SchemeName, IAU_ResourceHostName, IAU_OldAttributes, IAU_OldSettings, IAU_NewAttributes, IAU_NewSettings, IAU_ResponseType, IAU_AgentType, IAU_ConstraintType, IAU_InstanceName, IAU_DataSourceName, IAU_DataSourceType, IAU_HostIdentifierName, IAU_ResourceURI, IAU_ResourceOperations, IAU_ResourceTemplateName, IAU_TstzOriginating, IAU_EventType, IAU_EventCategory ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )




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

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