Look Apps

Oracle Applications DBA APPSLab

 
R12
  • CREATE CUSTOM TOP IN R12
  • RELEASE12 INSTALLATION
  • R12.AD.A.DELTA.4 PATCH
  • APPS R12 SCRIPTS & LOG FILE LOCATIONS
  • APPS 11i
  • ENABLING SSL FOR E-BUSINESS SUITE
  • 11I INSTALLATION(11.5.10.2 on Redhat Linux AS 4.0 ...
  • Replacing Jinitiator with Sun Java JRE for APPS
  • INDIAN LOCALIZATION PATCH
  • Database Upgrade 9.2.0.6 to 10.2.0.2.0 Oracle App...
  • Multi Node to Single Node Cloning
  • 10G
  • Installing 10G Application Server
  • 10G DATAPUMP
  • INSTALLING 10G DEVELOPER SUITE ON LINUX MACHINE
  • 9i
  • Apply ADI-6 Patch
  • MANUALLY CLONE DATABASE
  • Copy and Rename an Oracle Database - (without expo...
  • linux/Unix
  • LINUX BASICS
  • Training
    Coming Soon
    Search
    Only search this Blog
    GOOGLE Ads
    Coming Soon
    Multi Node to Single Node Cloning
    Saturday, August 30, 2008
    Multi Node to Single Node Cloning

    With Oracle Applications 11.5.10 the ability to clone from a multi node to a single node system using rapid clone has now been certified.

    This is accomplished by the Shared APPL_TOP and Merging APPL_TOP features.

    In this post i am listing out the steps to perform a multi note to a single node cloning from scratch. The information mentioned here is the steps which i have used and found them to be successful for a more elaborate explanation you might want to refer to the metalink note Sharing the Application Tier File System in Oracle E-Business Suite 11i (233428.1).

    Source System here refers to the multi node system to be cloned
    Target System refers to the newly to be created single node system
    Applications Version 11.5.10
    Operating System Linux ES 4

    The following Steps are required to be performed on the source system

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

    The next set of tasks are required to be carried out on the target system that is the system on which you wish to place the merged single node instance.

    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 following application tier directories

    Copy the following application tier directories from the primary node of your source system to the target application tier node, retaining the original directory structure:

    – [APPL_TOP]
    – [OA_HTML]
    – [OA_JAVA]
    – [COMMON_TOP/util]
    – [COMMON_TOP/clone>
    – [806 ORACLE_HOME]
    – [iAS ORACLE_HOME]

    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

    Before proceeding with the next steps you must shutdown your oracle applications services and the database on the source system

    5. Copy the database tier file system

    Log on to the source system as the database user

    Copy the database (DBF) files from the source to the target system
    Copy the source database ORACLE_HOME to the target system

    After this you can now startup the database and applications services on your source system and release it for use.

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

    $ 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

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

    Successful completion of this task will bring up your application tier services on the target or the cloned node.

    8. Post Clone Tasks

    Log in to the target system application tier node as the APPLMGR user.
    Run the following tasks in adadmin for all products:
    o generate JAR files
    o generate message files
    o relink executables
    o copy files to destination

    9. Clean up of the target system

    Remove the temporary directory [COMMON_TOP]/clone/appl to reduce disk space usage.

    Note: The version of Oracle Applications used is 11.5.10 and the operating system is Linux ES 4

    Labels:

    posted by Lokesh Babu @ 10:57 AM  
    0 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Lokesh Babu
    Home: Bangalore, Karnataka, India
    About Me:
    See my complete profile
    Previous Post
    Archives
    Links
    Template by

    Blogger Templates

    BLOGGER