Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

12c Preupgrade error

edited Feb 25, 2019 1:19AM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered ✓

Hi all,

My preugrade package having an error.

[oracle@XXXXX util]$ $ORACLE_HOME/jdk/bin/java -jar /opt/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/preupgrade.jar DIR /home/oracle/util

ERROR -

ERROR - Unable to run sqlplus due to:

old 10: is_xml := ('&&2' = 'XML');

new 10: is_xml := ('TEXT' = 'XML');

old 12: IF '&&1' = 'FILE' THEN

new 12: IF 'FILE' = 'FILE' THEN

old 38: IF '&&3' = 'EXEC' THEN

new 38: IF 'EXEC' = 'EXEC' THEN

ORA-06512: at line 8

declare

*

ERROR at line 1:

ORA-04063: package body "SYS.DBMS_PREUP" has errors

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_PREUP"

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