My Oracle Support Banner

Pre-Upgrade fails with "ERROR - Unable to run preupgrade due to: The DBMS_PREUP package is not installed or it has errors.It must be created prior to setting this database read only" (Doc ID 2854820.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Trying to run preupgrade.Jar file, results in the below error-

$ <Source Oracle Home>/jdk/bin/java -jar <Target Oracle Home>/rdbms/admin/preupgrade.jar FILE DIR <Log Directory Location>
ERROR - Unable to run the preupgrade due to:ERROR - Unable to run preupgrade due to:

The DBMS_PREUP package is not installed or it has errors.
It must be created prior to setting this database read only

ERROR - Unable to run sqlplus due to:
dbms_preup.debug := false;
*
ERROR at line 8:
ORA-06550: line 8, column 5:
PLS-00201: identifier 'DBMS_PREUP.DEBUG' must be declared
ORA-06550: line 8, column 5:
PL/SQL: Statement ignored
ORA-06550: line 18, column 12:
PLS-00201: identifier 'DBMS_PREUP.DB_IS_CDB' must be declared
ORA-06550: line 18, column 9:
PL/SQL: Statement ignored
ORA-06550: line 39, column 34:
PLS-00201: identifier 'DBMS_PREUP.RUN_PREUPGRADE' must be declared
ORA-06550: line 39, column 9:
PL/SQL: Statement ignored
ORA-06550: line 48, column 9:
PLS-00201: identifier 'DBMS_PREUP.DB_IS_CDB' must be declared
ORA-06550: line 48, column 6:
PL/SQL: Statement ignored

 The DBMS_PREUP Package was not getting in the DB-

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select object_name,owner,status from dba_objects where object_name='DBMS_PREUP';

no rows selected

SQL> show parameter db_name ;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string TEST
SQL>

 

Changes

 Also, Tried Downloading the latest Pre-Upgrade Utility from below MOS Note,but no use -

How to Download and Run Oracle's Database Pre-Upgrade Utility (Doc ID 884522.1)

 The DBMS_PREUP Package was not getting created in the DB

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
  
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.