{"id":685,"date":"2008-07-31T23:57:02","date_gmt":"2008-08-01T03:57:02","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/"},"modified":"2008-08-01T14:03:18","modified_gmt":"2008-08-01T18:03:18","slug":"continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/","title":{"rendered":"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit"},"content":{"rendered":"

Introduction<\/em><\/h2>\n

<\/strong>We need to install the 10.2.0.2 software only follow my last post , the process remain same.<\/p>\n

<\/font><\/strong><\/strong>Up gradation \u00a0of Oracle Database \u00a0on Sun OS using catupgrd.sql \u00a0is same as like other catupgrd.sql on other platforms. The only difference lies in setting operating system parameters like kernel configuration, checking memory, disks and other resources.<\/p>\n

<\/a>\u00a0Objective<\/em><\/h2>\n

The objective of this document is to detail out the Upgradation steps of Oracle 10.2.0.1 to \u00a010.2.0.2 on Sun OS .<\/p>\n

Creating Staging Area on the Server<\/em><\/h2>\n

Staging Area is an area from where you will stage the Oracle 10.2.0.2 Patch \u00a0Software and run the installation programme. Staging area for Oracle 10.2.0.2 \u00a0requires around 1-2 \u00a0GB of disk space.\u00a0Download\u00a0 patch p4547817_10202_SOLARIS64.zip<\/font><\/code> <\/font><\/font>\u00a0from oracle.metalink.com Create directories named as the stage and unzip the patch \u00a0<\/p>\n\n\n\n
Stage<\/td>\nNo.\u00a0 of \u00a0Patch<\/td>\nPatch Contents<\/td>\n<\/tr>\n
Oracle10.2.0.2 Software<\/td>\n1<\/td>\nDisk1 \/d33\/stage\u00a0<\/td>\n<\/tr>\n<\/table>\n

<\/h2>\n

<h2<\/p>\n

<\/h2>\n

Starting Oracle 10G Software Installation.<\/p>\n

Follow the same process as my last post
\nAfter Sucessfull Installation , Follow the below steps to accomplish the task<\/p>\n

Post Install Checks<\/p>\n

Check the log file for any errors .<\/p>\n

Before you Begin Up gradation in Source Database<\/p>\n

a. MANDATORY Patch Release for 10.2.0.2 RDBMS on Sun Sparc Solaris 64-bit Patch 5117016<\/p>\n

b. Check before applying the patch . If $ORACLE_HOME\/rdbms\/lib\/libserver10.a exists, the mandatory patch has probably not been installed.<\/p>\n

c. Read readme.txt and follow the instruction to apply patch.<\/p>\n

Required Pre-upgrade Checks<\/p>\n

a. Check SYSTEM Tablespace Size
\nIf JServer is part of the installation ensure that there is at least 10 MB of free space allocated to the SYSTEM tablespace
\nb. Check SYSAUX Tablespace Size, ensure that there is at least 50 MB of free space allocated to the XDB tablespace.
\nc. Check the SHARED_POOL_SIZE and JAVA_POOL_SIZE Initialization Parameters
\nSet the value of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters as follows:<\/p>\n

d. Start the database:
\nSQL> STARTUP NOMOUNT
\ne.If necessary, enter the following command to determine whether the system uses an initialization parameter file (initsid.ora) or a server parameter file (spfiledbname.ora):
\nSQL> SHOW PARAMETER PFILE;
\nThis command displays the name and location of the server parameter file or the initialization parameter file.
\nf.Determine the current values of these parameters:
\nSQL> SHOW PARAMETER SHARED_POOL_SIZE
\nSQL> SHOW PARAMETER JAVA_POOL_SIZE
\ng.If the system is using a server parameter file:
\ni)If necessary, set the value of the SHARED_POOL_SIZE initialization parameter to at least 150 MB:
\nSQL> ALTER SYSTEM SET SHARED_POOL_SIZE=’150M’ SCOPE=spfile;
\nii)If necessary, set the value of the JAVA_POOL_SIZE initialization parameter to at least 150 MB:
\nSQL> ALTER SYSTEM SET JAVA_POOL_SIZE=’150M’ SCOPE=spfile;
\nh.If the system uses an initialization parameter file, if necessary change the values of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters to at least 150 MB in the initialization parameter file (initsid.ora).
\ni. If you use Automatic Shared Memory Management, ensure that the value of the SGA_TARGET initialization parameter size is at least 50 MB greater than the sum of the values of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters.
\nNote
\nThe value of the SGA_TARGET parameter depends on your environment. If you receive a system error when you restart the database, increase the value of the SGA_TARGET parameter to the value specified in the error.<\/p>\n

f.Shut down the database:
\nSQL> SHUTDOWN<\/p>\n

Database Up gradation
\n$lsncrtl
\n$ start
\n$ sqlplus \/nolog
\nSQL> CONNECT \/ AS SYSDBA
\nSQL> STARTUP UPGRADE
\nSQL> SPOOL patch.log
\nSQL> @?\/rdbms\/admin\/catupgrd.sql
\nSQL> SPOOL OFF
\nCheck patch.log after completion .
\nRun the utlrp.sql script to recompile all invalid PL\/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
\nSQL> @?\/rdbms\/admin\/utlrp.sql<\/p>\n

Check the invalid objects after completion using the following qyery :-
\nspool invalid_pre.lst
\nselect substr(owner,1,12) owner,
\nsubstr(object_name,1,30) object,
\nsubstr(object_type,1,30) type, status from
\ndba_objects where status ‘VALID’;
\nspool off
\nCompile all the invalid objects using
\nRun the following script and then requery invalid objects:
\nThis script must be run as a user with SYSDBA privs using SQL*Plus:
\n$ cd $ORACLE_HOME\/rdbms\/admin
\n$ sqlplus ‘\/as sysdba’<\/p>\n

Even compile all the objects using Adamin utility of Oracle E \u2013Business Suit .<\/p>\n

Summary
\nIn this document we have covered:
\n1. Preparing the Sun Solaris system for Oracle 10.2.0.2 Up gradation .
\n2. Creating Staging Area of Oracle 10.2.0.2 patch
\n3. Installing Oracle 10.2.0.2 on Sun Solaris Server.
\n4. Upgrading Oracle Database from 10.2.0.1 to 10.2.0.2
\nReferences
\nOracle Metlink: https:\/\/metalink.oracle.com.<\/p>\n

<\/font><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction We need to install the 10.2.0.2 software only follow my last post , the process remain same. Up gradation […]<\/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":[1],"tags":[],"class_list":["post-685","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\ncontinuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit -<\/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\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit -\" \/>\n<meta property=\"og:description\" content=\"Introduction We need to install the 10.2.0.2 software only follow my last post , the process remain same. Up gradation […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-08-01T03:57:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-08-01T18:03:18+00:00\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/\",\"name\":\"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-08-01T03:57:02+00:00\",\"dateModified\":\"2008-08-01T18:03:18+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit\"}]},{\"@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":"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit -","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\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/","og_locale":"en_US","og_type":"article","og_title":"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit -","og_description":"Introduction We need to install the 10.2.0.2 software only follow my last post , the process remain same. Up gradation […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/","article_published_time":"2008-08-01T03:57:02+00:00","article_modified_time":"2008-08-01T18:03:18+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/","name":"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-08-01T03:57:02+00:00","dateModified":"2008-08-01T18:03:18+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/continuation-of-last-post-upgradation-from-10201-to-10202-in-e-business-suit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit"}]},{"@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\/685","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=685"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}