Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II

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

For Oracle Database 10.2.0.1 Installation Step and Software location click here

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

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

Few things about 10.2.0.2 patch set
i) 10.2.0.2 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
ORACLE_SID = SOADEV

export ORACLE_HOME ORACLE_SID
(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 10.2.0.2 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 10.2.0.2 but we haven’t upgraded our database yet to 10.2.0.2 (In next step we will upgrade our database to 10.2.0.2 version).

Upgrade 10.2.0.X database to 10.2.0.2
—————————————————-
Please note steps mentioned here are for upgrading database to 10.2.0.2 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 10.2.0.2 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 10.2.0.2.0

vii) SQL> shutdown
viii) SQL> startup
ix) SQL> @?/rdbms/admin/utlrp.sql
x) SQL> select count(*) from dba_objects where status like ‘INVALID’;
Count (*)
0
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 10.2.0.2 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…

About the Author Atul Kumar

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

follow me on:

Leave a Comment:

5 comments
rishikm says November 12, 2007

Hi,

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

Reply
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

Reply
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

Regards,

Rishi

Reply
Atul says November 13, 2007

Rishi,
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

Reply
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 10.2.0.2 patch set for HP Unix and IRCA as well. Please let me know the link.

Reply
Add Your Reply

Not found