Sync PDB Failed ORA-65033 GRANTING EXECUTE PRIVILEGE ON DBMS_METADATA AFTER PDB PLUGIN (Doc ID 2946989.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

Converting a non-cdb database to a pdb.

Sync PDB failed with error:
ORA-65033 while performing 'grant execute on dbms_metadata to C##xxxx CONTAINER=ALL'

ORA-65048: error encountered when processing the current DDL statement in pluggable database
ORA-65033: a common privilege may not be granted or revoked on a local object

from cdb

select con_id, object_name, object_type, sharing from cdb_objects where
object_name = 'DBMS_METADATA'  and object_type like 'PACKAGE%' order by 1,3;

     CON_ID        OBJECT_NAME         OBJECT_TYPE     SHARING
---------- -------------------- ----------------------- ------------------
         1 DBMS_METADATA        PACKAGE                 METADATA LINK
         1 DBMS_METADATA        PACKAGE BODY            METADATA LINK
         3 DBMS_METADATA        PACKAGE                 NONE <<<<<<<<<<<<<<<<<<<< incorrectly shown NONE on pdb
         3 DBMS_METADATA        PACKAGE BODY            NONE

Changes

Cause

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