ORA-55940: An error occurred during execution of ktliIngestExternData

This will be a short blog post about an issue i have faced the other day, i was trying to query unified audit trail view:

SQL> select * from unified_audit_trail;

ORA-55940: An error occurred during execution of ktliIngestExternData

This error is related to unified audit spill over files located in $ORACLE_BASE/audit/ORACLE_SID

so you have two options:

OPTION 1: upload them  by executing:

exec DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES;

OPTION 12: remove the spill over files if you think this will not impact your security (use rm Linux OS command)

restart your database and try querying again unified_audit_trail

 

One thought on “ORA-55940: An error occurred during execution of ktliIngestExternData

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s