Upgrading from Oracle 10.2.0.1 to 10.2.0.4

On this post I’d like to share with you how to install and setup the Oracle 10.2.0.4 patch. This guide also applies for other patches and versions.


1 – Downloading the patch

Go to Oracle Metalink website (metalink.oracle.com) and login.

Click on “Patches & Updates” tab and search for patch number 6810189 as you can see below:

The search should bring the following result:

If your search retrieves too many results try filtering by the platform you’re looking for.

Download the file (if you are downloading from windows transfer it via FTP to the Linux OS you will perform the upgrade. For more details on how to FTP files check on this posthttp://dbaseworld.wordpress.com/2009/07/25/how-to-ftp-and-command-list/).


2 – Unzipping and Installing Patch

Since you have the file in the server you need, unzip the package as follows

unzip p6810189_10204_Linux-x86.zip

After unzipping the package, go to the directory Disk1/response and edit the response file patchset.rsp. Setup the ORACLE_HOME to your actual value and the OUI variables to False since it’s a silent installation.

Run the command below from the Disk1 directory:

. runInstaller -silent -responseFile Disk1/response/patchset.rsp


3 – Startup database and running scripts

After installation completion login the database as sysdba (sqlplus / as sysdba) and startup the database in upgrade mode

SQL> startup upgrade

The database should start and you can run the upgrade script. This may take several minutes to run.

@$ORACLE_HOME/rdbms/admin/catupgrd.sql

When finished shutdown the database and start it normally (startup command) and then run the script below to check if there’s any inactive object.

@/oracle/SID/102_64/rdbms/admin/utlrp.sql

When the script completes the upgrade is done.

To check if the new patch is up and running when you login in sqlplus you should see something like this:

SQL*Plus: Release 10.2.0.4.0

That’s all. If you have any doubts please comment.

Thanks

Advertisements
Leave a comment

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

%d bloggers like this: