Invalid objects after "create pluggable db" is done
Hi,
19.12 Windows 2019 and 2016
Creating pluggable db from PROD (win 2019) to UAT (win 2019) using a db link works fine.
Creating from UAT to TEST (win 2016) generated an unusable PDB after a few minutes (right after completion it looks fine, application is not even started). Over 7000 invalid objects, both application and sys objects. UTLRP errors out:
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SCHEDULER" has errors
ORA-06512: at "SYS.UTL_RECOMP", line 927
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_SCHEDULER"
ORA-06512: at "SYS.UTL_RECOMP", line 646
ORA-06512: at "SYS.UTL_RECOMP", line 836
ORA-06512: at line 1
CREATE PLUGGABLE DATABASE TESTPDB FROM UATPDB@UAT_LINK parallel 16 FILE_NAME_CONVERT = ('E:\oradata\UATCDB\UATPDB','D:\oradata\TESTCDB\TESTPDB') refresh mode none;