Current ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
New ORACLE_HOME=/u03/app/oracle/product/12.2/db_1
check the invalid objects on the database
=========================================
12cR2.
This tool has reside in new oracle home.
/u03/app/oracle/product/12.2/db_1/rdbms/admin/preupgrade.jar
SYNTAX:
/u01/app/oracle/product/11.2.0.4/db_1/jdk/bin/java -jar /u03/app/oracle/product/12.2/db_1/rdbms/admin/preupgrade.jar FILE DIR /u01/
preupgrade.log
preupgrade_fixup.sql
postupgrade_fixup.sql
shut immediate
export ORACLE_HOME=/u01/app/oracle/product/12.2/db_1/
startup nomount
alter database open upgrade;
ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catctl.pl -d $ORACLE_HOME/rdbms/admin -l /home/oracle/ -n 4 catupgrd.sql
@postupgrade_fixups.sql
@catuppst.sql
@utlrp.sql
dba_registry - check the version from this dba_registry
