Getting errors when plugging a PDB into a new CDB
Platform: Windows 2019
DB Version: 19c
I need to, in effect, change the Oracle Home user. Which there is no direct way to do that on a Windows Server. Decided to tackle it by the following method.
- Unplug PDBs into xml.
- drop PDBs keep datafiles.
- Deinstall Oracle
- Create new Oracle Home user as an Administrator
- Change ownership of Oracle directories and files to new user w/full control.
- Install and patch Oracle under new Oracle Home user.
- Plugin PDBs into new CDB.
However, after installing and patching Oracle, then attempting to plug in the PDB using
Create pluggable database pdb1 using 'G:\backup\pdb1.xml' nocopy;