Cloning in Oracle Apps 11i

Cloning is the act of creating an identical copy of an already existing Oracle Applications system.

Simply copying all of the components from source to target system does not provide us a working Oracle Applications system, there are various configuration files that must be changed & for this purpose we do Cloning.
     
Do keep in mind that the new system & the existing system must have same component versions & operating system type (You can’t clone from windows to linux or Solaris).

Performing Cloning prerequisites steps:

We need to perform certain prerequisites steps before cloning the source system:

STEP 1Login as Applications file user & run the environment file.

STEP 2 We need to check certain software component versions:

(i) Check the version of perl, it should be atleast 5.005 or above.
To check perl version, Type the following command-

$ perl -v

Make sure that perl is included in the PATH (environment variable of user; echo $PATH).

(ii)Check the version of JRE & JDK which should be atleast 1.1.8 & 1.3.1 or above respectively. for this type:

$ java -version

(iii) Check the version of zip which should be atleast 2.3 or above.for this type :

$ zip

If you don’t have following versions, upgrade these software components as per the operating system.

STEP 3: It is recommendedto apply the latest AD Minipack & the latest AutoConfig Template patch as mentioned in the metalink note 230672.1 but not necessary.

STEP 4:Then we check whether latest Rapid Clone patch is there or not, for this we query the database whether latest Rapid Clone patch and other prerequisite patches as mentioned in the metalink document 230672.1 as follows:

$ select * from AD_BUGS where bug_number=’&patch number’;

If it shows ” no rows selected ” that means you need to apply the patch. Do ensure that you apply all the patches as per the requirement.

STEP 5: If your system is autoconfig enable configure the application tier by running the adautocfg.sh script as follows:

$ cd $COMMON_TOP/admin/scripts/<$CONTEXT_NAME>/

$adautocfg.sh

If your system is not autoconfig enable then set up the autoconfig on application tier with the help of metalink document 165195.1 ( Migrating to AutoConfig on the Applications Tier).

NOTE:

  • To check whether your system is AutoConfig enable or not , open any configuration file, if you see the text “This file is automatically generated by AutoConfig….”at the top,this mean your system is autoconfig enabled.
  • Also all the applications after 11.5.7 are autoconfig enabled.

STEP 6:Now we set up AutoConfig on the database tier. For this we need to copy AutoConfig to the RDBMS ORACLE_HOME as follows:
• login as Applmgr . Set up the environment file & create appsutil.zip file in AD_TOP by typing the following command:
$ perl $AD_TOP/bin/admkappsutil.pl
This creates appsutil.zip in the $APPL_TOP/admin/out directory.
• Now login as Oracle on the database tier & copy the appsutil.zip file to the <RDBMS ORACLE_HOME> and unzip it:
$ cd <RDBMS ORACLE_HOME>
$ cp $APPL_TOP/admin/out/appsutil.zip
$ unzip -o appsutil.zip    (Option -o will overwrite any existing appsutil directory in database ORACLE_HOME)

Now run AutoConfig  on the database tier:

$ cd <RDBMS ORACLE_HOME>/appsutil/scripts/<context_name>/adautocfg.sh

Further steps for cloning oracle applications (cloning apps integrated with 10g AS) & finishing tasks coming in next post.

About the Author Atul Kumar

Leave a Comment:

11 comments
sasidhar says June 27, 2008

hi,
it is very good ,
where is your next post and how to find it,

thanks,
sasidhar

Reply
rajeshmanoharan says August 20, 2008

Hi,
I have some strange problem when I copy the ORA_TOP (prodora) files, it becomes double in size in the copied destination ex: prodora in production server 7.57GB and in the destination it becomes 16.36GB, it’s really strange to get double In size
And the backup was the cold backup
Please help me in this issue…

Thanks in advance,
Rajesh

Reply
Atul says August 20, 2008

This can be because of softlink in iAS or 806 directory in ORA_TOP

create tar file of ORA_TOP using

tar -cvf ora.tar ORA_TOP (source)

and extract it using tar -xvf ora.tar (target)

Reply
nathawan says August 21, 2008

Hi,

I’m not dba but i have to do apps dba ,
could u please explain to me how to run environment file on step1.

Thanks in advance.

Nath

Reply
Fahmi says November 19, 2008

To do Online Cloning without shutdown apps and db, please check this out :

http://levicorp.wordpress.com/2008/07/29/online-cloning-e-business-suite-without-shutdown-apps-db/

Reply
saikishore says February 16, 2009

Hi,
This post is interesting regarding cloning i will be waiting for ur’s further posts….

Thanks…

Reply
Akhter Sufi says April 22, 2009

Hi,
What are the places where I need to change the password in cloned environment specially in report server.

Regards,

Reply
Atul Kumar says April 22, 2009

If you are cloning using rapid clone , you don’t have to change password manually.

Autoconfig (part of rapid clone) automatically changes password at all required locations.

Atul

Reply
Akhter Sufi says April 22, 2009

Hi Atul,
If I use Rapid clone , I usually change the password in rapid clone logfile,wdbsvr.app and some custom file as it reflect production password in target system.

Regards,

Reply
Debasis says April 28, 2009

HI All,

This is Debasis here,i want to oracle aaps DBA
can you please help me out that what are the topis are there in oracle aaps DBA.so please help me out that what are the topis are in oracle Apps DBA.

Regards
Debasissss

Reply
gopal says August 17, 2009

Hi,

Its good, can you please tell us where we can find your next post.

regards

Reply
Add Your Reply

Not found