Friday, 27 April 2018

Oracle Database Upgrade 11G,12C,18C

Steps to upgrade database from Oracle 11g to 12C to 18C

1: Change Oracle directory to new Home then rdbms/admin
cd Oracle_12C_Home/rdbms/admin
2: Login to sqlplus with old Oracle home,and run preupgrd.sql present in 12C home
3:If em is configured it has to be stoped before running database in upgrade mode
          emctl stop dbconsole
4:Run UTLU112I.sql
         Gather dictionary Statistics and Empty the recycle bin
5:Set Oracle12C home
    Set Oracle SID
    Copy Parameter file from Oracle_11G_Home to Oracle_12C_home/dbs
 
6:Startup upgrade
7:catctl.pl -n 4 catupgrd.sql
   This runs upgrade in parallel 4.
8:postupgrade_fixup.sql
9:utlu122s.sql (Pre upgrade Status tool)
10:catuppst.sql------------------------>Timexone Upgrade if required.
11: utlrp.sql-------------------------------->Object validation


Soon I will add database  upgrade with screenshot.
Stay Tunned

How to login on Oracle Cloud Console?

Login Steps for Oracle Cloud Console To sign in to Oracle Cloud Console, We need to open up the corresponding region console URL for Free Ti...