Oracle Applications 11i Hot Backup Cloning with Rapid Clone

We are getting lot of questions on Hot Backup Cloning of 11i in the forum. So we thought that, if we write one article regarding this, it will be more useful for the apps newbies. Here I am sharing the information that, what i follow during the hotbackup cloning. You all might have done this before.

   Source System (PROD): 

       (a)   P4 3.0 GHz System with 2GB RAM and 200 GB HDD (Redhat Linux AS 4)      

                              /d01 ——- 40 GB (Application Tier Files)       

                              /d02 ——- 10 GB (10g Oracle Home)          

                             /d03 ——- 80 GB (Data Files)             

                             /backup —- 100 GB (NFS mount point Shared on TEST Server)         

    Hostname: prodserver           

    Application Version: 11.5.10.2      

   Database Version: 10.2.0.2 Target System (TEST):

        (b)  P4 2.6 GHz system with 1.5 GB RAM with 300 GB HDD (Redhat Linux AS 4)           

                              /d01 ——- 40 GB (Application Tier Files)            

                              /d02 ——- 10 GB (10g Oracle Home)            

                              /d03 ——- 80 GB (Data Files)            

                              /backup —- 100GB (NFS Share Directory)        

     Hostname: testserver         

     Application Version: 11.5.10.2         

     Database Version: 10.2.0.2 

Note: This target System was previously cloned with cold backup. This is second time cloning with Hot Backup from PRODSERVER.   

Stage1: Prerequisites: 

 ========> Apply OUI22 Patch, 5035661 to every IAS Oracle Home
          and RDBMS Oracle Home to be cloned. 
          If you are having 10g Oracle Home,
          there is no need of applying this patch. 
          You need to apply this patch on IAS Oracle Home 
         (if Database is not 10g)

       A. Applying the patch on the iAS $ORACLE_HOME:

   ====================================================
   (a)  Unzip the patch into the <iAS ORACLE_HOME> directory:
       $unzip -od /d01/prodora/iAS p5035661_11i_LINUX.zip
   (b)   Source the Apps environment file :
         $. $APPL_TOP/APPSORA.env
   (c)   Change directory to the <IAS ORACLE_HOME>/appsoui/setup
        $cd $IAS_ORACLE_HOME/appsoui/setup
   (d)  Execute the perl script OUIsetup.pl:
       $perl OUIsetup.pl
  NOTE:
  In the case of a Multi-Node instance, the above process
  should be repeated on the <iAS ORACLE_HOME> of each Node.
(B) Applying the patch on the RDBMS $ORACLE_HOME: 
     (This step is not required for my current setup, 
    because my database version is 10g R2)
  (a)  Unzip the patch into the <RDBMS ORACLE_HOME> directory:
       $unzip -od /u01/proddb/9.2.0 p5035661_11i_LINUX.zip
  (b)  Source the DB environment file :
       $. $ORACLE_HOME/PROD_prodserver.env
  (c) Change directory to the <RDBMS ORACLE_HOME>/appsoui/setup
      $cd $ORACLE_HOME/appsoui/setup
  (d) Execute the perl script OUIsetup.pl:
      $perl OUIsetup.pl
======> Check all other Requirements as Perl, JRE, JDK, ZIP utilities on Source and Target Nodes as per
        document "Cloning Oracle Applications Release 11i with Rapid Clone"
=======> Apply the Latest AD Minipack on Application Tier (Latest One is AD.I.5)
=======è Apply the Latest Autoconfig Template Patch and Latest Rapidclone Patches to Application Tier (Check Metalink for These Patches)
Stage2: Prepare the Source System (PRODSERVER)
      (a) Login into Database Tier as ORACLE user and run the preclone
           $cd $ORACLE_HOME/appsutil/scripts/PROD_prodserver
           $perl adpreclone.pl dbTier
      (b) Login into the Application Tier as APPLMGR User and run the  preclone
           $cd $COMMON_TOP/admin/scripts/PROD_prodserver
           $perl adpreclone.pl appsTier
Stage3: Put the Database in Begin Backup Mode and copy the Database Files 
       (a)   Login into database as sysdba user
             $sqlplus "/as sysdba"
             Sql> alter database begin backup;
       (b)   Copy Archive log files created during hot backup to /backup directory.
       (c)   Copy the All Data files to /backup directory.
       (d)   Backup the control file to trace.
             Sql> alter database backup control file to trace;
             Copy this trace file to /backup directory
       (e)   Copy the current init.ora file to /backup directory
       (f)   End the Begin Backup Mode.
             Sql> alter database end backup.
 Stage4: Copy the Application Tier File System Files
         (a)Login into the Application Tier as APPLMGR user and copy the APPL_TOP, COMMON_TOP, 
             IAS ORACLE HOME and 8.0.6 Oracle Home to /backup directory
 Stage5: Copy the Source Database files and Application Files to Target server
     Copy the parameter file, backup control file and archive log files from /backup directory  
          to /d01, /d02 and /d03 in target server.
 Stage 6: Configure the Target Database (TESTSERVER)

              Log on to the target system as the ORACLE user 

                           (1)     Configure the <RDBMS ORACLE_HOME>    

                                     cd <RDBMS ORACLE_HOME>/appsutil/clone/bin    

                                      perl adcfgclone.pl dbTechStack              

                           (2)     Create the target database control file manually                                

                                     Open the backed up control file                          

                                       a. remove all lines before the startup nomount statement        

                                       b. Modify the REUSE to SET                         

                                       c. Modify Source DB SID to Target SID (Here PROD to TEST)  

                                        d. Modify NORESETLOGS TO RESETLOGS                         

                                        e. delete all lines after the CHARACTER SET statement

————————————           

                                   CREATE CONTROLFILE SET DATABASE “TEST” NORESETLOGS  ARCHIVELOG…

LOGFILEGROUP 1

              ‘/d03/log01.log’ SIZE 50M,

               …

DATAFILE

              ‘/d03/system01.dbf’,

              ‘/d03/undotbs01.dbf’,

    …

CHARACTER SET UTF8; 

—————————————————–

            On the target system, modify the init.ora to have the target SID and location of the control file and also make sure that init.ora parameters are set for archive log mode On the target system,

        starup the database in nomount stage

       sql> startup nomount pfile=< Target init.ora path>

       sql> @clone.ctl         ( here clone.ctl is the control file which we have modified above)

     Once control file is created, database will be in mount stage

             execute recover command using backup control file after the database is mounted 

                 SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; 

 After the last archive log has been applied, issue the following command  

                   SQL> alter database open resetlogs;      

 After opening the database, add temp files to target database  

      (3) 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. 

         (4)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

    Stage 7 :  Configure the Target Application Tier              

                     Logon to the target system as the APPLMGR user and type the following commands          

                        $Cd $COMMON_TOP/clone/bin       

                        $Perl adcfgclone.pl appsTier  

     Finishing tasks:

                   (1)     Update Profile options

                   (2)     Update Printer Settings

                   (3)     Update the workflow configuration settings

                   (4)     Verify the APPLCSF variable setting

                   (5)     Update the session_cookie_domain value in icx_parameters 

For the finishing tasks, check the finishing tasks section of the following document

 Cloning Oracle Applications Release 11i with rapid clone Note: 230672.1         

About the Author AppsDBA

Leave a Comment:

76 comments
Vasanth says March 31, 2008

Hi Subbu,

Its a good post .What is the significance of applying OUI22 Patch, 5035661 to every IAS Oracle Home and running perl OUIsetup.pl ?

Reply
SubbaRao says March 31, 2008

Hi vasanth,

Thanks,

OUI22 Patch is the prerequisite, if you want to clone using rapid clone. You have to upgrade the Oracle Universal Installer to Version 2. If you dont, you will get errors while running preclone on source system(while creating stage area for clone).

For more, please check the following note

perl adpreclone.pl dbTier returns “RC-00012: Error while creating cloning stage area” Note:392887.1

Regards,
SubbaRao

Reply
Vasanth says March 31, 2008

Thanks .

Reply
raghu says April 12, 2008

hey it s very nice Vasanth

Reply
Subbarao says April 13, 2008

What nice raghu,

Regards,
SubbaRao

Reply
Reddy says April 17, 2008

Hi,

Please can any body tell me , how to do a cloning without running adpreclone script in source system.

Thanks,
reddy

Reply
SubbaRao says April 18, 2008

Hi Reddy,

As far as I know, if you are doing cloning with rapid clone, for first time, if you are doing cloning to target system. It’s must to run the preclone in the source system.

Thanks,
SubbaRao

Reply
Reddy says April 18, 2008

Hi SubbaRao,

Thanks,
Reddy

Reply
SubbaRao says April 19, 2008

Always welcome my friend,

Regards,
SubbaRao

Reply
virendra patel says May 9, 2008

Hi Subba,
This is an excellent article…..thank you very much for your efforts and keep up the good work…
thanks,
Virendra Patel

Reply
SubbaRao says May 10, 2008

Hi Virendra,

Thank you,

I really appreciate your words,

Regards,
SubbaRao

Reply
Anony says May 21, 2008

Good one , I tried this and it worked perfectly. Thanks for posting this.

Reply
SubbaRao says May 21, 2008

Hi Anony,

Thanks.

Always welcome my friend.

Regards,
SubbaRao

Reply
Reddy says May 24, 2008

Hi,

Please can anyone give me the syllabus for Oracle 10g OCP and procedure to do.

Thanks,
Reddy

Reply
Lilian says June 6, 2008

Hello SubbaRao,

Could you tell me how you copy all the files from source machine to the target machine? I’ve tried wget, but it didn’t work.

Thank you in advance.

Best regards,
Lilian

Reply
SubbaRao says June 7, 2008

Hi Lilian,

==========================
take backup using tar in source system and copy the tar files to target machine.

for example, if /u05 is the application partition, as a root user take tar backup

#tar -cvf /backup/u05.tar /u05

copy the u05.tar to target machine using ftp or sftp and extract the files

#cd /u05

#tar -xvf /backup/u05.tar

=====================
apart from tar, you can also try the rsync command,if rsync is installed

===> NFS mount the source partion to target machine

# mount -f nfs source_system:/u05 /target_mount

#rsync -avz /target_mount /u05
================================

You can also use cpio with find

NFS mount /u05 of source system to /target_mount point

#mount -f nfs source_system:/u05 /target_mount

#cd /target_mount

#find . -print | cpio -pmdV /u05

========================

Hope it helps,

Good Luck,

Regards,
Subbarao

Reply
Lilian says June 9, 2008

Hello Subbarao,

It’s very kind of you to have replied me so quickly.
Thank you very much.

Best regards,
Lilian

Reply
SubbaRao says June 10, 2008

Always welcome my friend,

Regards,
Subbu

Reply
Bobby says June 29, 2008

Hi

Can you please explain finishing task:

(2) Update Printer Settings

and another thing what all changes are required if I am not using standard ports

Thanks

Reply
hoffy says July 28, 2008

Hi,

Thanks much for the great write up. Helped immensly.

I’m running into one issue. When trying to launch forms from the Self Service Page i get an error.

Bad Request.
Your browser sent a request the server can not understand.

Any suggestions would be great!
Thanks

Reply
Autil says September 8, 2008

Hi,

is it possible to view the concurrent manager log/output files(in target system) from source after being cloned to target?

Reply
Atul says September 8, 2008

Yes, copy log & out files to target instance from source and update table FND_CONCURRENT_REQUESTS for column values LOGFILE_NAME & OUTFILE_NAME to new location.

Check metalink note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

Under Section 3 in finishing tasks “Update workflow configuration settings”

Reply
badiuddin says September 9, 2008

hi subbu,
Very nice post.
Can u please explain me where i can get information or logs related to :

In Oracle Apps 11i

1.When we submit URL request in browser to access the front-end of applications…
What exactly happens in the background…say which template or php from which location is first called…ie

i)self serviced applications
ii)web applications
iii)mobile applications..

What are all the files/process involved in getting the front-end till we get the login page..

Please help me with above…
I am really confused..

Reply
Atul says September 9, 2008

Check this for overview

for list of files/directories involved stay tunes to this post

http://onlineappsdba.com/index.php/2006/08/01/oracle-applications-request-flow

Reply
badiuddin says September 9, 2008

Thanks Atul,
Your post is really helpful..
Could u please further give logfile location
of the actions involved in these processes..

Reply
Balamurugan says September 17, 2008

Hi Rao,

Nice docuemnt…Actually i want to clone/restore production instance database to Test instance database.

We are taking RMAN backup daily…Can you tell me without shutting down the produciton instance how i can clone prod database to test database.

thanks

Regards
Bala

Reply
moses says November 5, 2008

Hi Subbu,

Are you missing the step to copy RDBMS ORACLE HOME from prodserver to testserver?

Moses

Reply
SubbaRao says November 5, 2008

Hi moses,

In Stage 5,I mentioned to copy the Oracle Home to target /d02 Partition ( Target Server).

Regards,
SubbaRao

Reply
muneer says November 6, 2008

hi, thanks for such a nice article.

I have a question.

Suppose I have followed all the steps you mentioned in this article and set up the test system.

Now, one week later, I want to update my test system with the changes which took place in the production. My question is regarding the cloning of DB tier. Do I need to copy the entire system everytime(i.e. Oracle Home and the DBFs) or is it sufficient to copy the modified DBFs and new archive logs from production. Could you please explain how do i update my test system with the changes from production.

Thanks,

Reply
SubbaRao says November 6, 2008

Hi,

If you did not apply any database patches and Application patches in Production after first cloning, then you can just copy the All Database Files and Archive logs to target system and create the controlfile as specified above.

Regards,
SubbaRao

Reply
sp says December 3, 2008

Hi Subba,

Do you have this document for windows ? I am planning to clone apps/db to test servers. Test servers already have a clonned copy but its very old. what is the best method to clone in this situation. I am doing this for the first time also the prod has millions of records. Do I need to have oracle installed on target systems

Reply
SubbaRao says December 3, 2008

Hi SP,

You no need to install oracle in target system. If you have hot backup of Production, just follow the above procedure or if you have Cold Backup of Production, please follow the given document, it is very easy to understand.

Cloning Oracle Applications Release 11i with rapid clone Note: 230672.1

If you have any doubts, post here, we will help you.

Regards,
SubbaRao

Reply
akshay says December 26, 2008

Hi subbarao/Atul,

i am doing cloning with the help of this document .
but here is nothing related with ORACLE_HOME.
should we copy RDBMS ORACLE HOME from source to copy or there is no need. adcfgclone will automatically create this?

please reply back asap.
waiting for your reply

thanx in advance
akshay

Reply
SubbaRao says December 29, 2008

Hi Akshay,

If you are first time doing the Cloning in target system. You need to copy RDBMS ORACLE_HOME to Target System. Cfgclone will not create target oracle home.

If targe RDBMS oracle home is already there and you did not apply database patches, then no need to copy the RDBMS oracle home.

If you still don’t understand, please let me know.

Hope it helps,

Good Luck,

Regards,
SubbaRao

Reply
akshay says January 9, 2009

Hi subbarao/Atul,

Thanks for reply.
I was able to do with this document.

Now i have to write a script for autometed cloning.
But i am not able to understand from where i should start, if you gone through this type of scenerio previously then please help to write a shell script.

i have never done the shell script before.

waiting for your reply.

Thanks and regards,

akshay

Reply
sandeep.urs@gmail.com says January 23, 2009

Hello Buddy,
Thanks a lot, it’s really a good document. I learnt a new thing. Thanks again.

Regards,
Sandeep

Reply
SubbaRao says January 23, 2009

Hi Sandeep,

always welcome my friend.

Regards,
SubbaRao

Reply
ramachandramurthyv says February 24, 2009

Dear Mr.Subbarao,

Can i get steps for automated cloning.
If possible some scheduling of cloning in R12
12.0.5
on HP-unix platform
and from multi node to single node

Reply
Arun says April 6, 2009

Hi friends,

i have a doubt on Step 6(Point 4):

perl adcfgclone.pl dbconfig

whether we need to create target context file?i believe the adcfgclone script only creates context file in normal cloning.so here the target context file referred is already created or we need to create?

Reply
SubbaRao says April 6, 2009

Hi Arun,

The command
perl adcfgclone.pl dbTechStack will create target context file based on the information you provided.

once this command is finised, you will have target contxt file created

to the below command, you have to provide the target context file created above

perl adconfig.pl dbconfig will update the database tables with the information of context file.

Hope it is clear.

Regards,
Subbarao

Reply
Arun says April 6, 2009

Dear SubbaRao,

Thanks for the information.By the way what is the Metalink doc ID for this Hotbackup Cloning.

Thanks and Regards,
Arun

Reply
SubbaRao says April 6, 2009

Hi,

please refer the Appendix B of the below metalink document. ( Last One)

Cloning Oracle Applications Release 11i with Rapid Clone Doc ID: 230672.1

Today I have seen one document, it might be helpful.

Cloning Oracle Application 11i /R12 with Rapid Clone – Database (9i/10g/11g) Using Hot Backup on Open Database Doc ID: 760772.1

Good Luck,

Regards,
Subbarao

Reply
Zee says April 9, 2009

HI,
I need to do rman clonning from ASM to non asm instance as my PROD DB is running on ASM on r12 and the test , dev environments are on non ASM.

kindly can you tell me the steps for that

Reply
Zee says April 10, 2009

HI,
I have 2 node application r12 db is running on ASM and the backup is taken by RMAN can u tell the steps for doing clonning

Reply
gauravgandhi4all says June 4, 2009

Dear Subba,

Very nice artical.

Please tell me if I want to keep my Target system uptodate with source system on daily basis, what should I do further?

My data changes made in source system should be applied in target system.

Please suggest.

Regards,
Gaurav

Reply
sow says July 11, 2009

Hi,

Can you pl provide release 12 architecture

Reg

Sowmy

Reply
ranjani says September 14, 2009

hi i need the difference between rman backup vs physical backup vs logical backup

Reply
Atul Kumar says September 15, 2009

@ Ranjani

Backups are divided into physical backups and logical backups.

1. Physical Backups are copies of physical database files (data files, control file, redologs) using operating system utility like cp, copy or oracle utility like RMAN

2. Logical backups contain logical data (tables, packages, stored procedure) that is exported using SQL commands and stored in a binary file using utility like import/export.

RMAN (Recovery Manager) is Oracle Tool/Utility for Physical Backup

Reply
ranjani says September 15, 2009

hi friends ! i need rman backup and recovery concepts with screen shot … plz send it to my mail id

Reply
gauravgandhi4all says September 16, 2009

Dear Ranjani,

Please provide me E-mail id.
I will share RMAN docs which I have.

Reply
suresh kumar says December 13, 2009

Hi subbarao garu,

very nice article, i learnt so mant things from this and doc id’s.

Thanks a lot sir.

Reply
Hussain says January 7, 2010

Please could have detail of cloning apps 11i on windows server environment..

thanks advance
hussain

Reply
SailaSudha says February 5, 2010

Hi,

Please Help me….
We have PROD and UAT of 11i on windows 2003. Earlier UAT is cloned with PROD. Whenever any patch needs to be applied I am applying on both UAT and PROD. To reflect UAT with latest PROD, DBA is taking the COLD Backup and renaming the instance to UAT. Later applying adcfgClone on UAT for dbTier and appsTier. AutoConfig. This went on well 2 times. Everything worked out good.
Recently we did the same step but mistake is DB files not placed in the correct directory and unfortuantely we executed adcfgclone on dbtier and appsTier. Later we placed the DB files correctly and we executed adcfgclone on dbtier and appsTier. AutoConfig also. This time All are working fine but transaction Manager like ‘Po Document Approval Manager’ and Receiving Transaction Manager are not getting started. The error is
‘Transaction Manger could not create Pipes’.
Then I raised Oracle TAr and they suggested me to do cloning again but appsTier will do.

Now comes the main problem, as I am doing this first time cloning and luckily it is from PROD to UAT, I want to explore this oppurtunity. So started. I succesfully ran adpreclone on appsTier on two nodes(appsTier on two nodes on PROD). Now my big question is in Metalink notes they metnioned some directories. Is it Ok to copy entire APPL_TOP, COMMON_TOP from PROD to replace APPL_TOP,COMMON_TOP in UAT. And Other folder when I observed for OA_JRE_TOP..pointed to d:\oracle\prodcomn\util\java\1.4\j2sdk1.4.2_04.. but there is no folder availabe with 1.4\j2sdk1.4.2_04. So how to check this? What is the normal methodology in copying so much big files and replacing them on UAT?

Those who are reading till this point, I would like to thank you first for your patience and please help me with your hints.

As it is urgent, Kindly take some time to update on this asap and I will be really thankful to you people.

Regards
Sudha

Reply
Atul Kumar says February 5, 2010

@ Sudha,
Where yousee OA_JRE_TOP location pointing to d:\oracle\prodcomn\util\java\1.4\j2sdk1.4.2_04 (Is this in context file and if yes which context file , for UAT or Prod) ?

If you are not sure go to $APPL_TOP/$SID_hostname.xml and look for value OA_JRE_TOP

For copying on wondows simply copy+paste in windows .

Reply
SailaSudha says February 5, 2010

Hi Atul,

In the XML File it is mentioned as like this. d:\oracle\uatcomn\util\java\1.4\j2sdk1.4.2_04. The Folder is there. Thanks for pointing out.
I observed it wrongly as I didn’t query the latest record of this variable_name in fnd_env_context.

Please Answer.. Can I exactly copy all the APPL_TOP,COMMON_TOP,806_oracle_home, IAS Oracle_HOME from prod to UAT on both appsTier nodes?

Regards
Sudha

Reply
Atul Kumar says February 5, 2010

@ Sudha,
Yes can exactly copy from Prod to Test (Database should either be in hotbackup mode or down)

Reply
aman says February 19, 2010

Hi,

As per the above note, we didn’t shut down the apps services before copying the application tier.

Please let me know if it’s not mandatory ?

Thanks,
Aman

Reply
New Hampshire DBA says May 12, 2010

Great tutorial SubbaRao, thanks.
I was wondering if you had steps for creating a new ORACLE DB & EBS instance from a hot backup copy of PROD?
We have a clean box that we’d like to use as a sandbox, but were unsure of how to create a new instance from hot backup copy.

PRD has 2 servers, 1 apps, 1 db, new instance would be DB & APPS on same box. Thank you! Bob

Reply
wisnu says May 17, 2010

Hi Subba,

It is a great tutorial.

Is it work on version 11.5.9 ???

Regards,

Wisnu

Reply
Anjul says August 9, 2010

Hi,

Thanks for the article.

I am facing an issue at step where your are running following command –
perl adcfgclone.pl dbconfig

Any idea what could be the reason? I checked the file adcrdb.sh is present and has 700 permission. It is solaris machine.

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:

[INSTANTIATE PHASE]
AutoConfig could not successfully instantiate the following files:
Directory: /ora/product/10.2.0/db_1/appsutil/install/OIC4SI_au10qap2k0tels2
adcrdb.sh INSTE8

AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDatabase
XXXXX:OIC4SI>ls -lrt /ora/product/10.2.0/db_1/appsutil/install/OIC4SI_XXXXX | grep adcrdb
-rwx—— 1 oracle dba 4198 Aug 6 00:27 adcrdb.sh
-rwx—— 1 oracle dba 2721 Aug 9 19:51 adcrdbrdlg.sh

Reply
Atul Kumar says August 10, 2010

@ Anjul,

open adcrdb.sh file under
/ora/product/10.2.0/db_1/appsutil/install/OIC4SI_au10qap2k0tels2

Search for log and check log file in that location to see why adcrdb.sh failed ?

This command creates DB so check alert log of database in target instance.

Reply
Anjul says August 10, 2010

@Atul,

Thanks. The error was
– could not instantiate because of missing adcrdb.sh in template dir. Even if copy the file from some other instance, it was failing. Some process was removing template/adcrdb.sh file, not sure which one.

After lots of tries, I created the database manually.

Reply
Muthu says April 18, 2011

Hi,
i want to clone R12.1.1 any prereq is there please give your suggestion .

Regards,
Muthu

Reply
Atul Kumar says April 18, 2011

@ Muthu,
For prereq steps, please follow metalink (Oracle My Support) note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone

Reply
krunal says April 29, 2011

Is there any way to automate cloning procedure as in like writing shell scripts

Reply
Ravi Kumar says June 27, 2011

New to apps dba one small doubt on hot backup cloning, Don’t we need to copy the RDBMS home to the target server

Thanks,
Ravi Kumar

Reply
Subbu says June 28, 2011

Hi Ravi,

If the patch levels are same at source and target, then no need of copying oracle home.

For Suppose, If you did not apply any patches in Source Oracle Home since last Clone (Where you have copied Oracle Home and did the clone), then, this time Copying Oracle Home is not required.

Please let me know, if you still have the doubts..

Thanks,
Subbu

Reply
Atul Kumar says June 28, 2011

@ Ravi Kumar,
As Subbu said, no if you already have Oracle Home in target location with same patchset as source database.

Yes, if you don’t have Oracle Home on target instance or patchset are different on source and target.

Reply
Ravi Kumar says June 29, 2011

Thanks Subbu and Atul for clearing my doubt

Thanks,
Ravi

Reply
Babajan Khan says August 23, 2011

It’s very nice artical Subbu

Reply
Baqar says January 11, 2012

Dear Rao,

Thanks for sharing the such good information.
Kindly send me the document of Oracle 11i/R12 Apps installation and configuration document it will be appriciate.Since i’m new to ORACLE APPS.

Reply
Atul Kumar says January 11, 2012

@ Baqar,
To install R12 use installation guide from

http://docs.oracle.com/cd/B53825_08/current/html/docset.html “Oracle E-Business Suite Installation Guide: Using Rapid Install”

To install 11i use installation Guide from http://docs.oracle.com/cd/B25516_18/current/html/docset.html

“Technology Maintenance Oracle Applications Installation Guide: Using Rapid Install “

Reply
rekha08.mahi@gmail.com says October 9, 2012

how to perform the post cloning activities, please help me

(1)Update Profile options

(2)Update Printer Settings

(3)Update the workflow configuration settings

(4)Verify the APPLCSF variable setting

(5)Update the session_cookie_domain value in icx_parameters

Reply
rekha08.mahi@gmail.com says October 9, 2012

how to perform post cloning operations

(1)Update Profile options

(2)Update Printer Settings

(3)Update the workflow configuration settings

(4)Verify the APPLCSF variable setting

(5)Update the session_cookie_domain value in icx_parameters

Reply
varma says January 25, 2013

Please provide the info for below steps this would be very helpful for us

how to perform post cloning operations

(1)Update Profile options

(2)Update Printer Settings

(3)Update the workflow configuration settings

(4)Verify the APPLCSF variable setting

(5)Update the session_cookie_domain value in icx_parameters

Reply
Add Your Reply