ORA-7445 [KTLIFLSLOBINSBLKS()+4454] and ORA-3113 with DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES (Doc ID 1949351.1)

Last updated on MAY 29, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When running DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES procedure, the session gets disconnected and the files remain on the OS.

SQL> exec DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES;
BEGIN DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES; END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 15130
Session ID: 160 Serial number: 445

ORA-7445 [KTLIFLSLOBINSBLKS()+4454] errors are seen in the alert log at the same time.

Some functions on the call stack typically include:

ktliFlsLobInsBlks()                 
ktliIngestCtxHandleBufs()
ktliIngestCtxHandleNewLob()

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