Run

cd /u01/app/oracle/product/${NEWVER}/rdbms/admin

mkdir /tmp/${NEWVER}

cp preupgrd.sql /tmp/${NEWVER}

cp utluppkg.sql /tmp/${NEWVER}

cd /tmp/${NEWVER}

sqlplus / as sysdba

@preupgrd.sql

Review output in:

/u01/app/oracle/cfgtoollogs/DB_NAME/preupgrade/preupgrade.log

Common Errors

ERROR: --> Invalid Oracle supplied table data found in your database.

@?/rdbms/admin/utluppkg.sql

SET SERVEROUTPUT ON;

exec dbms_preup.run_fixup_and_report('INVALID_SYS_TABLEDATA')

SET SERVEROUTPUT OFF;

WARNING: --> "DMSYS" schema exists in the database

See: Deinstall DMSYS

WARNING: --> Database contains INVALID objects prior to upgrade

See: Invalid Objects

ERROR: --> RECYCLE_BIN not empty.

See: Recycle Bin

Bibliography