DBMS scheduler job for auditing failed After 12.1 To 12.2 Upgrade ORA-46273 ORA-06512
Last updated on MAY 25, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
DBMS_AUDIT_MGMT fails with ORA-46273 (caused by ORA-01031) when using CONTAINER_ALL and running through dbms_scheduler on database(s) upgraded from 12.1 to 12.2.
This issue does not exist on "pure" 12.2 databases, or "pure" 12.1 databases, only databases which were upgraded from 12.1 to 12.2.
The DBMS_AUDIT_MGMT call runs fine if it's done directly, but fails if it's done through the scheduler.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms