In Oracle : Install Oracle Maintenance Wizard for Apps

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

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

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

-> Install Oracle Maintenance Wizard for Apps

 

 Install Oracle Maintenance Wizard for Apps

 

 

1.   What is Maintenance Wizard used for ?

2.   Presentation of my test environment

3.   Prepare the installation

4.   Install the Oracle 10g database Software

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

6.   Create the database for the Maintenance Wizard

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

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

9.   Create the NEWEOF tablespace for the Maintenance Wizard

10. Verify if zip and unzip executables are installed

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

12. Install the Maintenance Wizard

13. Post Install Steps

 

 

1. What is Maintenance Wizard used for ?

 

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 ...

 

     Copyright (c) 2011-2015  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.