Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unified Audit record write to audit trail table failed due to ORA-12899. Writing the record to OS sp

mbtc22951Apr 15 2018 — edited Apr 16 2018

Hi Oracle Team,

I have encountered the error message below from my database (12c R2) alert log right after the database creartion.

     "Unified Audit record write to audit trail table failed due to ORA-12899. Writing the record to OS spillover file."

I just want to clarify the solution provided below from (Doc ID 2320330.1)

     Solution: One of the application exe files connecting to Database had long name (61 chars length).
                    The failed actions were LOGON/LOGOFF audit - related to audit of the program name of the session.

                    When we shortened the exe name (the "limit" is 48 chars) the errors disappeared from the alert log.

Can someone explain on how to do the provided solution above step by step or in details?

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2018
Added on Apr 15 2018
1 comment
2,048 views