Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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



Process for upgrading Oracle Patch Set

To upgrade the Oracle database from to, follow the process given below:

  1. 1. Pre-Upgrade tasks

  1. a. Shutdown the Oracle Database

  • Switch user as oracle user:  su – ora<sid>
  • Stop listener service : lsnrctl stop     
  • Shutdown Oracle database:

               sqlplus /”as sysdba”


  1. b. Start the Database in Upgrade mode

sqlplus /”as sysdba”

                SQL> STARTUP UPGRADE

  1. c. Run the Pre-Upgrade information tool

  • SQL> SPOOL upgrade_info.log
  • SQL> @?/rdbms/admin/utlu102i.sql

  • Out put of the Pre-upgrade information tool will look like this

IF it prompts to run catupgrd.sql run

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


  • sqlplus /"as sysdba"

  1. 1. DB Upgrade to

  1. a. Set the environment variables for oracle user

  • Connect to DB Server using XManager
  • Switch user as oracle user:  su – ora<sid>
  • Make a temp directory for Oracle Patchset Installation

mkdir /oracle/<SID>/sapdata1/tmpdir

               setenv DISPLAY IPAddress: 1.0

               export DISPLAY=

               setenv TMPDIR /oracle/<SID>/sapdata1/tmpdir

export TMPDIR=/oracle/GWQ/sapdata1/tmpdir/

  1. b. Start the Database Upgrade

Change the directory to the Oracle Patchset directory 

cd /oracle/Oraclepatchset/Disk1

  • Run the Oracle Universal Installer


  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.

Labels in this area