Database Administration (MOSC)

MOSC Banner

DBMS_STATS errors ORA-12012, 20001, 6512 after upgrade to 12.2 from 11.2.0 on Windows OS

We have installed 12.2 up to the last available patch created a new multi-tenant database with 2 pdbs and did a data pump export and import to achieve the upgrade.
(We are working in phases towards 19)

In the alert log is reporting:
ORA-12012 on execute of job ora$AT_OS_OPT_SY_####
ORA-20001: Statistics Advisor: Invalid Task Name for the current user
ORA-06512 on SYS.DBMS_STATS
ORA-06512 on DBMS_STATS_ADVISOR Line ###
ORA-06512 on DBMS_STATS_INTERNAL Line ###
One set of errors for each of the PDBS

I have followed doc # Doc ID 2420581.1 execute "EXEC dbms_stats.init_package();" I also followed

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center