Skip to Content
Author's profile photo Former Member

Oracle database Upgrade from to

Hi All,

When we upgrade database from 10g to 11g ,

Firstly check the database of 10g if it is then need to upgrade to

I have create a document for this. Please see the details.

Oracle database Upgrade from to

Prerequisites and Precautionary actions before starting DB Upgrade:

1) Take a backup of the Oracle database: Online or Offline

2) Take a file system level backup of 102_64 Directory

     Tar command or backup command or even cp (Recursive) is

     recommended for oracle binary backup as it will back up the links and

     Permissions of the binaries


     tar –cvf 102_64.tar ./oracle/<SID>/102_64


     cp –pR /oracle/<SID>/102_64 /backup  

3) Download the Oracle Patch Set from SAP Service Market place > Database Patches (from other vendors)

     Add the four BIN files to the download basket as shown below and download it

4) Copy the files to the DB Server (AIX) :

Ftp the downloaded files to Server where DB Instance runs:

Directory should have 10 GB Free space (check by du –g command)





Concatenate the four files using cat command


cd /oracle/Oraclepatchset

“cat Patchset_10204_AIX5Laa.bin Patchset_10204_AIX5Lab.bin

Patchset_10204_AIX5Lac.bin Patchset_10204_AIX5Lad.bin >>”

     unzip    # this will create the Oracle Patch directory “Disk1”

Change the ownership of the directory to oracle user and dba group

“chown –R ora<sid>:dba Disk1”  as root user

4) Download Opatch tool and all the Opatch available from SAP SMP and copy the

files to a directory in the DB Server and unzip the files using unzip command



  1. 3. Post -Upgrade tasks
  1. a. Start the Oracle Database in UPGRADE MODE
  • Switch user as oracle user:  su – ora<sid>


  • Start Oracle database in upgrade mode:

                sqlplus /”as sysdba”

                SQL> STARTUP UPGRADE

  1. b. Run the CATUPGRD.SQL command

                 sqlplus /”as sysdba

SQL> SPOOL patch.log

                 SQL> @?/rdbms/admin/catupgrd.sql

                 SQL> SPOOL OFF

  1. c. Restart the Database 

                 sqlplus /”as sysdba”

                 SQL> SHUTDOWN IMMEDIATE

                 SQL> STARTUP

Then apply latest SBP.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.