Wednesday, April 18, 2007

Upgrade OracleDB

In a project I was requested to install Oracle SOA Suite 10g (

It is interesting that my colleagues simply knew I need to upgrade an existing OracleDB to higher version. But when I asked where do I find the documentation regarding the upgrade, they replied they hit an error before and they solved it but they didn't remember where's the documentation.

Anyway, the summary is, documentation does exist. You may go -> Documentation -> Oracle Application Server -> etc. Please reference the following link for the corresponding OracleDB that is required by SOA Suite 10g installation:

% sqlplus sys/password as sysdba
SQL> select version from product_component_version where product like 'Oracle%9i%' or product like 'Oracle%Database%';

The existing OracleDB is How do I upgrade it to

Steps to find patch for upgrading OracleDB:

1. Login
2. Go to [Patches & Upgrades] tab.
3. Select "Advanced Search".
4. Search with the following options:

* Product Family: RDBMS Server
* Release: Oracle,

5. Then, a list of related items are returned.

I want to upgrade OracleDB to, which one is the right one? Siva simply suggested me to use "4505133 - Oracle Database Family: Patchset PATCH SET FOR ORACLE DATABASE SERVER". I asked him, how do you know is this one? He replied, you click the readme file, then you'll know everything. Magic. Anyway, I trust him, so I just simply download patch 4505133.

Here you go. Upgrade patch is bundled in OUI (Oracle Universal Installer) format. So we simply shutdown all database processes and execute "./runInstaller". OracleDB will be upgraded beautifully.

No comments: