Maintenance Wizard is an Oracle tool (for UNIX or Linux) which can be used for upgrading Oracle APPS to R12. It helps you to reduce upgrade tasks by dynamically filtering the necessary steps based on criteria it obtains from your Applications environment

2. Presentation of my test environment

The Maintenance Wizard will be installed on the host named MW (IP address: 192.168.1.203)
The Oracle Applications 11i is installed on 2 nodes: The Apps tier is installed on the host named APPS (IP address: 192.168.1.202) and the Database tier is installed on the host named DB (IP address: 192.168.1.201).

3. Prepare the installation

the /etc/hosts (on the 3 hosts) must contains the aliases for all 3 hosts
rsh must be enabled on the APPS and DB hosts (ssh also could be enabled) and must allow the owner of the Maintenance Wizard (mw Linux account) to connect to the APPS and DB hosts without prompting for the password. More more details click here: Using Remote Shell on Linux/ UNIX/ AIX.
Download from Metalink the Maintenance Wizard version 2.x, Oracle RDBMS 10.2.0 and iAS 10.1.3
Create the following directories: /ORACLE10g (for the Oracle Home) and /ORA_iAS1013 (for the IAS Oracle Home): We must have 2 separate Oracle Homes for this. Do not try to use an existing Oracle Home !

4. Install the Oracle 10g database Software

a) Prepare the OS for the Oracle database 10g installation (however, this step is needed for the database and not for the Oracle software). For more installation see the Oracle 10g Installation Guide.

b) Run the installer

./runInstaller

c) On the first window, choose the ORACLE_HOME location, uncheck the option called "Create Starter database", choose "Enterprise Edition".

d) Specify a location for the Oracle Inventory

e) When the pre-requisites will be checked and all is ok, click "Next"

f) When the "Summary" window appears click "Install"

g) Exit the installation when the installation will complete.

5. Install the Oracle 10g iAS for use by Maintenance Wizard

a) Run the installer

./runInstaller

Note: If you use a version of Linux which is not validated by the iAS installer you can start the installer with the ignoreSysPrereqs parameter (in this case you must be sure that the other prerequisites are valid ):

./runInstaller -ignoreSysPrereqs

b) Specify the installation directory (iAS Oracle Home), choose "Advanced Installation Mode" and click "Next"

c) Choose "Web Server" option (which contains the Oracle Process Management) and click "Next"

d) Select desired method of port configuration (I suggest "Automatic" method) and click "Next"

e) Choose a name for your instance (example: ias_mw ) and click "Next"

f) Click Next again and after that in the next window press "Install"

g) When the installation complete, exit the installer.

6. Create the database for the Maintenance Wizard

a) Set the ORACLE_HOME variable:

export ORACLE_HOME=<full path to the RDBMS ORACLE_HOME>

b) Run the Database Configuration Assistant

cd $ORACLE_HOME/bin

./dbca

c) Choose "Create a Database" -> "General Purpose" -> specify name for the database ("mw_db" for instance) -> choose to configure the database with Enterprise Manager -> choose a password for SYS and SYSTEM accounts -> choose "File System" as storage mechanism and select a "Common Location" -> Disable Flashback features -> choose NO sample schemas -> configure the SGA, PGA, etc (you can click "Next" to keep the default configuration ) -> When the installation complete, exit the installer.

7. Configure the listener.ora and tnsnames.ora for the Oracle database

Here is the listener.ora configuration template:

SID_LIST_LISTENER =
     (SID_LIST =
          (SID_DESC =
                (SID_NAME = PLSExtProc)
                (ORACLE_HOME = /ORACLE10g)
                (PROGRAM = extproc)
      )

         )

LISTENER =
    (DESCRIPTION_LIST =
            (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = MW.localdomain)(PORT = 1521))
                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
            )
     )

Here is the tnsnames.ora entry to be added (it must be configured for your particular situation):

mwdb =
   (DESCRIPTION =
         (ADDRESS_LIST =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = MW.localdomain)(PORT = 1521))
         )
         (CONNECT_DATA =
             (SERVICE_NAME = mw_db)
         )
    )

8. Set up the tnsnames.ora for the <iAS ORACLE_HOME>

cd <iAS ORACLE_HOME>/network/admin

ln -s <RDBMS ORACLE_HOME>/network/admin/tnsnames.ora tnsnames.ora

9. Create the NEWEOF tablespace for the Maintenance Wizard

Connected as SYSTEM or SYS run:

SQL:\> create tablespace NEWEOF datafile '/ORACLE10g/oradata/mw_db/MW_data_01.dbf' size 50M AUTOEXTEND ON NEXT 10M MAXSIZE 80M;

10. Verify if zip and unzip executables are installed

[mw@MW mw_db]$ which zip
/ORACLE10g/bin/zip
[mw@MW mw_db]$ which unzip
/ORACLE10g/bin/unzip
[mw@MW mw_db]$ which ping
/bin/ping

If the executables are not found, perhaps the PATH variable is not set up correctly.

11. Set the default Linux/ UNIX shell to Korn shell

a) Check the default Linux/ UNIX shell:

[mw@MW mw_db]$ more /etc/passwd | grep mw
mw:x:502:501::/home/mw:/bin/bash

b) Set the default Linux shell to Korn shell (ksh):

       [mw@MW mw_db]$ chsh -s /bin/ksh
       Changing shell for mw.
       Password:
       Shell changed.
       [mw@MW mw_db]$ more /etc/passwd | grep mw
       mw:x:502:501::/home/mw:/bin/ksh

NOTE: This must be done for Maintenance Wizard account, and APPs and Database owners.

12. Install the Maintenance Wizard

a) Login to system as the owner of the Maintenance Wizard (used also to install RDBMS and IAS)

b) Create the eof directory under the ORACLE_HOME directory

c) Download from Metalink the Maintenance Wizard and unzip it under $ORACLE_HOME/eof (which will be EOF_HOME)

d) Set the following environment variables: ORACLE_HOME, ORACLE_SID, IAS_HOME, PATH, TNS_ADMIN, EOF_HOME

In my case I used:

export ORACLE_HOME=/ORACLE10g
export ORACLE_SID=mwdb
export IAS_HOME=/ORA_iAS1013
export PATH=$ORACLE_HOME/bin:$PATH:/ORA_iAS1013/opmn/bin/
export TNS_ADMIN=$ORACLE_HOME/network/admin
export EOF_HOME=$ORACLE10g/eof

e) Run the Maintenance Wizard installation script:

cd $EOF_HOME/config

./setup.sh

f) Respond to the prompts.

NOTES:

If the Maintenance Wizard patch stage is not yet created, this must be done at the prompt time because this task is not done automatically.

The email for Anonymous FTP will be used by the Maintenance Wizard as the password for the any anonymous FTP connections to the Oracle FTP site.

Metalink credentials (username/passwords) will be used to establish a connection with Metalinks and download patches when needed.

The password for sysadmin is the password for Maintenance Wizard admin owner account.

The automated patching and administration features of the tool require that a defaults file be located in the $APPL_TOP/admin/<SID> directory.

The Timeout parameter of IAS_HOME/Apache/Apache/conf/httpd.conf must be modified to a value of 10800 (3 hours) to allow long running steps like patch downloads and merges.

You can rerun the setup.sh script to change the configuration if required.

g) Stop and restart the Oracle Application Server

$ opmnctl stopall

$ opmnctl startall

13. Post Install Steps

The Timeout parameter of IAS_HOME/Apache/Apache/conf/httpd.conf must be modified to a value of 10800 (3 hours) to allow long running steps like patch downloads and merges. After this change the iAS (Oracle Application Server) must be restarted (see step g) ).
Secure the $EOF_HOME/EOF.env: 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 -> Settings -> "Every visit to the page"

-> Check if in the C:\WINDOWS\system32\drivers\etc\hosts there is an entry for the Maintenance Wizard host (example: 192.168.1.203 mw.localdomain mw )
Test the connection to the Maintenance Wizard

http://<hostname>.<domain>:<Apache Port>/EOF/

In my case was http://mw.localdomain:7777/pls/EOF/

Here is the Maintenance Wizard login page:

Install Oracle Maintenance Wizard for Apps

Here is the Maintenance Wizard main page:

Install Oracle Maintenance Wizard for Apps

In-Oracle.com -> Oracle Applications (apps) -> R12

-> Install Oracle Maintenance Wizard for Apps

Oracle Applications EBS 11i, R12 Oracle Database Data Warehouse & BI Oracle Middleware PL/SQL Linux ...

Find related information on Google:

Custom Search

Copyright (c) 2011-2012 www.in-oracle.com | Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.