{"id":659,"date":"2008-07-31T23:55:55","date_gmt":"2008-08-01T03:55:55","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/"},"modified":"2008-08-01T14:02:10","modified_gmt":"2008-08-01T18:02:10","slug":"oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/","title":{"rendered":"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2"},"content":{"rendered":"

Oracle E \u2013Business suit 11.5.10.2 does not work with the database 10.2.0.1 so we need to upgrade the database to the next patch set level 10.2.0.2
\n\u00a0\u00a0 <\/strong><\/font>Next post following this one is about upgradation from 10.2.01. to 10.2.0.2
\n<\/strong>.
\n<\/font>Introduction<\/font>
\n<\/strong><\/u>Upgradation of Oracle Database on Sun OS using DBUA is same as like other DBUA on other platforms. The only difference lies in setting operating system parameters like kernel configuration, checking memory, disks and other resources.
\n.<\/p>\n

2. Objective
\n<\/font><\/u><\/strong>The objective of this document is to detail out the Upgradation steps of Oracle 9.2.0.6 to 10GR2 on Sun OS using DBUA .<\/p>\n

.
\n3. Audience
\n<\/font><\/u><\/strong>This document is for Oracle Applications DBA. It is expected DBA performing the installation has fair knowledge of the Sun Solaris (UNIX) Operating System.<\/p>\n

.
\n4. Assumption
\n<\/font><\/u><\/strong>\u2022 The Sun Solaris (UNIX) Operating System is installed on the Sun Solaris Hardware with all the required resources.
\n\u2022 All the required file systems are created with sufficient disk space as required for Oracle Applications Software and Database.
\n\u2022 The Staging area for Oracle Database is created
\n\u2022 Application DBA performing installation has a graphical interface with the Sun OS system. We are going to use xmanger 2.0 software for accessing the Sun OS from remote client.
\n\u2022 The openwin – xterm process is running on the server.<\/p>\n

.<\/p>\n

5. Pre \u2013 Requisite
\n<\/font><\/u><\/strong>Before Starting Upgrading process we have to apply two important patches in the Source
\n1. 10g Release 2 interoperability patch for 11.5.10 (4653225)
\n2. 5478710 (TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH O
\nRefer Metalink Note 362203.1<\/p>\n

6. Creating Staging Area on the Server
\n<\/font><\/u><\/strong>Staging Area is an area from where you will stage the Oracle 10GR2\/Companion Software and run the installation programme. Staging area for Oracle 10GR2 requires around 3-4 GB of disk space.<\/p>\n

Mount the DVD\u2019s of Oracle 10GR2\/Download from oracle websites otn.oracle.com on the server and copy the DVD\u2019s in the staging location.<\/p>\n

Create directories named as the stage (this you can get from the DVD\u2019s component.label file).
\nCopy all the DVD\u2019s of similar components in same stage area.<\/p>\n

Stage No. of DVD\u2019s DVD Contents
\nOracle11 Software 1 Disk1 \/d33\/stage
\nOracle Companion 1 Disk2 d33\/stage \/stage1<\/p>\n

.
\n7. Checking the Sun Operating System
\n<\/font><\/u><\/strong>System and hardware Configuration:
\nHardware Status: sun4 (UNIX command; \u2018arch\u2019)
\nOperating System: SunOS 5.11 Generic sun4u sparc SUNW, Sun-Fire-V240 (UNIX command; \u2018uname \u2013a\u2019).
\nCPU: 2 CPU\u2019s. Each having the sparcv9 processor operates at 1503 MHz and has a sparcv9 floating point processor (UNIX command; \u2018psrinfo \u2013v\u2019).
\nMemory size: 5120 Megabytes (UNIX command; \u2018prtconf |grep size\u2019).
\nSwap Total: (45440k bytes allocated + 4032k reserved = 49472k used) 14468936k available, i.e., 14GB (UNIX command; \u2018swap \u2013s\u2019).
\nCheck file System mounted and its respective size (UNIX command; \u2018df -h\u2019).<\/p>\n

8. Create base directories for Oracle 10GR2 installation
\n<\/font><\/u><\/strong>From the mounted file system decide which file system will hold the database tier
\nFor Ex:
\n\/d35 \u2013 32 GB \u2013 Oracle 10G Database Software (ORACLE_10GHOME RDBMS,)Create directory \u201c\/d35\/ora10G\/10.2.0\u201d<\/p>\n

9. Create OS group and Users<\/font><\/u><\/strong> and granting required privileges and file permissions
\nCreate operating system group \u201cDBA\u201d and OS users \u201cora10G\u201d for database tier . Note that we are planning to upgrade database tier owned by \u201coracle\u201d user but both on the same host \/ system. But new Oracle_10G Home owner and source Oracle_9i Home owner should fall under same group.<\/p>\n

Check the group created in \u201c\/etc\/group\u201d
\n# cat \/etc\/group |grep dba
\ndba::110:<\/p>\n

Create Unix Users \u201coracle \u201d
\nAdd these lines in \u201c\/etc\/passwd\u201d file:
\nora10G:x:113:110::\/orahome\/ora10g:\/bin\/sh<\/p>\n

Add these lines in \u201c\/etc\/shadow\u201d file:
\nOra10g:30oQlK30ch6xY:13187::::::
\nNote that the user id is always unique and also the home directory given is the base directory as created above.<\/p>\n

Give ownership of \u201c\/d35\/ora10G\u201d to \u201cora10G\u201d .
\n# chown -R ora10G:dba \/d35\/ora10G
\n# ls -lrt \/d35
\n\/u01:
\ntotal 18
\ndrwx—— 2 root root 8192 Jan 13 13:16 lost+found
\ndrwxr-xr-x 2 oracle dba 512 Jan 23 12:34 ora10G<\/p>\n

Give full file permissions on the staging area of Oracle Applications. Give \u201c777\u201d privileges on the staging area. Some unzip files are not able to get unzipped and then the installation gives error.<\/p>\n

# pwd
\n\/u06\/stage
\n# ls
\ninstall runInstaller stage1
\ndoc response stage welcome.html
\n#
\n# chmod -R 777 *
\n# pwd
\n\/u06\/stage
\n#<\/p>\n

.
\n10. Universal Installer<\/font><\/u><\/strong><\/p>\n


\n<\/font><\/u><\/strong>11 Starting the X Windows session
\nLogin to Server from a graphical interface console.<\/p>\n

We are using Xmanager2.0 software for Oracle Universal Install and DBUA.<\/p>\n

a href=”https:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.JPG” mce_href=”https:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.JPG”><\/a<\/p>\n

Go to option and select ->Session->Java Desktop System 3 <\/font><\/p>\n

Environment settings<\/p>\n

Logged in as \u201cora10G\u201d \u00a0and set the profile Example ORACLE_BASE=\/d35\/test\/v10G;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE\/10.2.0; export ORACLE_HOMEORACLE_SID=PATCH ; export ORACLE_SIDLD_LIBRARY_PATH=$ORACLE_HOME\/lib ; export LD_LIBRARY_PATHPATH=$PATH:\/usr\/local\/bin:\/usr\/ccs\/bin:\/usr\/sfw\/bin:$ORACLE_HOME\/bin ; export PATHVerify the profile using $ env|more Check the inventory_loc in Sun Solaris it is located in \/var\/opt\/oracle\/oraInst.loc \u00a0change the inventory location Check the oratab file in Sun Solaris it is located in \/var\/opt\/oracle\/oratab and comment the source instance because we are following the same ORACLE_SID for new ORACLE_10G .Example is below :- #v1:\/d35\/oracle\/v1db\/9.2.0:N<\/p>\n

.<\/p>\n

11.2 Starting Oracle 10G Software Installation.<\/font><\/h3>\n

\u00a0Go to\u201d\/d33\/stage\u201d and execute \u201c.\/runInstaller\u201d command. The \u201cOracle 10g Database Installation Screen will Appear\u201d.
\nIn this screen change Global Database Name and enter password click Next.<\/p>\n

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

.\u00a0<\/h3>\n

\n11.3 Product Specific Prerequisite Checks<\/font><\/h3>\n

In \u201cProduct Specific Prerequisite Checks\u201d Click Next . If any errors or warning appears rectify an proceed<\/p>\n

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

.<\/p>\n

<\/a>11.4 Configuration Options<\/font><\/h3>\n

Select \u201cInstall Database Software Only \u201d and click \u201cNext\u201d.<\/p>\n

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

.<\/p>\n

<\/a>11.5 Oracle Universal Installer Summary<\/font><\/h3>\n

In the \u201cOracle Universal Installer Summary\u201d screen accept the default and click \u201cInstall \u201d.<\/p>\n

<\/a>11.6 Install<\/h3>\n

In \u201cInstall\u201d You have to monitor the log file. The log file location has been highlighted in the screen.<\/p>\n

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

<\/a>11.7 Execute Configuration Scripts<\/h3>\n

In \u201cConfiguration Scripts\u201d screen select \u201cok\u201d and follow the instruction the screen.<\/p>\n

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

<\/a>11.8 End of Installation<\/h3>\n

In the \u201cEnd of Installation\u201d Screen click Exit<\/p>\n

<\/a>11.9 Oracle 10G Companion Software Installation<\/h3>\n

Go to\u201d\/d33\/stage\/stage1\u201d and execute \u201c.\/runInstaller\u201d command. In the welcome screen click next<\/p>\n

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

<\/a>11.10 Select Product to Install<\/h3>\n

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

<\/a>11.11 Specify Home Details<\/h3>\n

In the \u201cSpecify home Details\u201d screen update the details as required and click \u201cNext\u201d.<\/p>\n

<\/a>11.12 Product Specific Prerequisite Checks<\/h3>\n

In \u201cProduct Specific Prerequisite Checks\u201d Click Next. If any errors or warning appears rectify and proceed.<\/p>\n

<\/a>11.13 Oracle Universal Installer Summary<\/h3>\n

In the \u201cOracle Universal Installer Summary\u201d screen accept the default and click \u201cInstall\u201d.<\/p>\n

11.14 End of Installation<\/h3>\n

In the \u201cEnd of Installation\u201d Screen click Exit.<\/p>\n

<\/a>11.15 Post Install Checks <\/strong>\u00a0<\/strong>Check the log file for any errors .Login as Oracle 10G_home owner and check whether you are able to connect as sys $ sqlplus \u201c\/as sysdba\u201d<\/p>\n

you will get the follwing output $ sqlplus “\/as sysdba”\u00a0SQL*Plus: Release 10.2.0.1.0 – Production on Wed May 23 13:19:31 2007\u00a0Copyright (c) 1982, 2005, Oracle.\u00a0 All rights reserved.\u00a0\u00a0Connected to an idle instance:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit ProductionWith the Partitioning, OLAP and Data Mining options\u00a0SQL>\u00a0\u00a0<\/font><\/p>\n

11.16 Before you Begin Up gradation \u00a0in Source Database <\/strong><\/p>\n

a.<\/font><\/strong> Log in to the system as the owner of the new 10gR2 ORACLE_HOME and copy the following files from the 10gR2 ORACLE_HOME\/rdbms\/admin directory to a directory outside of the Oracle home, such as the \/tmp directory on your system:\u00a0ORACLE_HOME\/rdbms\/admin\/utlu102i.sql ORACLE_HOME\/rdbms\/admin\/utltzuv2.sql\u00a0Make a note of the new location of these files.\u00a0
\n.
\nb.<\/strong> <\/font>Login as ORACLE_SOURCE\u00a0 home owner. Go to \/var\/opt\/oracle\/oratab remove the comment and startup the database.\u00a0Now you connect as sys owner from location where you have copied utlu102i.sql and utltzuv2.sql in sqlplus $ sqlplus \u201c\/as sysdba\u201d\u00a0 SQL>@ utlu102i.sqlSQL> spool off \u00a0<\/p>\n

c.<\/font><\/strong> The above sql generate output file called updatelog.lst review the output made the changes accordingly in target init.ora .SQL>@ utltzuv2.sqlSQL> spool off \u00a0\u00a0The above sql generate output file called timezone.log review the output and change accordingly .\u00a0<\/font><\/p>\n

.
\n<\/font>d. <\/font>Check for the deprecated CONNECT Role<\/font><\/strong>\u00a0<\/font>After upgrading to 10gR2, the CONNECT role will only have the CREATE SESSION<\/font>privilege; the other privileges granted to the CONNECT role in earlier releases will be <\/font>revoked during the upgrade. <\/font><\/p>\n

\u00a0 To identify which users and roles in your database are granted <\/font>the CONNECT role, use the following query:<\/font>\u00a0<\/font>\u00a0<\/p>\n

<\/font>SELECT grantee FROM dba_role_privs\u00a0
\n<\/font>WHERE granted_role = ‘CONNECT’ and\u00a0<\/font>grantee NOT IN (\u00a0<\/font>‘SYS’, ‘OUTLN’, ‘SYSTEM’, ‘CTXSYS’, ‘DBSNMP’,\u00a0<\/font> ‘LOGSTDBY_ADMINISTRATOR’, ‘ORDSYS’, <\/font>‘ORDPLUGINS’,\u00a0 ‘OEM_MONITOR’, ‘WKSYS’, ‘WKPROXY’,\u00a0<\/font>\u00a0 ‘WK_TEST’, ‘WKUSER’, ‘MDSYS’, ‘LBACSYS’, ‘DMSYS’,<\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘WMSYS’,\u00a0 ‘OLAPDBA’, ‘OLAPSVR’, ‘OLAP_USER’,\u00a0<\/font>\u00a0‘OLAPSYS’, ‘EXFSYS’, ‘SYSMAN’, ‘MDDATA’,<\/font>\u00a0\u00a0‘SI_INFORMTN_SCHEMA’, ‘XDB’, ‘ODM’);<\/font>\u00a0<\/p>\n

<\/font>\u00a0<\/font>\u00a0<\/font>If users or roles require privileges other than CREATE SESSION, then grant <\/font>the specific required privileges prior to upgrading. The upgrade scripts <\/font>adjust the privilegesfor the Oracle-supplied users.<\/font><\/p>\n

.\u00a0<\/font><\/p>\n

e. <\/font>In Oracle 9.2.x and 10.1.x CONNECT role includes the following privileges:<\/strong><\/font>\u00a0<\/font>\u00a0<\/p>\n

<\/font>SELECT GRANTEE,PRIVILEGE FROM DBA_SYS_PRIVS<\/font>WHERE GRANTEE=’CONNECT’ ;<\/font><\/p>\n

\u00a0<\/font>GRANTEE PRIVILEGE<\/font>—————————— —————————<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE VIEW<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE TABLE<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ALTER SESSION<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE CLUSTER<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE SESSION<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE SYNONYM<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE SEQUENCE<\/font>CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

CREATE DATABASE LINK<\/font>\u00a0<\/font>\u00a0<\/font>\u00a0<\/font>In Oracle 10.2 the CONNECT role only includes CREATE SESSION privilege.<\/font>\u00a0\u00a0<\/p>\n

.<\/p>\n

f. <\/font>Create the script for dblink incase of downgrade of the database<\/strong>.\u00a0During the upgrade to 10gR2, any passwords in database links will be encrypted. To downgrade back to the original release, all of the database links with encrypted passwords must be dropped prior to the downgrade. Consequently, the database links will not exist in the downgraded database. If you anticipate a requirement to be able to downgrade back to your original release, then save the information about affected database links from the SYS.LINK$ table, so that you can recreate the database links after the downgrade.\u00a0<\/p>\n

.<\/p>\n

g.<\/font> Following script can be used to construct the dblink<\/strong>.\u00a0\u00a0\u00a0<\/p>\n

SELECT<\/font>‘create ‘||DECODE(U.NAME,’PUBLIC’,’public ‘)||’database link ‘||CHR(10)<\/font>||DECODE(U.NAME,’PUBLIC’,Null, U.NAME||’.’)|| L.NAME||chr(10)\u00a0\u00a0\u00a0 <\/font>||’connect to ‘ || L.USERID || ‘ identified by ”’<\/font>||L.PASSWORD||”’ using ”’ || L.host || ””\u00a0\u00a0 <\/font>||chr(10)||’;’ TEXT<\/font>FROM\u00a0 sys.link$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 L,\u00a0\u00a0\u00a0\u00a0\u00a0 <\/font>sys.user$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UWHERE L.OWNER# = U.USER# ;\u00a0<\/p>\n

.
\nh.<\/font> Check the invalid objects in source instance using the following qyery :-
\n<\/strong>spool invalid_pre.lst<\/font>select substr(owner,1,12) owner,\u00a0<\/font>substr(object_name,1,30) object,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/font>substr(object_type,1,30) type, status from\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/font>dba_objects where status <>’VALID’;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n<\/font>spool off\u00a0\u00a0\u00a0\u00a0\u00a0
\n<\/font>Compile all the invalid objects using <\/font>Run the following script and then requery invalid objects: <\/font>This script must be run as a user with SYSDBA privs using SQL*Plus:
\n<\/font>$ cd $ORACLE_HOME\/rdbms\/admin
\n<\/font>$ sqlplus ‘\/as sysdba’
\n<\/font>SQL> @utlrp.sql<\/font>\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/font>Even\u00a0 compile all the objects using Adamin utility of Oracle E \u2013Business Suit<\/font> .\u00a0<\/p>\n

.<\/p>\n

i.<\/font> Take Complete Backup of source \u00a0Application and Database <\/font><\/strong>\u00a0\u00a0\u00a0\u00a0<\/font><\/p>\n

\u00a0\u00a0<\/h3>\n

11.17\u00a0\u00a0\u00a0\u00a0 Copy the Important Parameter files<\/h3>\n

a.<\/font>\u00a0Login to Source ORACLE_HOME <\/font>$ cd $ORACLE_HOME\/dbs<\/font>Copy init<SID>.ora to target ORACLE_10G home <\/font>$ORACLE_HOME\/network <\/font><\/p>\n

Copy tnsnames.ora and listener.ora to target TNS_ADMIN directory <\/font><\/p>\n

b. <\/font>Made changes in init<SID>.ora\u00a0 <\/font>and the changes which was suggested by the utlu102i.sql output.c. Made changes in Tnsanames.ora and Listener.ora as per situation.\u00a0<\/p>\n

.<\/p>\n

12. Database Upgrade Assistant<\/font><\/u> <\/font><\/strong>\u00a0
\n<\/strong>Login to Xsession\u00a0 again as target Oracle_10g home owner <\/font>\u00a0
\n$cd $ORACLE_HOME\/bin<\/font>\u00a0$.\/dbua <\/font>\u00a0<\/font>\u00a0\u00a0<\/p>\n

<\/a>12.1 Database Upgrade Assistant Welcome Screen<\/font><\/h3>\n

In the \u201cDatabase Upgrade Assistant Welcome Screen\u201d Click Next <\/font><\/p>\n

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

\u00a0<\/font>12.2\u00a0\u00a0\u00a0 <\/strong>Database Upgrade Assistant Steps 1
\n<\/strong><\/font>In \u201cDatabase Upgrade Assistant\u201d choose the proper source database click Next<\/font><\/p>\n

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

12.3\u00a0\u00a0\u00a0 <\/strong>Database Upgrade Assistant Steps 2
\n<\/strong>In \u201cDatabase Upgrade Assistant Steps 2 \u201c It will take 20 to 30 minutes to get the database information and then click Next.<\/font><\/font> <\/font><\/p>\n

12.4\u00a0\u00a0\u00a0 <\/strong>Database Upgrade Assistant Steps 3<\/strong><\/font><\/p>\n

In the \u201cDatabase Upgrade Assistant Steps 3\u201d Click Yes <\/font><\/p>\n

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

12.5\u00a0\u00a0 <\/strong>Database Upgrade Assistant Steps 4
\n<\/strong><\/font>In the \u201cDatabase Upgrade Assistant Steps 4\u201d \u00a0Change the datafile location according to requirement Click Next <\/font><\/p>\n

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

12.6\u00a0\u00a0 Database Upgrade Assistant Steps 5<\/h3>\n

Compile invalid Objects<\/strong><\/p>\n

In the \u201cDatabase Upgrade Assistant Steps 5 Compile Invalid Objects\u201d Select Degree of Parallelism. Degree of Parallelism depend on Number of CPU. <\/font><\/p>\n

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

12.7\u00a0 Database Upgrade Assistant Steps 6<\/h3>\n

In \u201cDatabase Upgrade Assistant Steps 6\u201d Select \u201cI have already backed up my database\u201d<\/font><\/p>\n

And click Next <\/font><\/p>\n

12.8\u00a0\u00a0 Database Upgrade Assistant Steps 7 Database Credentials<\/h3>\n

In \u201cDatabase Upgrade Assistant Steps 7 Database Credentials\u201d \u00a0Enter password and click Next<\/p>\n

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

<\/a>12.9\u00a0 Database Upgrade Assistant Steps 7 of 7 Summary<\/h3>\n

In \u201cDatabase Upgrade Assistant Steps 7 of 7 Summary\u201d Click Finish <\/font><\/p>\n

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

12.10 \u00a0Database Upgrade Assistant Progress<\/h3>\n

Now its time to monitor log\u00a0 file <\/font><\/p>\n

\u00a0End of Database Upgrade Assistant<\/p>\n

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

.<\/p>\n

13\u00a0Errors Encountered and the Solution\u00a0<\/font><\/u><\/h3>\n

a.<\/font> While running runInstaller Script encountered the following errors :- <\/font>.\/runInstaller: \/backup\/database\/install\/.oui: cannot execute<\/font>\u00a0<\/font>This error was due to bad media, So I downloaded following files from otn.oracle.com<\/p>\n

    \n
  1. 10Gr2_db_sol.cpio\u00a0 (Oracle 10GR2 Software )<\/li>\n
  2. 10Gr2_companion_sol.cpio (Oracle Companion Software)<\/li>\n<\/ol>\n

    Create Stage directory in any mount point give e.g.\u00a0 \/d33\/stage\u00a0 777 permission to that directory # cat 10Gr2_db_sol.cpio | cpio \u2013icd\u00a0\u00a0 <Enter>\u00a0
    \nIt will extract entire software under stage directory.\u00a0\u00a0 \u00a0
    \nCreate Stage1 directory under stage directory e.g. d33\/stage \/stage1 give 777 permission to that directory \u00a0\u00a0\u00a0\u00a0\u00a0
    \n#\u00a0 cat 10Gr2_companion_sol.cpio | cpio \u2013icd\u00a0\u00a0 <Enter>\u00a0
    \nIt will extract entire software under stage directory.\u00a0<\/p>\n

    b.<\/font> While Running DBUA I have found the following errors :-<\/p>\n

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

    This is due to target and the source database owner is not in same group
    \n<\/font>Login as root; \u00a0\u00a0Example source oracle database owner group is\u00a0 dba , so change it accordingly .
    \n<\/font># usermod -g dba ora10g
    \n<\/font>Login as ora10g owner and execute the following command
    \n<\/font>$cd $ORACLE_HOME
    \n<\/font>$ ls -l `find . ! -user ora10g`
    \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/font>In my system it gave the following output
    \n<\/font>-rwsr-x— 1 root dba 69028 2006-07-17 21:20 .\/bin\/extjob*
    \n<\/font>-rwsr-s— 1 root dba 18845 2006-06-21 09:13 .\/bin\/nmb*
    \n<\/font>-rwsr-s— 1 root dba 19999 2006-06-21 09:13 .\/bin\/nmo*
    \n<\/font>-r-sr-s— 1 root dba 14456 2006-02-04 21:57 .\/bin\/oradism*
    \n<\/font>-rw-r—– 1 root dba 1534 2005-12-22 13:39 .\/rdbms\/admin\/externaljob.ora<\/font>
    \n
    \nChange ownership to the Oracle_10g Home using following command
    \n<\/font>#chown \u2013R ora10g:dba \/<Location> (<\/font>Loging as Oracle_10g home owner) example ora10g<\/p>\n

    <\/font>$ cd $ORACLE_HOME\/rdbms\/lib
    \n<\/font>$mv\u00a0 config.o config.o.bkp<\/font>Edit config.s file
    \nand change the lines<\/font>\u00a0<\/font>\/* 0x0008 15 *\/ .ascii “v2dba”<\/font>\/* 0x0014 20 *\/ .align 8<\/font>.L13:<\/font>\/* 0x0014 22 *\/ .ascii “v2dba”<\/font>to<\/font>\/* 0x0008 15 *\/ .ascii “dba”<\/font>\/* 0x0014 20 *\/ .align 8<\/font>\u00a0<\/font>.L13:<\/font>\/* 0x0014 22 *\/ .ascii “dba”<\/font>$Edit\u00a0 env_rdbms.mk <\/font>From : <\/font>KPIC_OPTION=-K PIC<\/font>To : <\/font>KPIC_OPTION=-xarch=v9 -K PIC<\/font>$ make -f ins_rdbms.mk config.o ioracle<\/font>It has solved the problem <\/font><\/p>\n

    .<\/font><\/p>\n

    14. Summary<\/font><\/u><\/em><\/h2>\n

    In this document we have covered:
    \n1. Preparing the Sun Solaris system for Oracle 10GR2 Up gradation .
    \n2.\u00a0Creating Staging Area of Oracle 10GR2\u00a0 Software.
    \n3.\u00a0Installing Oracle 10GR2 along with Companion Products\u00a0 on Sun Solaris Server.
    \n4.\u00a0Upgrading Oracle Database from 9.2.0.6 to 10GR2<\/p>\n

    <\/a><\/a><\/a>15. References<\/font><\/u><\/em><\/h2>\n

    Oracle Metlink: https:\/\/metalink.oracle.com<\/a>\u00a0<\/p>\n

    <\/h3>\n","protected":false},"excerpt":{"rendered":"

    Oracle E \u2013Business suit 11.5.10.2 does not work with the database 10.2.0.1 so we need to upgrade the database to […]<\/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-659","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2 -<\/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\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2 -\" \/>\n<meta property=\"og:description\" content=\"Oracle E \u2013Business suit 11.5.10.2 does not work with the database 10.2.0.1 so we need to upgrade the database to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-08-01T03:55:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-08-01T18:02:10+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.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=\"12 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\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/\",\"name\":\"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2 -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.JPG\",\"datePublished\":\"2008-08-01T03:55:55+00:00\",\"dateModified\":\"2008-08-01T18:02:10+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.JPG\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2\"}]},{\"@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":"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2 -","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\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/","og_locale":"en_US","og_type":"article","og_title":"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2 -","og_description":"Oracle E \u2013Business suit 11.5.10.2 does not work with the database 10.2.0.1 so we need to upgrade the database to […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/","article_published_time":"2008-08-01T03:55:55+00:00","article_modified_time":"2008-08-01T18:02:10+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.JPG","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/","name":"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2 -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.JPG","datePublished":"2008-08-01T03:55:55+00:00","dateModified":"2008-08-01T18:02:10+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.JPG","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/07\/c1.thumbnail.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/07\/31\/oracle-database-upgradation-9206-to-10gr2-on-sunos-and-oracle-e-business-suit-115102\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"ORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2"}]},{"@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\/659","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=659"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/659\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}