Tuesday, November 6, 2007

Oracle Apps Upgrade from to Release 12

Print this post

Upgradation Instructions for Oracle Applications to Release 12
on Redhat Linux AS 4.0 ( Single Node )


1) Installation of Maintenance Wizard on standalone server

Maintenance Wizard must be installed into an RDBMS 10g with a 10g iAS
ORACLE_HOME on a UNIX or Linux machine.

Here is an example of Maintenance Wizard Installation on a standalone server.

Instructions for Maintenance Wizard Installation

Required RPMs

kernel-2.6.9.-11.EL  ( uname -r )


Users and Groups :

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle

Configure Kernel Parameter :

vi /etc/sysctl.conf

kernel.sysrq = 0
kernel.msgmnb = 65535
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 142
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

Save and Run sysctl -p

Set up a shell

You must set up either remote shell (rsh/remsh) or secured shell (ssh) between
the Maintenance Wizard node and every remote Applications node. The tool will
not work without having at least one of these shells successfully configured. Follow
the instructions below for OpenSSH shell you wish to use for remote access:

Setting up OpenSSH: Follow this procedure if you will be using OpenSSH:

On the Maintenance Wizard Node:

Log in as the user who will own Maintenance Wizard.

Generate the ssh key by issuing the following command:

ssh-keygen -t rsa

Press the Enter key three times.

CD into the .ssh directory, which is located under the home directory. Note that
a file called id_rsa.pub is created.

Use FTP to copy id_rsa.pub to the /tmp directory of the Remote Nodes.

On the Remote Node(s):

Login as the user who owns the product being upgraded or maintained. For Applications
tiers, use the applmgr account. For the database tiers, use the oracle account.

Remove specialized .login, .profile or similar files which cause extra verbiage to be
displayed to the screen.

Create a directory called .ssh in the home directory.

If an authorized_keys file does not exist, create a new, empty one.

Copy the content of /tmp/id_rsa.pub (from the Maintenance Wizard Node) into a new
file named authorized_keys. (If you already have a file called authorized_keys in this
directory, open it in vi, go to the bottom of the file, add one blank line and then copy
and paste the contents of the file /tmp/id_rsa.pub into the existing file and save it.)

Verify that the .ssh directory permission is set to 700.

Verify that the authorized_keys file permission is set to 600.

Verify that the $HOME directory does not have write permissions for group and others.

chmod go-w $HOME

Ensure that the ssh daemon is running.

Repeat the above steps for each Remote Node.

Test the installation:

Login to the Maintenance Wizard Node as Maintenance Wizard owner.

Execute the following command, replacing [user] with the username on the Remote
Node, and [SERVER] with the host name of the Remote Node:

ssh -l [user] [SERVER]

      1. When prompted to confirm the identity, respond "Yes".
      2. Disconnect from the server.
      3. Execute the following command:

ssh -l [user] [SERVER] echo 'foo'

Only the word foo should appear, followed by the prompt, and you should not be
asked to enter and ID or password. If you are prompted for a password, verify the

The content of the authorized_keys file contains the content of id_rsa.pub of client

The permissions of the authorized_keys file are set to 600.
The permissions of the .ssh directory are set to 700.
The permissions of the $HOME directory do not include execute for group and other.

If more than the word foo appears, then repeat the step above to remove all .login,
.profile or similar files until ONLY the word foo appears.

Maintenance Wizard version 2.x requires Oracle RDBMS 10g (10.2.0) with 10g iAS (10.1.3).

We recommend that you do not attempt to "re-use" an existing 10g database. Install a
new standalone Oracle 10g ORACLE_HOME for use by Maintenance Wizard.

10g Release 2 Database Installation


* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

Login as the oracle user and add the following lines at the end of the .bash_profile file:

TMP=/tmp; export TMP
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=oracle; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
ulimit -u 16384 -n 65536

Install RDBMS 10g using the following command:


-Specify the desired ORACLE_HOME location.

-Choose "Enterprise Edition".

-Uncheck the option called "Create Starter database". Click NEXT.

-Optionally, specify the oraInventory and operating system group, then click NEXT.

-After successful Product-Specific Prerequisite Checks, choose

"Install database Software only" and click NEXT


-When the installation has completed, exit the installer.

-As same user, Install Oracle 10g iAS ORACLE_HOME.

-Install a new standalone Oracle 10g iAS ORACLE_HOME for use by Maintenance Wizard.

-Set the DISPLAY variable appropriately and export it.

Run the installer.


-Specify the installation directory.

-Choose "Advanced Installation Mode" and click NEXT.

-Choose "Web Server and Process Management" (or "Integrated Web Server,
J2EE Server and Process Management") and click NEXT.

-Select your desired method of port configuration and click NEXT.

-Optionally, select your desired Administration Instance settings and click NEXT.

-Specify your Cluster Topology Configuration and click NEXT.


-Exit the installer.

When the installation has completed, exit the installer.

-Create the database.

-Set the ORACLE_HOME variable appropriately.


-Change to the bin directory.

-cd $ORACLE_HOME/bin

Run the database creation utility.


-Choose "Create a Database".

-Choose "General Purpose".

-Specify the Global Database Name.

-Specify whether to configure to database with Enterprise Manager.

-Set the default password for the SYS and SYSTEM accounts.

-Choose your storage mechanism. We recommend that you choose "File System"
and select a Common Location.

-Specify any desired recovery options.

-Specify NO sample schemas.

-In the Character Sets tab, do NOT modify the Default Language (American)
and Default Date Format (US).

-Specify the desired values for parameters SGA, PGA and processes.

-When the process has completed, exit the Database Creation Assistant. Set up
the listener for the Oracle RDBMS ORACLE_HOME. Create LISTENER.ora and
TNSNAMES.ora files in the Oracle RDBMS $ORACLE_HOME/network/admin directory.


        (ADDRESS = (PROTOCOL = TCP)(HOST = ias.oneapps.com)(PORT = 1521))
    (SID_DESC =
      (GLOBAL_DBNAME = oracle)
      (ORACLE_HOME = /u01/oracle/10.2.0)
      (SID_NAME = oneapps)

TNSNAMES.ora file

      (ADDRESS = (PROTOCOL = TCP)(HOST = ias.oneapps.com)(PORT = 1521))
      (SERVICE_NAME = oracle)

Set up the listener for the Oracle iAS ORACLE_HOME. Either copy the
tnsnames.ora file or create a symbolic link.

To copy the file:

cp <ORACLE_HOME>/network/admin/tnsnames.ora <iAS _HOME>/network/admin/

Or, to create a symbolic link:

cd <iAS _HOME>/network/admin
ln -s <ORACLE_HOME>/network/admin/tnsnames.ora tnsnames.ora

Create the NEWEOF tablespace where the Maintenance Wizard schema objects
will be stored. Connect to sqlplus as the system user, and execute the following
command substituting in the full path to your datafile.

create tablespace NEWEOF datafile '/u01/oracle/oradata/eof01.dbf' size 50M

Verify that Zip and UnZip executables are installed and that ping is in the
$PATH using the following commands:

which zip
which unzip
which ping

Installation Steps

Login to the system as the same UNIX user that you used to install the
RDBMS and iAS.

Ensure that the $ORACLE_HOME environment variable is set to point at RDBMS
10g before proceeding. At a minimum, make sure the following variables are set.

TWO_TASK=<connect_string >;export TWO_TASK
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

Create a directory to extract the tool into (this will become your $EOF_HOME).
Oracle recommends that you create the Maintenance Wizard directory in the
RDBMS $ORACLE_HOME directory.  Then set the $EOF_HOME environment variable
as follows:

mkdir eof

Download the latest Maintenance Wizard Full Install version ( Patch 6398371
as of now ) and unzip it into ${EOF_HOME}.

Change directory to the $EOF_HOME/config directory.

cd ${EOF_HOME}/config

Run the installation script.


Respond to the prompts shown below. Default values are shown in brackets.


Domain name for Maintenance Wizard Node [us.oracle.com]:
SYSTEM password for the Maintenance Wizard instance [manager]:
Schema name for storing Maintenance Wizard. [NEWEOF]:
Maintenance Wizard patch stage [$EOF_HOME/patches]:
Email for Anonymous FTP []
Metalink Username []:
Metalink Password []:

You have the option to review your entries and make changes before the install begins.

Domain =
Oracle Home =
Connect String =
System Password =
Database Schema =
EOF Patch Stage =
Email for Anonymous FTP =
OracleMetaLink Username =
OracleMetaLink Password =

Choose option 2 to review the todo.txt file for information about additional steps
that you must perform, then choose option 3 to exit the installer.

- Stop and restart iAS.

- opmnctl stopall
- opmnctl startall

Post Install Steps

� Secure the $EOF_HOME/EOF.env file.

  • chmod 700 $EOF_HOME/EOF.env
  • Setup a client machine with Microsoft Internet Explorer (IE) 6.0 or higher.
  • In IE, under Tools -> Internet Options, click Settings. Select the radio button
    for "Every visit to the page."
  • Click OK twice to exit IE Internet Options.
  • Login to the tool using the following URL and the pre-assigned username and
    password: SYSADMIN/SYSADMIN:



Coming Soon the Pre-Upgrade, Upgrade and Post Upgrade of Release 12.

1 comment:

Anonymous said...

Hi - I'm dcollier of dcollierpc8 and I don't mind that you are using my patches applied query, but please see my Note:364439.1 for the latest version and the caveats associated with this!