Forgot your password?    
+ Reply to Thread
Page 1 of 6 123 ... LastLast
Results 1 to 10 of 52

Thread: Clone Oracle Applications 11i / R12

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

    Clone Oracle Applications 11i / R12

    Clone Oracle Applications 11i / R12
    ===========================
    Use Rapid Clone to create template files for cloning on the source system. After the source system is copied to the target, Rapid Clone updates these templates to contain the new target system configuration settings. Rapid Clone will not change the source system configuration.

    There are three phases to the cloning process:

    1. Prepare the Source System

    Execute the following commands to prepare the source system for cloning.

    a) Prepare the source system database tier for cloning

    Log on to the source system as the ORACLE user and run the following commands:
    cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
    perl adpreclone.pl dbTier

    b) Prepare the source system application tier for cloning

    Log on to the source system as the APPLMGR user and run the following commands on each node that contains an APPL_TOP:
    cd <COMMON_TOP>/admin/scripts/<CONTEXT_NAME>
    perl adpreclone.pl appsTier

    FOR R12

    cd <INST_TOP>/admin/scripts
    perl adpreclone.pl appsTier

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

    To take the Hot Backup for your Database , Use this script :
    Dynamic-Script-to-take-Hot-Backup-of-Oracle-Database

    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

    3 Configure the Target System

    Execute the following commands to configure the target system. You will be prompted for the target system specific values (SID, Paths, Ports, etc)

    a Configure the target system database server

    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

    *If you are Using RMAN , Duplicate the Database from source to target.

    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 dbconfig <target context file>
    where target context file is:
    <RDBMS ORACLE_HOME>/appsutil/<Target CONTEXT_NAME>.xml


    b Configure the target system application tier server nodes

    On the applications Tier nodes , make sure you copy the database tns entry from the database tier to the
    806 ORACLE_HOME/network/admin/tnsnames.ora

    set the ORACLE_HOME to the target 806 ORACLE_HOME
    set the TNS_ADMIN to $ORACLE_HOME/network/admin
    set the TWO_TASK to the connection Identifier proided in tnsnames.ora

    ie. before you run adcfgclone.pl , you should be able to connect to the database using sqlplus as apps ( apps/<appspwd>@<conection_identifier>)

    Log on to the target system as the APPLMGR user and type 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.

    Follow Clone Checks /Post Clone checks / tasks at various points of the Refresh, refer to the Post Clone Thread :
    Post-Refresh-Clone-Checks-Procedures-for-11i-R12

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    ( Post clone Checks and Procedures are given in a seperate thread )

  3. #3
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    Hi
    I am trying to do CLONE but getting error while doing it. I am running
    perl adcfgclone database contextname and getting the following error

    Cannot proceed with ApplyDatabase - the paths/ports in the context file are not valid.
    RC-20403: The following port numbers are busy - please make sure the ports are available and try again.
    Raised by oracle.apps.ad.clone.ApplyDatabase
    s_dbport : 1620
    --------------------------------------
    StackTrace:
    java.lang.Exception: Cannot proceed with ApplyDatabase - the paths/ports in the context file are not valid.
    at oracle.apps.ad.clone.ApplyDatabase.validateContext (ApplyDatabase.java:495)

    I have provided port number 99 and its totally a unique port then why i am getting error.
    Kindly suggest

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    You must have run the clone twice.

    The first time you ran it , it started the database listener at this port , so ext time its not able to start it at this port.
    solutions:

    ps -ef | grep tns
    and kill the running listener process and rerun the clone

    or select a different port.

  5. #5
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    Now i have selected a different port i.e port 75 and i am running
    perl adcfgclone.pl database XML and now getting following error

    RC-00118: Error occurred during creation of database
    Raised by oracle.apps.ad.clone.ApplyDatabase


    StackTrace:
    java.lang.Exception: Control file creation failed
    at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDat abase.java:399)
    at java.lang.reflect.Constructor.newInstance(Native Method)
    at oracle.apps.ad.clone.util.CloneProcessor.run(Clone Processor.java:68)
    at java.lang.Thread.run(Thread.java:479)

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

    When you do the following (using hot backup) , it will not create a controlfile.
    The Database should be up when you run perl adcfgclone.pl dbatabase <target context file>
    (The controlfile will be created manually , prior to running the following ):

    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

  7. #7
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    Hi
    If i am doing cloning from multinode to single node and using SHARED APPL_TOP then what would be the procedure?
    *Do we still need to merge APPL_TOP?

  8. #8
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    If your source is using shared APPL_TOP , we cannot and dont require to merge as there is only one APPL_TOP
    If your source is using distributed APPL_TOP , we would need to merge to create the target appltop

  9. #9
    Hi Hemant sir,
    I am trying to create clone of oracle application. I ran the perl adcfgclone.pl dbTechStack command in the bin folder of the clone in testdb it ran all well after providing the respective input. while i am trying to connnect to the oracle using sqlplus i am getting error
    [oratestnew@localhost test_localhost]$ sqlplus

    SQL*Plus: Release 9.2.0.5.0 - Production on Sun Mar 4 16:05:30 2012

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: / as sysdba
    ERROR:

    ORA-01031: insufficient privileges

    please guide me where i getting wrong

    thanks
    Manish Kumar

  10. #10
    Oracle Administrator
    Join Date
    Oct 2011
    Location
    Venice
    Posts
    40
    Environment variable TWO_TASK could help

    unset TWO_TASK

    and try reconnecting sqlplus
    Cheers !
    pk.ora

+ Reply to Thread
Page 1 of 6 123 ... LastLast

Similar Threads

  1. Post Clone Checks,Procedures for 11i / R12
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 8
    Last Post: 04-11-2012, 03:21 PM
  2. Clone a Database Using a Hot Backup
    By Hemant in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 2
    Last Post: 02-18-2012, 12:14 AM
  3. Clone Database using RMAN Duplicate Database Feature
    By Hemant in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 0
    Last Post: 11-23-2011, 11:38 AM
  4. Add a node to an Oracle 11i System with Rapid Clone
    By Amit in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-03-2011, 04:49 PM
  5. Autoconfig fails Post Clone or after Host / Domain changes
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 10-30-2011, 02:51 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