My Oracle Support Banner

Oracle database alert log is flooding with errors ORA-12899. (Doc ID 3059251.1)

Last updated on DECEMBER 15, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.25.0.0.0 [Release 12.2 to 19]
Oracle Database Cloud Exadata Service - Version N/A to N/A [Release 1.0]
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Symptoms

customer have been experiencing a flood of errors in their database alert log, which are detailed below. 

Unified Audit record write to audit trail table failed due to ORA-12899.

 

Unified Audit record write to audit trail table failed due to ORA-12899. Writing the record to OS spillover file.
2024-09-09T13:38:24.700418-06:00
Errors in file E:\APP\ORACLE\diag\rdbms\hformgr\hformgr\trace\hformgr_ora_9552.trc:
ORA-12899: value too large for column "AUDSYS"."AUD$UNIFIED"."CLIENT_PROGRAM_NAME" (actual: 58, maximum: 48)
ORA-00942: table or view does not exist
2024-09-09T13:38:26.387008-06:00
Unified Audit record write to audit trail table failed due to ORA-12899. Writing the record to OS spillover file.
2024-09-09T13:38:43.292205-06:00
Errors in file E:\APP\ORACLE\diag\rdbms\hformgr\hformgr\trace\hformgr_ora_5584.trc:
ORA-12899: value too large for column "AUDSYS"."AUD$UNIFIED"."CLIENT_PROGRAM_NAME" (actual: 58, maximum: 48)
ORA-00942: table or view does not exist

Cause

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
Symptoms
Cause
Solution
References


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