syeds upgrade

Run the pre-upgrade Steps
=========================

$ mkdir -p /tmp/upgrade


[oracle@wysheid11gr54 admin]$ cp /wysheid/oracle/11c_home/rdbms/admin/preupgrd.sql /tmp/upgrade
[oracle@wysheid11gr54 admin]$ cp /wysheid/oracle/11g_home/rdbms/admin/utluppkg.sql /tmp/upgrade






set the enviornmental variable for 11g DB

$ cd /tmp/upgrade
$ sqlplus / as sysdba

SQL> @preupgrd.sql



SQL> @/wysheid/oracle/cfgtoollogs/primedb/preupgrade/preupgrade_fixups.sql




SQL > @/wysheid/oracle/11c_home/rdbms/admin/emremove.sql



SQL> EXECUTE dbms_stats.gather_dictionary_stats;


-- Shutdown the database.
SHUTDOWN IMMEDIATE;



Copy the parameter files from 11g to 12c home
==============================================



        $ cp   /wysheid/oracle/11g_home/dbs/spfileprimedb.ora /wysheid/oracle/11c_home/dbs

        $cp /wysheid/oracle/11g_home/dbs/orapwprimedb /wysheid/oracle/11c_home/dbs

Update the oratab with 12c information
======================================

primedb:/wysheid/oracle/product/12.1.0.1/db_1:Y


Set the enviornmental variable for the database
================================================
$ . oraenv

when prompted provide the sid name


Upgrade the database
====================

$ sqlplus / as sysdba

SQL> STARTUP UPGRADE;
SQL> EXIT;

$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql



validate the success of upgrade
================================

$ sqlplus / as sysdba

SQL> STARTUP;
SQL> @utlu121s.sql

Run the postupgrade script
===========================

SQL> @/wysheid/oracle/cfgtoollogs/orcl/preupgrade/postupgrade_fixups.sql

Verify the status of the database
==================================

SQL> SELECT name, open_mode FROM v$database;