Upgrade Oracle Database to : SOA Suite Install Part II

Next step in installing SOA Suite after installing database is to upgrade this oracle database to version (4547817).

For Oracle Database Installation Step and Software location click here

If you selected Standard Edition during database installation, you can skip this database upgrade step. This is because for Enetrprise Edition Database, SOA Suite is certified only with and higher (in 9i database) or version ( For Standard Edition database is certified with SOA Suite

For detailed information on how to upgrade from database to version follow readme of patch 4547817 or metalink note 316900.1

Few things about patch set
i) patch set is not complete software, You can only apply it on top of existing 10.2.0.X installation.
ii) This patchset on linux can be applied on following version of linux Suse 9, Red Hat AS/ES 3, 4

Pre Installation Steps
i) Download patch p4547817_10202_LINUX.zip (download patch according to your operating system like windows, solaris..) and copy it to your linux machine

ii) Unzip patch as “unzip p4547817_10202_LINUX.zip”

iii) Set ORACLE_HOME and ORACLE_SID to your database (10.2.0.X) on which you are planning to apply this patchset . In my case its
ORACLE_HOME = /home/oracle/product/10.2.0/db

(Command to export environment variable differ as per your shell, above command is used for bash, bourne or ksh)

iv) Stop database and database listener as mentioned at end of database installation in my previous post

v) Backup your system (In case anything goes wrong)

Database Patch Set Installation
i) Login as user who installed 10.2.0.X database (In my case its “oracle” )

ii) cd patchset_unzip_directory/DISK1

iii) ./runInstaller

iv) On welcome screen click Next

v) On Specify file location screen, in Name field and Path select Database on which you wish to apply this patch (If you have multiple database installed on your machine you will see drop down menu to select database oracle_home)

vi) On summay screen, click Install

vii) In the end when prompted to run root.sh , login as root from another window and execute root.sh in ORACLE_HOME

viii) In the end of installation screen click Exit, and click Yes to exit from Oracle Universal Installer

This step will complete database software upgraded to patchset but we haven’t upgraded our database yet to (In next step we will upgrade our database to version).

Upgrade 10.2.0.X database to
Please note steps mentioned here are for upgrading database to from 10.2.0.X version, for upgrade from previous release (8i, 9i, 10g) refer metalink note mentioned above

i) Make sure you have applied patchset on oracle_home (on which database is installed)

ii) Login as database owner (oracle) and exexute sqlplus “/as sysdba”

iii) SQL> startup upgrade
iv) SQL> spool 10202upgrade.log
v) SQL> @?/rdbms/admin/catupgrd.sql
vi) SQL> spool off

(Check if there are any error message in 10202upgarde.log and rerun catupgrd.sql after fixing errors)

In the end of log file (10202upgarde.log) you should see output like below with component version as

vii) SQL> shutdown
viii) SQL> startup
ix) SQL> @?/rdbms/admin/utlrp.sql
x) SQL> select count(*) from dba_objects where status like ‘INVALID’;
Count (*)
xi) SQL> shutdown immediate (After upgrade and invalid object compilation restart your database cleanly)
xii) lsnrctl start
xiii) SQL> startup

This completes your oracle database upgrade to version.

If you are hitting any issues in upgrade, raise them in forum dedicated to apps dba’s at http://teachMeOracle.com/forum or leave a comment here.

Loading ORABPEL, ORAESB and ORAWSM schema in above database and SOA Suite installation coming next…

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

rishikm says November 12, 2007


This OAS install doens’t have seperte infra and midtier components ,is it all in one oracle home now

Atul says November 13, 2007

There is no DB so you can configure it against existing database else you have to install DB in seperate oracle_home. To configure SSO/OID with 10.1.3 product there are additional steps

rishikm says November 13, 2007

Hi Atul,

Thanks for the response.
Where I can find the additional steps for the Configuration of SSO/OID with SOA 10.1.3



Atul says November 13, 2007

SOA suite is mainly OC4J so check

http://download-uk.oracle.com/docs/cd/B31017_01/web.1013/b28957/configldap.htm#CEGJHDIB for Oracle SSO/OID Integration with SOA Suite

cdmnagaraj says October 27, 2009

Hello Atul,

Do we have a patch for HP UNix Oracle 10g DB available before installing SOA Suite.

I need patch set for HP Unix and IRCA as well. Please let me know the link.

Add Your Reply