My Oracle Support Banner

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 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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.

 

 

Changes

 

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!


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