Upgrading database to

Introduction and scope:

This document is intended for those which are having database installation and intended to upgrade the same to, by applying patchset.

This document is based on Metalink note ID 316900.1. Follow the below procedure for upgrading the database from to


We are assuming that you have already have a database at level. This patchset has to be applied over and above

Pre Installation Steps:

  1. Download patch p5337014_10203_LINUX.zip (download patch according to your operating system like windows, solaris..) and copy it to your linux machine
  2. Unzip patch as “unzip p5337014_10203_LINUX.zip”
  3. Set ORACLE_HOME and ORACLE_SID to your database ( on which you are planning to apply this patchset .
  • ORACLE_HOME = /slot01/oracle/db/tech_st/10.2.0
  • ORACLE_SID = mz1st121

4. Stop database and database listener
5. Take a cold backup of your complete database.

Update Oracle Time Zone Definitions

Run utltzuv2.sql

SQL> @utltzuv2.sql

If the output shows “TIMEZONE data is consistent with the latest version 3 transition rules No need to validate TIMEZONE data” then we can simply skip other actions related to this and continue next step.

Else if the time zone definations are not consistant, please apply the patch 5601428 before proceeding.

Database Patch Set Installation Steps:

Set the ORACLE_HOME and ORACLE_SID Environment Variables
Stop all process
Shutdown database

Login as oracle user, make sure that DISPLAY variable is set correctly and check xclock command is opening a clock. Change directory to patchset unziped directory and run the following command


bash-2.05$ ./runInstaller -invPtrLoc /slot01/oracle/db/tech_st/10.2.0/oraInst.Loc

Choose the correct ORACLE_HOME name and location. Remember that you are upgrading the existing ORACLE_HOME.

Other screens are simple and self explanatory.

Check opatch version after ORACLE_HOME is upgraded.

bash-2.05$ cd $ORACLE_HOME
bash-2.05$ cd OPatch/
bash-2.05$ opatch version
Invoking OPatch

OPatch Version:

OPatch succeeded.

Now we have upgraded the ORACLE_HOME to Next thing is to upgrade the database from to For this you need to open the database in upgrade.

  1. Mount the database and check the parameters first and check the parameters SHARED_POOL_SIZE and JAVA_POOL_SIZE. Values for these parameters should be atleast 150M. If not please set the values to atleast 150M.
  2. shutdown and startup again in upgrade mode.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 427819008 bytes
Fixed Size 2029464 bytes
Variable Size 398461032 bytes
Database Buffers 25165824 bytes
Redo Buffers 2162688 bytes
Database mounted.
Database opened.

SQL> spool upgrade.log
SQL> @?/rdbms/admin/catupgrd.sql


SQL> spool off

Once the upgrade is done. Check any errors in the spooled file. If every thing is OK you can proceed to recompile the invalids using utlrp.sql script present in ORACLE_HOME/rdbms/admin directory.

After recompiling shutdown the database and startup for allowing access to the users.

4 thoughts on “Upgrading database to

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s