PDB Syncronization Issue

Hello,

2024 was hell of a year for me (still is) I couldn’t even check my blog. I just want to add a post, something small.

From time to time I got pdb_plug_in_violations records about sync pdb comments like grants/revokes. I use a common user to manage my pdbs. Lets call it C##MUSTAFA. Sometimes when I create a pdb from another pdb I got violations like this:

Sync PDB failed with ORA-00990 while performing ‘REVOKE COMMIT ON “SYS”.”V_$PDBS” FROM “C##MUSTAFA” CONTAINER=ALL’

My user has grants on V_$PDBS but for newly created pdb I got violations. These violations are WARNINGs so they are not a blocker but it is irritating to have them. if you have obsessive compulsive disorder like me they won’t let you sleep 🙂 anyway, to solve those violations,

1- shutdown the related pdb

2- grant the necessary privilege again “grant commit on sys.v_$pdbs to c##mustafa container=all”

3- open the pdb again

pdb plug in violations are still there but now their status are RESOLVED. so you can call dbms_pdb.clear_plugin_violations to clear those resolved messages.

wish you healthy, good days.