Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Existing CDB public synonym get error on preupgrade tool (upgrade to 12.1.0.2)

edited Jul 1, 2015 1:39AM in Database Install/Upgrade/Opatch (MOSC) 12 comments

My experience of upgrade from 11.2.0.4 to 12.1.0.2 with one database was not successful at the beginning.

I have tried to execute preupgrd.sql as it was explained in documentation and Note 1503653.1, later downloaded preupgrade tool  and catch the same errors:

SQL>@preupgrd.sql

Loading Pre-Upgrade Package...

DECLARE

*

ERROR at line 1:

ORA-06553: PLS-221: 'CDB' is not a procedure or is undefined

ORA-06512: at "SYS.DBMS_PREUP", line 12458

ORA-06512: at "SYS.DBMS_PREUP", line 3214

ORA-06512: at "SYS.DBMS_PREUP", line 3153

ORA-06512: at line 56

Investigation of DBMS_PREUP help me found out the reason of messages:

The database has PUBLIC synonym CDB on user's  package.

Tagged:

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