Oracle Upgrade from 11gR2 to 12cR1

Oracle Upgrade from 11gR2 to 12cR1
-------------------------------------------------

1.Install the oracle binaries in the server .

2. copy the required files(pfile,orapwd,incase snap file as well) from old Ora_home/dbs (11g) to New ORA_HOME/dbs (12c)

3.Run the pre-upgrade script for the 11g database from 12c home

In 11g DB
-----------------

This file should be from 12c home

?@NEW_ORA_HOME/rdbms/admin/preupgrd.sql

This execution of file generated 3 more files in Current oracle_base/cfgtoolslogs/DB_NAME/

it will contains 

i. Pre-upgrade.log

ii.Preupgrade_fixups.sql

iii.Postupgrade_fixups.sql

Now the next thing on the move is to check the pre-upgrad e.log file and execute the pre-upgrade_fixups.sql file in 11g DB ..

It happens some time that the pre-upgrade_fixup.sql script may not be able to fix all the recommended and required issues suggested we need to do it manually as of in my case the manual actions were

job_queue_processess need to be more than 24

resource_limit should be TRUE and it was FALSE

Once this is done then

4. shutdown the DB in 11g 

5.Change the entries in oratab from current version to new version for DB

6. Set the environment for the DB 

Post the environment is set , do a explicit verification of below things

7. Check ORA_HOME is mapping or not 

echo $ORACLE_HOME

8.check $PATH

9. check $LD_LIBRARY_PATH as this is the important of all this sdhould map to 12c else the upgrade will fail and it will apply the interim patch during the upgrade uses this location as patch executable library.(check phase no. 65 & 69 ) 

10. Start the DB in upgrade mode 

startup upgrade

exit

11. From OS level issue the command for upgrade 

cd $ORACLE_HOME/rdbms/admin

$ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql

below is the upgrade Screen shot

Argument list for [catctl.pl]
SQL Process Count     n = 0
SQL PDB Process Count N = 0
Input Directory       d = 0
Phase Logging Table   t = 0
Log Dir               l = 0
Script                s = 0
Serial Run            S = 0
Upgrade Mode active   M = 0
Start Phase           p = 0
End Phase             P = 0
Log Id                i = 0
Run in                c = 0
Do not run in         C = 0
Echo OFF              e = 1
No Post Upgrade       x = 0
Reverse Order         r = 0
Open Mode Normal      o = 0
Debug catcon.pm       z = 0
Debug catctl.pl       Z = 0
Display Phases        y = 0
Child Process         I = 0

catctl.pl version: 12.1.0.2.0
Oracle Base           = /u02/app/oracle

Analyzing file catupgrd.sql
Log files in /u02/app/oracle/product/12102/rdbms/admin
catcon: ALL catcon-related output will be written to catupgrd_catcon_29032460.lst
catcon: See catupgrd*.log files for output generated by scripts
catcon: See catupgrd_*.lst files for spool files, if any
Number of Cpus        = 12
SQL Process Count     = 0
New SQL Process Count = 4

------------------------------------------------------
Phases [0-73]
Serial   Phase #: 0 Files: 1     Time: 262s
Serial   Phase #: 1 Files: 5     Time: 91s
Restart  Phase #: 2 Files: 1     Time: 1s
Parallel Phase #: 3 Files: 18    Time: 21s
Restart  Phase #: 4 Files: 1     Time: 1s
Serial   Phase #: 5 Files: 5     Time: 29s
Serial   Phase #: 6 Files: 1     Time: 22s
Serial   Phase #: 7 Files: 4     Time: 13s
Restart  Phase #: 8 Files: 1     Time: 0s
Parallel Phase #: 9 Files: 62    Time: 69s
Restart  Phase #:10 Files: 1     Time: 1s
Serial   Phase #:11 Files: 1     Time: 23s
Restart  Phase #:12 Files: 1     Time: 0s
Parallel Phase #:13 Files: 91    Time: 25s
Restart  Phase #:14 Files: 1     Time: 0s
Parallel Phase #:15 Files: 111   Time: 46s
Restart  Phase #:16 Files: 1     Time: 0s
Serial   Phase #:17 Files: 3     Time: 3s
Restart  Phase #:18 Files: 1     Time: 1s
Parallel Phase #:19 Files: 32    Time: 50s
Restart  Phase #:20 Files: 1     Time: 0s
Serial   Phase #:21 Files: 3     Time: 18s
Restart  Phase #:22 Files: 1     Time: 1s
Parallel Phase #:23 Files: 23    Time: 184s
Restart  Phase #:24 Files: 1     Time: 0s
Parallel Phase #:25 Files: 11    Time: 101s
Restart  Phase #:26 Files: 1     Time: 1s
Serial   Phase #:27 Files: 1     Time: 1s
Restart  Phase #:28 Files: 1     Time: 0s
Serial   Phase #:30 Files: 1     Time: 0s
Serial   Phase #:31 Files: 257   Time: 40s
Serial   Phase #:32 Files: 1     Time: 0s
Restart  Phase #:33 Files: 1     Time: 0s
Serial   Phase #:34 Files: 1     Time: 8s
Restart  Phase #:35 Files: 1     Time: 0s
Restart  Phase #:36 Files: 1     Time: 1s
Serial   Phase #:37 Files: 4     Time: 97s
Restart  Phase #:38 Files: 1     Time: 0s
Parallel Phase #:39 Files: 13    Time: 119s
Restart  Phase #:40 Files: 1     Time: 1s
Parallel Phase #:41 Files: 10    Time: 17s
Restart  Phase #:42 Files: 1     Time: 1s
Serial   Phase #:43 Files: 1     Time: 11s
Restart  Phase #:44 Files: 1     Time: 1s
Serial   Phase #:45 Files: 1     Time: 14s
Serial   Phase #:46 Files: 1     Time: 0s
Restart  Phase #:47 Files: 1     Time: 1s
Serial   Phase #:48 Files: 1     Time: 1s
Restart  Phase #:49 Files: 1     Time: 1s
Serial   Phase #:50 Files: 1     Time: 1s
Restart  Phase #:51 Files: 1     Time: 0s
Serial   Phase #:52 Files: 1     Time: 1s
Restart  Phase #:53 Files: 1     Time: 0s
Serial   Phase #:54 Files: 1     Time: 496s
Restart  Phase #:55 Files: 1     Time: 2s
Serial   Phase #:56 Files: 1     Time: 2s
Restart  Phase #:57 Files: 1     Time: 0s
Serial   Phase #:58 Files: 1     Time: 1s
Restart  Phase #:59 Files: 1     Time: 1s
Serial   Phase #:60 Files: 1     Time: 1s
Restart  Phase #:61 Files: 1     Time: 0s
Serial   Phase #:62 Files: 1     Time: 2s
Restart  Phase #:63 Files: 1     Time: 0s
Serial   Phase #:64 Files: 1     Time: 3s
Serial   Phase #:65 Files: 1 Calling sqlpatch with LD_LIBRARY_PATH=/u02/app/oracle/product/12102/lib; export LD_LIBRARY_PATH; LIBPATH=/u02/app/oracle/product/12102/lib; export LIBPATH; LD_LIBRARY_PATH_64=/u02/app/oracle/product/12102/lib; export LD_LIBRARY_PATH_64; DYLD_LIBRARY_PATH=/u02/app/oracle/product/12102/lib; export DYLD_LIBRARY_PATH; /u02/app/oracle/product/12102/perl/bin/perl -I /u02/app/oracle/product/12102/rdbms/admin -I /u02/app/oracle/product/12102/rdbms/admin/../../sqlpatch /u02/app/oracle/product/12102/rdbms/admin/../../sqlpatch/sqlpatch.pl -verbose -upgrade_mode_only > catupgrd_datapatch_upgrade.log 2> catupgrd_datapatch_upgrade.err
returned from sqlpatch
    Time: 79s
Serial   Phase #:66 Files: 1     Time: 511s
Serial   Phase #:68 Files: 1     Time: 0s
Serial   Phase #:69 Files: 1 Calling sqlpatch with LD_LIBRARY_PATH=/u02/app/oracle/product/12102/lib; export LD_LIBRARY_PATH; LIBPATH=/u02/app/oracle/product/12102/lib; export LIBPATH; LD_LIBRARY_PATH_64=/u02/app/oracle/product/12102/lib; export LD_LIBRARY_PATH_64; DYLD_LIBRARY_PATH=/u02/app/oracle/product/12102/lib; export DYLD_LIBRARY_PATH; /u02/app/oracle/product/12102/perl/bin/perl -I /u02/app/oracle/product/12102/rdbms/admin -I /u02/app/oracle/product/12102/rdbms/admin/../../sqlpatch /u02/app/oracle/product/12102/rdbms/admin/../../sqlpatch/sqlpatch.pl -verbose > catupgrd_datapatch_normal.log 2> catupgrd_datapatch_normal.err
returned from sqlpatch
    Time: 98s
Serial   Phase #:70 Files: 1     Time: 210s
Serial   Phase #:71 Files: 1     Time: 2s
Serial   Phase #:72 Files: 1     Time: 0s
Serial   Phase #:73 Files: 1     Time: 27s

Grand Total Time: 2716s

LOG FILES: (catupgrd*.log)

Upgrade Summary Report Located in:
/u02/app/oracle/product/12102/cfgtoollogs/fisan02/upgrade/upg_summary.log

Grand Total Upgrade Time:    [0d:0h:45m:16s]

once upgrade is successful then execute below script in DB

@utlrp.sql

@/OLD_ORACLE_BASE/postupgrade_fixups.sql

Post-upgrade Checks
---------------------------------

1.Select comp_name,version,status from dba_registry;

 All should be valid 

2. Select banner from v$version