The article explains the workaround/solution when graceful switchover fails when unified auditing is enabled
Problem Details
Problem Statement
GS failed when unified auditing enabled
Applicable Error Code
Completed: alter database open
2020-04-12T21:30:45.419623+05:30
Unified Audit record write to audit trail table failed due to ORA-25153. Writing the record to OS spillover file.
...
Errors in file /u01/app/oracle/diag/rdbms/dev/DEV/trace/DEV_ora_94816.trc (incident=4543434):
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
Affected Versions
Independent of Dbvisit Versions
Affected Platforms
Platform
Description
We see the below error in the standby alert log and dbvisit trace files when Unified auditing is enabled.
Completed: alter database open
2020-04-12T21:30:45.419623+05:30
Unified Audit record write to audit trail table failed due to ORA-25153. Writing the record to OS spillover file.
...
Errors in file /u01/app/oracle/diag/rdbms/dev/DEV/trace/DEV_ora_94816.trc (incident=4543434):
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
Solution
Dbvisit is working on a permanent solution for this issue. The current workaround for this is to disable the unified auditing based on below Oracle support note.
How to Disable Oracle Database Auditing (Doc ID 1528170.1)
Comments