Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Cloning Oracle Applications from Multinode to Single Node - Merge APPL_TOP

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Cloning Oracle Applications from Multinode to Single Node - Merge APPL_TOP

    Pre-cloning Tasks

    1. Check that patches are applied /Apply application tier patches using adpatch

    Apply patch 4038964
    Apply patch 4175764
    Both the above patches are include in the consolidated update 2 or CU2 so in case you are on 11.5.10.2 or later you can ignore this step.

    2. Maintain snapshot information

    Log in as the applications user on each application tier node and run ‘Maintain Snapshot Information’ by using adadmin.

    3. Merge existing APPL_TOPs

    Log in to the primary node of your application tier as the application user user and run:
    $ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
    $ perl adpreclone.pl appsTier merge
    This will prompt you with option to merge secondary nodes
    Now log in as the applications user to each of the secondary application tier nodes being merged and run:

    $ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
    $ perl adpreclone.pl appltop merge

    4. Prepare the source system database tier.

    Log on to the database tier of the source system as the oracle user and run the following commands:
    $ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
    $ perl adpreclone.pl dbTier
    With this all the pre clone tasks on the source system have been completed.

    Steps to be performed on target system

    1. Create OS user accounts

    Create a OS user account for your applications
    $ useradd -g dba -d [home_directory] -p password username
    Similarly create a OS user account for your database

    2. Modify the orainventory to reflect the new location

    $ vi /etc/oraInst.loc


    3. Copy the Source System to the Target System

    Copy the application tier file system from the source Applications system to the target node by executing the following steps in the order listed. Ensure the application tier files copied to the target system are owned by the target APPLMGR user, and that the database tier files are owned by the ORACLE user.

    A good idea is to tar the directories in the sources and untar it on the target node.
    This would not cause any permission problems and links would be preserved.

    a Copy the database tier file system

    Log on to the source system database node as the ORACLE user.

    Option 1 - Cold Backup
    Perform a normal shutdown of the source system database and Applications
    Copy the database (DBF) files from the source to the target system
    Copy the source database ORACLE_HOME to the target system

    Option 2 - Hot backup
    Put database in begin backup mode
    Copy the database (DBF) files from the source to the target system
    Put the database in end backup mode
    Copy the source database ORACLE_HOME to the target system

    Start up the source Applications system database and application tier processes if you are copying using Cold Backup


    b Copy the application tier file system

    Log on to the source system application tier nodes as the APPLMGR user.

    Copy the following application tier directories from the source node to the target application tier node:

    A good idea is to tar the directories in the sources and untar it on the target node.
    This would not cause any permission problems and links would be preserved.

    <APPL_TOP>
    <806 ORACLE_HOME>
    <iAS ORACLE_HOME>
    <COMMON_TOP>

    <COMMON_TOP> will autumatically include :
    <OA_HTML>
    <OA_JAVA>
    <OA_JRE_TOP>
    <COMMON_TOP>/util
    <COMMON_TOP>/clone
    <COMMON_TOP>/_pages (when this directory exists)

    Note: Unix/Linux users, make sure that the softlinks are preserved when copying. Therfore tar is a better option

    4. Copy the required files for merging

    Log in as the applications user to each of the secondary source nodes and recursively copy:
    directory [COMMON_TOP]/clone/appl
    - to -
    directory [COMMMON_TOP]/clone/appl on the target system node


    5. Configure the target system database server

    Log on to the target system as the database user and type the following commands to configure and start the database:

    Option 1 - Cold Backup being Used

    Log on to the target system as the ORACLE user and type the following commands to configure and start the database:
    cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
    perl adcfgclone.pl dbTier

    This will prompt for new ORACLE_SID,ORACLE_HOME,Port Pool,JAVA_TOP and DATA_TOP give the appropriate values matching your target system
    Once successful this should start your database and listener

    Option 2 - Hot Backup being Used

    Log on to the target system as the ORACLE user

    - Configure the <RDBMS ORACLE_HOME>
    cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
    perl adcfgclone.pl dbTechStack

    - Create the target database control files manually
    Start the target system database in open mode

    - Run the library update script against the database
    cd <RDBMS ORACLE_HOME>/appsutil/install/<CONTEXT NAME>
    sqlplus "/ as sysdba" @adupdlib.sql <libext>
    where <libext> is "sl" for HP-UX, "so" for any other UNIX platform and not required for Windows.

    - Configure the target database (the database must be open)
    cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
    perl adcfgclone.pl dbatabase <target context file>
    where target context file is:
    <RDBMS ORACLE_HOME>/appsutil/<Target CONTEXT_NAME>.xml

    6. Configure the application tier server nodes

    The database and its listener should remain up before executing the next set of commands.

    Log in to the merged APPL_TOP node as the applications user and execute the following commands:
    $ cd [COMMON_TOP]/clone/bin
    $ perl adcfgclone.pl appsTier

    This will prompt you new port pool for applictaion tier services as well as new APPLTOP,COMMON_TOP,ORACLE_HOME and IAS_ORACLE_HOME
    Successful completion of this task will bring up your application tier services on the target or the cloned node.

    Post-cloning Tasks are given in the Thread Related to Post Clone : Post-Refresh-Clone-Checks-Procedures-for-11i-R12

+ Reply to Thread

Similar Threads

  1. admrgpch - Merge multiple Patches
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 5
    Last Post: 05-08-2012, 12:35 PM
  2. Oracle Database Single Instance To RAC Conversion Using RCONFIG.
    By ajaychandi in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 04-26-2012, 12:52 PM
  3. Create virtual RAW disks for Oracle ASM on Linux with single Hard Drive
    By devesh_ocp in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 04-24-2012, 04:08 PM
  4. :mad:Error while Doing Multinode installation
    By dbaANKIT in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 5
    Last Post: 01-28-2012, 08:10 AM
  5. Oracle Applications R12 Multinode Installation
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 01-03-2012, 12:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics