Step by Step Upgrade to 11.2.0.3 from 11.2.0.1 on Linux

Step by Step Upgrade to 11.2.0.3 from 11.2.0.1 on Linux

SQL> select version from v$instance;

VERSION

-----------------

11.2.0.1.0

SQL>

• Download patch p10404530_112030_Linux-x86-64_1of7.zip & p10404530_112030_Linux-x86-64_2of7.zip and unzip it. This will create a directory name “database”.

• Create one directory 11.3.0 to create new oracle home

cd /u01/app/oracle/product

mkdir 11.3.0

export ORACLE_SID=<Oracle SID>

export ORACLE_HOME=/u01/app/oracle/product/11.3.0

export PATH=$ORACLE_HOME/bin:$PATH

• Install the oracle software only on this new oracle home.

• Check correct oracle sid should point in  /etc/oratab and there should not be multiple ORACLE_HOME for same SID. i.e RAC1:/u01/app/oracle/product/11.3.0:N

• Copy init.ora/spfile and password file (orapw<sid>.ora) from 11.2.0.1 $ORACLE_HOME/dbs to 11.2.0.3 $ORACLE_HOME/dbs

• Copy listener and tnsnames.ora file from 11.2.0.1 home to 11.2.0.3 home and modify it, if needed.

• Download pre-upgrade utility script utlu112i_5.sql. MOS document ID 884522.1 and correct if any issue.

•  Purge DBA_RECYCLEBIN if this contains any objects.

• Gather dictionary status.

• Go to New ORACLE_HOME .. > /u01/app/oracle/product/11.3.0/bin and run dbua command 

 

          ./dbua 

Follow the  screen for options.

your database is upgraded to 11.2.0.3. Change .bash_profle for new ORACLE_HOME.