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.binPatchset_10204_AIX5Lab.binPatchset_10204_AIX5Lac.binPatchset_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 thefiles 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. Pre-Upgrade tasks
- 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
- b. Start the Database in Upgrade mode
sqlplus /”as sysdba” SQL> STARTUP UPGRADE
- 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
- d. SHUTDOWN DATABASE
- sqlplus /”as sysdba”
- SQL> SHUTDOWN IMMEDIATE
- 1. DB Upgrade to 10.2.0.4
- 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/tmpdirexport TMPDIR=/oracle/GWQ/sapdata1/tmpdir/
- b. Start the Database Upgrade
Change the directory to the Oracle Patchset directory
cd /oracle/Oraclepatchset/Disk1
- Run the Oracle Universal Installer
./runInstaller