{"id":156,"date":"2007-06-16T04:52:00","date_gmt":"2007-06-16T08:52:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=156"},"modified":"2009-07-11T03:41:30","modified_gmt":"2009-07-11T07:41:30","slug":"upgrade-oracle-database-to-10202-soa-suite-install-part-ii","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/","title":{"rendered":"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II"},"content":{"rendered":"

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).<\/p>\n

<\/span>For Oracle Database 10.2.0.1 Installation Step and Software location click here <\/span><\/strong><\/a><\/span><\/p>\n

If you selected Standard Edition<\/strong> during 10.2.0.1 database installation, you can skip this database upgrade step<\/em>. This is because for Enetrprise Edition<\/strong> 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<\/span>).<\/p>\n

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<\/p>\n

Few things about 10.2.0.2 patch set
\n<\/strong>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.
\nii) This patchset on linux can be applied on following version of linux Suse 9, Red Hat AS\/ES 3, 4<\/p>\n

Pre Installation Steps <\/strong>
\n——————————-<\/strong>
\ni) Download patch p4547817_10202_LINUX.zip (download patch according to your operating system like windows, solaris..) and copy it to your linux machine<\/p>\n

ii) Unzip patch as \u201cunzip p4547817_10202_LINUX.zip\u201d<\/p>\n

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
\nORACLE_HOME = \/home\/oracle\/product\/10.2.0\/db
\nORACLE_SID = SOADEV <\/strong>
\nexport ORACLE_HOME ORACLE_SID
\n<\/strong>(Command to export environment variable differ as per your shell, above command is used for bash, bourne or ksh<\/span>)<\/p>\n

iv) Stop database and database listener as mentioned at end of database installation in my previous post<\/p>\n

v) Backup your system (In case anything goes wrong)<\/p>\n

Database 10.2.0.2 Patch Set Installation <\/strong>
\n————————————————
\n<\/strong>i) Login as user who installed 10.2.0.X database (In my case its \u201coracle\u201d )<\/p>\n

ii) cd patchset_unzip_directory\/DISK1<\/p>\n

iii) .\/runInstaller<\/p>\n

iv) On welcome screen click Next<\/strong><\/p>\n

v) On Specify file location screen, in Name<\/strong> field and Path<\/strong> 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<\/span>)<\/p>\n

<\/a><\/p>\n

.\u00a0<\/p>\n

vi) On summay screen, click Install<\/strong><\/p>\n

<\/a><\/p>\n

.\u00a0<\/p>\n

vii) In the end when prompted to run root.sh , login as root<\/strong> from another window and execute root.sh<\/strong> in ORACLE_HOME<\/p>\n

viii) In the end of installation screen click Exit<\/strong>, and click Yes <\/strong>to exit from Oracle Universal Installer<\/p>\n

This step will complete database software upgraded to patchset 10.2.0.2 but we haven\u2019t upgraded our database yet to 10.2.0.2 (<\/em><\/strong>In next step we will upgrade our database to 10.2.0.2 version). <\/em><\/strong><\/p>\n

Upgrade 10.2.0.X database to 10.2.0.2 <\/strong>
\n—————————————————-<\/strong>
\nPlease 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<\/p>\n

i) Make sure you have applied patchset 10.2.0.2 on oracle_home (on which database is installed)<\/p>\n

ii) Login as database owner (oracle) and exexute sqlplus \u201c\/as sysdba\u201d<\/p>\n

iii) SQL> startup upgrade
\niv) SQL> spool 10202upgrade.log
\nv) SQL> @?\/rdbms\/admin\/catupgrd.sql
\nvi) SQL> spool off<\/p>\n

(Check if there are any error message in 10202upgarde.log and rerun catupgrd.sql after fixing errors<\/span><\/em>)<\/p>\n

In the end of log file (10202upgarde.log) you should see output like below with component version as 10.2.0.2.0<\/p>\n

<\/a><\/p>\n

vii) SQL> shutdown
\nviii) SQL> startup
\nix) SQL> @?\/rdbms\/admin\/utlrp.sql
\nx) SQL> select count(*) from dba_objects where status like \u2018INVALID\u2019;
\nCount (*)
\n0
\nxi) SQL> shutdown immediate (After upgrade and invalid object compilation restart your database cleanly)
\nxii) lsnrctl start
\nxiii) SQL> startup<\/span><\/p>\n

This completes your oracle database upgrade to 10.2.0.2 version. <\/strong><\/p>\n

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


\nLoading ORABPEL<\/span>, ORAESB<\/span> and ORAWSM<\/span> schema in above database and SOA<\/span> Suite installation coming next…<\/span><\/strong><\/p>\n

http:\/\/teachMeOracle.com\/forum<\/p>\n","protected":false},"excerpt":{"rendered":"

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). […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424,38,43],"tags":[],"class_list":["post-156","post","type-post","status-publish","format-standard","hentry","category-database","category-soa","category-upgrade"],"yoast_head":"\nUpgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II -\" \/>\n<meta property=\"og:description\" content=\"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). […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/\" \/>\n<meta property=\"article:published_time\" content=\"2007-06-16T08:52:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-07-11T07:41:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/\",\"name\":\"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg\",\"datePublished\":\"2007-06-16T08:52:00+00:00\",\"dateModified\":\"2009-07-11T07:41:30+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#primaryimage\",\"url\":\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg\",\"contentUrl\":\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II -","og_description":"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). […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/","article_published_time":"2007-06-16T08:52:00+00:00","article_modified_time":"2009-07-11T07:41:30+00:00","og_image":[{"url":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/","url":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/","name":"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#primaryimage"},"thumbnailUrl":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg","datePublished":"2007-06-16T08:52:00+00:00","dateModified":"2009-07-11T07:41:30+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#primaryimage","url":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg","contentUrl":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnTa-yZnRiI\/AAAAAAAAAmg\/5sOfawIcksg\/s400\/db_upg_1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/16\/upgrade-oracle-database-to-10202-soa-suite-install-part-ii\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=156"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/156\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}