DBMS scheduler job for auditing failed After 12.1 To 12.2 Upgrade ORA-46273 ORA-06512
(Doc ID 2389427.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!