Database Administration (MOSC)

MOSC Banner

options_packs_usage_statistics.sql ( from doc1317265.1) failed on 12.2 database

edited Mar 10, 2020 3:45AM in Database Administration (MOSC) 5 commentsAnswered

Hello,

I Upgraded a database from 11.2.0.4 to 12.2.0.1.

I used the manual upgrade (dbupgrade) method to upgrade the database to a non-CDB 12C database.

Then I migrated the database to multitenant architecture.

When I launched the sql script that I found in doc 1317265.1 (connected to the Container database), It failed with these errors:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

PRODUCT USAGE

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

with

*

ERROR at line 1:

ORA-12801: error signaled in parallel query server P000

ORA-65501: l'adresse du conteneur  ne peut pas etre utilisee dans le conteneur CDB$ROOT pour cette operation

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

FEATURE USAGE DETAILS

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

with

*

ERROR at line 1:

ORA-12801: error signaled in parallel query server P002

ORA-65501: l'adresse du conteneur  ne peut pas etre utilisee dans le conteneur CDB$ROOT pour cette operation

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