Database upgrade from 11.2.0.1 to 11.2.0.4 on Linux-64bit

This post will cover simple step for database upgrade from 11201 to 11204 on Linux-64bit

  • Old Database: – 11.2.0.1
    11-DB version 2-Release 0-Application release 1-Component release/patch release
  • New Database: – 11.2.0.4
    11-DB version 2-Release 0-Application release 4-Component release/patch release

The below mentioned diagram will give the idea of upgrade patch release with component details.

PIC1

>> Download the Software from My oracle Support with Patch No:13390677

PIC2

>> Check the status of source database version:

PIC3

>> Take back-up of source database11.2.0.1:

PIC4

>> Unzip the below zip files:
There are 7 files available, so that we need only first two files for database upgrade.
Unzip p13390677_112040_Linux-x86-64_1of7.zip
Unzip p13390677_112040_Linux-x86-64_2of7.zip

Go to the below step only if your database is created using DBCA method:
vi /etc/oratab
test:/u01/oracle/app/product/11.2.0/dbhome_1:N
replace it with
test:/u01/oracle/app/product/11.2.0.4/dbhome_1:N

>> Export new ORACLE_HOME in bash_profile:

pic5

>> Install Oracle 11g Software (11.2.0.4) on server with separate ORACLE_HOME:

pic6

Click Next

Click Skip Software update and Click next

Select Install database software only and Click

Click Single instance database installation and Click Next

Select Enterprise Edition and Click Next

Verify the ORACLE_BASE and ORACLE_HOME and Click next

Select dba and Next

Click Install

Installation of Oracle software is in progress…..

Execute configuration scripts with login as root user

Click Close to finish the installation.

Note:-Follow all above step one by one because screenshot is not attached.

>> Source database is up and running:

>> Start upgrade database using DBUA (ie New ORACLE_HOME)

pic8

pic9

Select Database Name and Click Next

pic10

Browser the parameter file path: and Click Yes

pic11

Click Next

pic12

Click Next

pic13

Click Next

pic14

Untick Configure the database with OEM and Click Next

pic15

Click finish

pic16

Database Upgrade is in progress……..

pic18

Check the summary of database upgrade

pic19

>> Run utlrp.sql to recompile Invalid objects:
Go to the directory $ORACLE_HOME/rdbms/admin

SQL> @utlrp.sql

>> Verify that all expected packages, procedures and objects are valid:

SQL> SELECT count (*) FROM dba_invalid_objects;

>> Check status of upgraded database:

SQL>select * from v$version;

SQL>Col COMP_NAME format a20
SQL>Col VERSION format a20
SQL>Col STATUS format a20
SQL>Select COMP_NAME,VERSION,STATUS from dba_registry;

pic20

Its done……..!!!!!!!!

Advertisements