Hi All,

When we upgrade database from 10g to 11g ,

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

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

Oracle database Upgrade from 10.2.0.2 to 10.2.0.4

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

     Example:

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

                                 OR

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

3) Download the Oracle Patch Set 10.2.0.4 from SAP Service Market place

     https://websmp209.sap-ag.de/patches > 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)

Patchset_10204_AIX5Laa.bin

Patchset_10204_AIX5Lab.bin

Patchset_10204_AIX5Lac.bin

Patchset_10204_AIX5Lad.bin

Concatenate the four files using cat command

Example:

cd /oracle/Oraclepatchset

“cat Patchset_10204_AIX5Laa.bin Patchset_10204_AIX5Lab.bin

Patchset_10204_AIX5Lac.bin Patchset_10204_AIX5Lad.bin >> Orapatch.zip”

     unzip Orapatch.zip    # 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

Example:

unzip p5561212_10204_AIX5L.zip

Process for upgrading Oracle Patch Set

To upgrade the Oracle database from 10.2.0.2 to 10.2.0.4, 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”

SQL> SHUTDOWN IMMEDIATE

  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      

  1. d. SHUTDOWN DATABASE
  • sqlplus /”as sysdba”
  • SQL> SHUTDOWN IMMEDIATE
  1. 1. DB Upgrade to 10.2.0.4

  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=10.33.1.5:0.0

               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

./runInstaller

  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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply