Database Administration (MOSC)

MOSC Banner

Invalid objects after "create pluggable db" is done

edited Feb 28, 2022 8:07AM in Database Administration (MOSC) 10 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center