SAP Knowledge Base Article - Preview

3261501 - uniaud_records_in_file shows Unexpected failure during oracle preupgrade steps

Symptom

  • preupgrade_fixups.sql script shows following warning/error:


Number Preupgrade Check Name Remedied Further DBA Action

------ ------------------------ ---------- --------------------------------

2.       uniaud_records_in_file       NO             Unexpected failure. Manual fixup required. FIXUP reports success
                                                                   but a RECHECK indicated the problem still exists.

  • Although audit_unified_enabled_policies returns no rows:

SQL> Select POLICY_NAME, ENABLED_OPT from AUDIT_UNIFIED_ENABLED_POLICIES;

no rows selected

SQL> select VALUE from V$OPTION where parameter='Unified Auditing';

VALUE
----------------------------------------------------------------
FALSE


Read more...

Environment

oracle database

Keywords

uniaud_records_in_file , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.