Wednesday, March 28, 2012

Oracle EBS R12 – Rapid Cloning

1.      Copy the source system (PROD) to the target (TEST) system

First, the full file system backup (The TAR files) of the Oracle EBS production system should be copied to the test server. Then TAR files should be extracted to the location/mount point where required space available.


2.      Recreate the Symbolic Links of the target (TEST) system

The symbolic links libclntsh.so.10.1 in [RDBMS ORACLE_HOME]/lib and [RDBMS ORACLE_HOME]/lib32 folders should be pointing to the file libclntsh.so in same folder. If the symbolic link libclntsh.so.10.1 NOT points to the correct path of the file libclntsh.so, the symbolic link libclntsh.so.10.1 should be deleted and recreated by using following commands.

[root@oracle lib]$ rm libclntsh.so.10.1

[root@oracle lib]$ ln -s [RDBMS ORACLE_HOME]/lib/libclntsh.so  libclntsh.so.10.1

[root@oracle lib32]$ rm libclntsh.so.10.1

[root@oracle lib32]$ ln -s [RDBMS ORACLE_HOME]/lib32/libclntsh.so  libclntsh.so.10.1

Note: If the symbolic links are pointing to the correct path please IGNORE this step.

3.      Create a new OS User, Set User Ownership and Permissions for the entire file system

A new OS user should be created on the test server and the user should be added to the dba group.

[root@oracle /]$ useradd -g dba -d /home/oracle -m oracle

Then the entire file system should be given the permission and ownership should be set for the above user.

[root@oracle TEST]$ chmod –R 777 apps inst db

[root@oracle TEST]$ chown –R oracle:dba apps inst db

4.      Configure(Clone) the target(TEST) system

After completing above steps, now the target file system is ready to configure (clone) as a new test system. First the TEST system database should be cloned and then the TEST system application should be cloned. These cloning commands should be executed through the new OS user created (ORACLE).

First move to the below path and execute the following command to start the Database Tier Cloning.

[oracle@oracle TEST]$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin

[oracle@oracle bin]$   perl adcfgclone.pl dbTier

*** Example [RDBMS ORACLE_HOME] would be /u01/finsys/db/tech_st/11.1.0.

Then move to the below path and execute the following command to start the Application Tier Cloning.

[oracle@oracle TEST]$ cd [COMMON_TOP]/clone/bin
[oracle@oracle bin]$   perl adcfgclone.pl appsTier

*** Example [COMMON_TOP] would be /u01/finsys/apps/apps_st/comn


Following metalink documents could be referenced to get more information on Oracle EBS R12 cloning.
Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]
Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 [ID 387859.1]
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported (Doc ID 1410514.1)

11 comments:

  1. Very nice information,Thanks

    Can you give me the tips..

    Pre clone steps
    Is our Source machine (e.g: proddb) will be UP (means Database & Application Tier should be start) ?

    Post Clone steps
    Is our Target machine (e.g: clonedb) will be UP (means Database & Application Tier should be start) ?

    Thanks

    ReplyDelete
  2. Pre clone step - We can execute the preclone for both source DB & Apps tier while both source DB & Apps tiers are up & running.

    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
    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 [INST_TOP]/admin/scripts
    $ perl adpreclone.pl appsTier

    Post clone step - Please refer the section 3 of cloning document Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]

    ReplyDelete
  3. Thank you for the valuble info I am going through the ID 406982.1.
    My requirement is I need to clone a staging database tier for apps environment from development database and this new staging server has nothing on it related to db, however the server is complete built for database usage which replicates the dev.
    In the mos doc I was stuck at a point in Section:2 Copy the source system to target system. last point
    b.4.Start the source Applications system database and application tier processes ....

    I am unable to understand how to do this as this is a new server and we have just copied the database files and oracle home,how can i start the database?

    ReplyDelete
    Replies
    1. As I understand, you have a Oracle EBS development database and it needs to be cloned to another server.

      The basics you can do is first execute the precloning as described above for both apps & DB tiers.

      Then you shutdown the Oracle EBS application & database and copy it to the server where you want to have a clone of Oracle EBS application & DB.

      Then you can execute the cloning for both DB & apps tiers and it will automatically startup the DB & application tier services.


      Delete
    2. b.4.Start the source Applications system database and application tier processes ....

      means that asking to start the database and the application processes of the source system ( the first server where you had the entire Oracle EBS file system ) after copying the file system to the other server.

      Hope you are clear now.

      Delete
    3. Thank you very much Sanjeewa, that cleared my question and I have one more issue, actually we have lot of changes in our development server which we don't want so we are taking an old backup of development server where we don't have all those changes and clone the new staging server with that old backup . SO in this case do we need to bring the source db up does it make any difference.. Because as the files are from old backup not existing dev(source) files.please let me know if need to follow different steps which are diff from mos doc 406982.1. Thanks a lot.

      Delete
    4. First you have to have the old Database up & running to execute the precloning scripts. Therefore it is a must you startup the old database and run preclone. Then shutdown the database and copy it to the other server and do the cloning in that server.

      Hope this helps.

      Delete
    5. Thank you Sanjeewa so i will bring up the old database and run the preclone and then as you said copy the files from old db..we don't need these files...we need the files of very old backup of the old database(this is a must) so is it ok to go with very old backup of the old database and follow the same process..is it going to work??

      thanks a lot.

      Delete
    6. Yes. Sure. You can clone any database tier file system by following this process. Yes. It should be working fine.

      Let me know if you get any errors during the process.

      Delete
    7. Thank you very much. Have a nice day Sanjeewa.

      Delete
  4. A very good blog with clear details for some one who is learning

    ReplyDelete