TriniDBA

This document shows how to upgrade the 9i database in 11i E-Business Suite to 10g on Linux.

Metalink Reference:

Doc ID:  362203.1 (Subject:  Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0))

Section 1: Upgrading an 11i Database to Oracle Database 10g Release 2 (10.2.0)

Ignore steps 1 – 5 in the Metalink document.

Begin at Step 6.

Step 6:        Prepare to create the 10.2.0 Oracle home

Download Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86

10201_database_linux32.zip (668,734,007 bytes) (cksum – 2737423041)

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html

http://www.oracle.com/technology/documentation/database10gr2.html

http://www.oracle.com/technology/support/metalink/index.html

Step 7:        Install the base 10.2.0 software

Install Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86

Refer to chapter 3, Oracle Database Installation Guide 10g Release 2 (10.2)

Unzip 10201_database_linux32.zip

Create directory: /u01/oracle/visdb/10.2.0

Ensure OS meets requirements for 10g

Set ORACLE_HOME=/u01/oracle/visdb/10.2.0

Set ORACLE_SID=VIS

Begin installation (./runInstaller)

• Advanced installation
• Choose Enterprise Edition installation type
• Do not upgrade existing database
• Install database software only

Note: You may need to increase the swap file to 4GB before installing 10g.

Step 8:        Install Oracle Database 10g Products from the 10g Companion CD

Refer to section 3.5, “Installing Oracle Database 10g Products” in the Oracle Database Companion CD Installation Guide

Unzip 10201_companion_linux32.zip

Ensure OS meets requirements for 10g (should be in place)

Set ORACLE_HOME=/u01/oracle/visdb/10.2.0

Set ORACLE_SID=VIS

Begin installation (./runInstaller)

• Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
• Choose the 10g Home

Step 9:        Perform 10.2.0.4 patch set pre-installation tasks

Oracle® Database Patch Set Notes

10g Release 2 (10.2.0.4) Patch Set 3 for Linux x86

Metalink Doc ID: 316900.1

Download patch 6810189 (p6810189_10204_Linux-x86.zip)

Unzip p6810189_10204_Linux-x86.zip

Ensure OS meets requirements for 10g (should be in place)

Set ORACLE_HOME=/u01/oracle/visdb/10.2.0

Set ORACLE_SID=VIS

Stop all processes (dbconsole, iSQL*Plus, database listener)

Backup Oracle Inventory, Oracle database, Oracle Home

Begin installation (./runInstaller)

• Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
• Choose the 10g Home

Perform 10.2.0.4 patch set pre-installation tasks

On the database server node, as the owner of the Oracle 10g file system and database instance, unzip and extract the 10.2.0.4 patch set file for your platform. Read the patch set notes (usually README.html). Make sure you thoroughly understand the upgrade and patch set installation process before you begin. Check OracleMetaLink or contact Oracle Support Services to determine any known issues with the patch set and its interoperability with Oracle E-Business Suite.

Perform the tasks in the “Preinstallation Tasks” section of the patch set notes (if they apply to your system).

Step 10:   Perform 10.2.0.4 patch set installation tasks

On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in the “Installing the Oracle Database 10g Patch Set Interactively” section of the patch set notes. Make sure that:

The ORACLE_HOME environment variable points to the new 10.2.0 Oracle home.

The PATH environment variable includes $ORACLE_HOME/bin and the directory where the new perl executable is located (usually $ORACLE_HOME/perl/bin).

The LD_LIBRARY_PATH environment variable includes $ORACLE_HOME/lib.

The PERL5LIB environment variable points to the directories where the new perl libraries are located (usually $ORACLE_HOME/perl/lib/<perl version> and $ORACLE_HOME/perl/lib/site_perl/<perl version>)

You use the runInstaller (UNIX/Linux) or the setup.exe executable (Windows) provided in the patch set to run OUI.

Step 11:    Create nls/data/9idata directory

Run: perl $ORACLE_HOME/nls/data/old/cr9idata.pl script

Modify set10g.env:

export ORA_NLS10= ORACLE_HOME/nls/data/9idata

Step 12:   Apply additional 10.2.0.4 RDBMS patches

Download from Metalink and apply:

6880880 or the latest OPatch version.

6521934

6600051

7496636

7497678

cd $ORACLE_HOME

unzip /u01/patches/p6880880_102000_LINUX.zip