Unable To Write Audit Event For Type: OAM (Doc ID 1970672.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Access Manager - Version 11.1.2.2.3 and later
Oracle Platform Security for Java - Version 11.1.1.7.0 to 11.1.1.7.0 [Release Oracle11g]
Information in this document applies to any platform.

Symptoms

OAM 11.1.2.2.3 (BP 19162893)
After setting up OAM(integrated with OAM and OIM) with audit logging enabled on the DB, it is showing error with "Unable to write Audit Event for Type: OAM".”

oam_server1-diagnostic.log


[2015-01-08T08:38:48.261+00:00] [oam_server1] [ERROR] [] [oracle.security.audit.logger] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: 0000Kez6s^AFo26_vLK6yX1Kewor000004,0] IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
[2015-01-08T08:38:48.283+00:00] [oam_server1] [ERROR] [] [oracle.security.audit.logger] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: 0000Kez6s^AFo26_vLK6yX1Kewor000004,0] IAU:Unable to write Audit Event for Type: OAM
[2015-01-08T08:38:48.312+00:00] [oam_server1] [ERROR] [] [oracle.security.audit.logger] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: 0000Kez6s^AFo26_vLK6yX1Kewor000004,0] IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )





Changes

 Restart of Audit database

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