TNS for Solaris: Version 11.2.0.2.0 - ProductionĪrchive destination /uv1172/apps/oracle/product/11.2.Q4/dbs/archĪudit_file_dest string /uv1172/ofaroot/PROD/adumpĭOC>#ĭOC> If CLUSTER_DATABASE is set to TRUE, change it to FALSE before Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Oracle Database Upgrade Diagnostic Utility 05-13-2015 09:09:57 If you found any other objects other than these four, then those need to be cleaned up.ģ.Check the integrity of the database by running dbupgdiag-2 SQL Start of LogFile *** Check duplicate objects owned by system and sysĪnd owner = 'SYSTEM' SP2-0734: unknown command beginning "olumn obje." - rest of line ignored. SQL> select comp_id,status from dba_registry Ģ. Target ORACLE_HOME=/apps/oracle/product/12.1.0.2 PRECHECKS:ġ.CHECK THE INVALID OBJECTS( ALL SHOULD BE VALID) SEE ALSO: Upgrade database from 11g to 12c using DBUA ( GUI method)Ĭurrent ORACLE_HOME= /apps/oracle/product/11.2.0.3 SEE ALSO : Upgrade database from 11g to 12c using OEM cloud control You can refer the Installation steps here: Here we will provide steps for upgrading from 11gr2 to 12c database manually.īefore starting the upgrade make sure Oracle 12c database binary already installed on the database server. But for major production databases, it is better to do it manually, so that troubleshooting will be easy.
A database can be upgraded either using DBUA or manual method.