Workaround for ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container
Hello,
We're on oracle 19.7, on Solaris.
I hit the conflicting GUID issue on the second database I tried to convert into a PDB, in the same CDB.
"ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container"
For the first database, I used the 'NOCOPY' method of create pluggable database and it worked just fine.
I would like to do this for all the databases, but because of the GUID issue, I'm having to use create pluggable database .. as CLONE.
This requires disk space for 2 copies of the datafiles. I'd really like to avoid this.
We've decided that we want distinct GUID's in the whole environment, not just per CDB.