R12 Cloning onto a New Server/Machine.

R12 Environment cloning to a new box, thought will share my experience..Good if it's going to be useful to some one..

Objective  : Clone/Create an R12.1.3 Environment onto a new box.

Source: Linux 64 bit Servers.
ERP : 12.1.3
DB : 11g R2.

Target Version : Should be same as Source.

1. Complete installing the OS pre requisites as documented in the note:761566.1 [For any other OS, Please refer to 405565.1].


2. Setup your environment varaibles and PATH to the appropriate values.

3. Apply the required patches.

- 9171651

- 9833058

- 12404574 - has a prerequisite patch - 9171651.

- 12598630.

These were the patches required in our environment, please complete a careful analysis before concluding the patch list.

3. Auto config on DB Tier and Apps Tier was completed earlier and were not required in our case.

4. Updated Current view snapshot (Complete APPL_TOP).

5. Prepare the source system for cloning.

5a. $ORACLE_HOME/appsutil/scripts/[CONTEXT_NAME]

perl adpreclone.pl dbTier

5b. $INST_TOP/admin/scripts

perl adpreclone.pl appsTier

6. Copy the application tier.
- Copy APPL_TOP
- COMMON_TOP
- Apps Tech stack
-  ORACLE_HOME
- IAS_ORACLE_HOME

In our environment, I created the tarzip of the root folder like /u01/app/R12... completely and then copied them over to the target.
at the target instance after  untaring the required files, the directory structure was layed and all that I had to do was to change the permissions and rename the INST-TOP directory

Note: INST_TOP directory  is not required to be copied from PROD as this directory will be created during cloning.

Configure the target system.

-On the Database tier, log on to $ORACLE_HOME/appsutil/clone/bin perl ./adcfgclone.pl dbTier Provided below are some of the options that you would be prompted with. Copyright (c) 2002 Oracle Corporation                         Redwood Shores, California, USA                           Oracle Applications Rapid Clone                                      Version 12.0.0                         adcfgclone Version 120.31.12010000.8 Enter the APPS password : Running:......... perl adcfgclone.pl dbTier Log file located at <CloneContext_1125160841>.log Provide the values required for creation of the new Database Context file. Target System Hostname (virtual or normal) [machine_name] : Target Instance is RAC (y/n) [n] : Target System Database SID : TEST Target System Base Directory : /u01/oracle Target System utl_file_dir Directory List : /usr/tmp Number of DATA_TOP's on the Target System [1] : Target System DATA_TOP Directory 1 [/u01/app/SRC1/srcdata] : /u01/app/test/data Target System RDBMS ORACLE_HOME Directory [/u01/oracle/db/tech_st/11.1.0] : <targe_O_H> location. Do you want to preserve the Display [87.0] (y/n)  : n Target System Display [machine1:0.0] : machine:1.0 Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n  Target System Port Pool [0-99] : 6 Checking the port pool 6 done: Port Pool 6 is free Report file located at ....../portpool.lst Complete port information available at ......./portpool.lst

On the Application tier as appltest user

$COMMON_TOP/clone/bin perl adcfgclone.pl appsTier Provided below are some of the options that you would be prompted with. perl adcfgclone.pl appsTier prompt entries. Log file located at <CloneContext_1126140313>.log Provide the values required for creation of the new APPL_TOP Context file. Target System Hostname (virtual or normal) [machine1] : Target System Database SID : TEST Target System Database Server Node [machine] : Target System Database Domain Name [domain.com] : Target System Base Directory : /u01/oracle Target System Tools ORACLE_HOME Directory [/u01/oracle/apps/tech_st/10.1.2] : /u01/oracle/TEST/apps/tech_st/10.1.2 Target System Web ORACLE_HOME Directory [/u01/oracle/apps/tech_st/10.1.3] : /u01/oracle/TEST/apps/tech_st/10.1.3 Target System APPL_TOP Directory [/u01/oracle/apps/apps_st/appl] : /u01/oracle/TEST/apps/apps_st/appl Target System COMMON_TOP Directory [/u01/oracle/apps/apps_st/comn] : /u01/oracle/TEST/apps/apps_st/comn Target System Instance Home Directory [/u01/oracle/inst] : /u01/oracle/TEST/inst Target System Root Service [enabled] : Target System Web Entry Point Services [enabled] : Target System Web Application Services [enabled] : Target System Batch Processing Services [enabled] : Target System Other Services [disabled] : Do you want to preserve the Display [machine:0.0] (y/n)  : n Target System Display [machine-ebs-test:0.0] : machine:1.0 Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n Target System Port Pool [0-99] : 6 Checking the port pool 6 done: Port Pool 6 is free Report file located at ............./portpool.lst Complete port information available at ............../portpool.lst UTL_FILE_DIR on database tier consists of the following directories. 1. /usr/tmp 2. /usr/tmp 3. /u01/oracle/TEST/db/tech_st/11.2.0/appsutil/outbound/TEST_machine-ebs-test 4. /usr/tmp Choose a value which will be set as APPLPTMP value on the target node [1] : 1 Do you want to reset custom variable settings(y/n) [n] :

after the adfgclone.pl completes,  do the following to set the environment in your new server.
- Source the below environment file in the profile file with complete path.
./u01.../../APPSTEST_machine-ebs-test.env
Also set the environment file at the dbTier. 

Post Configuration steps,

1. Updating profile options.

2. Enabling/Disabling Responsibilities

3. Configuring workflow (please be very careful to set the email override address as appropriate, before enabling the workflow services)

4. Other environment specific configurations like enabling OID/SSO, Directory patchs etc.

Cloning process is very much similar to earlier 11i version, except that the $INST_TOP needs some attention until we get used to this type cloning.

Errors/Solutions.

------->

Error 
The report format is:
      <filename>  <phase>  <return code where appropriate>


  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory:................../db/tech_st/11.2.0/perl/lib/5.8.3 -I /u01/oracle/ECDEV/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3 -I ........................................................../db/tech_st/11.2.0/appsutil/clone
      ouicli.pl               INSTE8_APPLY       255
AutoConfig is exiting with status 1
---->Solution : perl issue.
PATH = /u01/oracle/TEST/db/tech_st/11.2.0/bin/:/usr/kerberos/bin:/usr/local/bin:/home/oraecdev/bin:/home/oraecdev/bin
set the ORACLE_HOME/bin/perl initially at the PATH for this to succeed.

Happy Reading/Sharing folks.

RELATED POSTS::

E-business suite Autoconfig and instance customization.

RMAN Errors during DUPLICATE/Clone database.