Oracle Blogs

Cloning Oracle Applications Release 12 with Rapid Clone

Section 1: Prerequisites (First time only)

  1. Run AutoConfig on the Application Tiers

Run AutoConfig on all application tier nodes. Use the adautocfg.sh command. All scripts listed below are located in <INST_TOP>/admin/scripts.

Platform Functionality Command
UNIX Start Applications services adstrtal.sh
Stop Applications services adstpall.sh
Run AutoConfig adautocfg.sh

Attention: The database server and the database listener must remain available during the AutoConfig run. Only the application tier servers should be shut down.

Note: Running AutoConfig may change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities, in order to apply the changed environment variables.

  1. Synchronize appsutil on the Database Tier Nodes

Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following steps:

  • On the application tier (as the APPLMGR user):

o   Log in to the APPL_TOP environment (source the environment file)

o   Create appsutil.zip file

perl <AD_TOP>/bin/admkappsutil.pl

o   This will create appsutil.zip in <INST_TOP>/admin/out

  • On the database tier (as the ORACLE user):

o   Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>

o   cd <RDBMS ORACLE_HOME>

o   unzip -o appsutil.zip

  1. Run AutoConfig on the Database Tier

Run AutoConfig on the database tier nodes. Use the adautocfg.sh/.cmd command. All the scripts listed below are located in

<RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>.

Platform Functionality Command
UNIX Start database listener process addlnctl.sh start <SID>
Start database process addbctl.sh start
Stop database listener process addlnctl.sh stop <SID>
Stop database process addbctl.sh stop
Run AutoConfig adautocfg.sh

Attention: The database server and the database listener must remain available during the AutoConfig run. All the other database tier services should be shut down.

Note: Running AutoConfig may change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities, in order to apply the changed environment variables.

  1. Maintain Snapshot information

Log in to each Applications Node as the APPLMGR user, and run “Maintain Snapshot information” in AD Administration (adadmin).

Run adadmin à Select option 2 à Select option 5 à Select option 2 à Select option 1

Section 2: Clone Oracle Applications Release 12

There are three phases to the cloning process:

  1. Prepare the Source System
    Execute the following commands to prepare the source system for cloning.
  2. Prepare the source system database node 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

NOTE:

First set the environment variable

. /oracle/db/tech_st/10.2.0/PROD_devdb.env

Then

cd $ORACLE_HOME/appsutil/scripts/PROD_devapps/

perl adpreclone.pl dbTier

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

NOTE:

First set the environment variable

. /oracle/apps/apps_st/appl/PROD_devapps.env

Then

cd $INST_TOP/admin/scripts
perl adpreclone.pl appsTier

  1. 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 node files are owned by the target ORACLE user.
  2. Copy the application tier file system
    Log on to the source system application tier nodes as the APPLMGR user.
  •   Shut down the application tier server processes
  •   Copy the following application tier directories from the source node to the target application tier node:
  • <APPL_TOP>
  • <COMMON_TOP>
  • Tech Stack

Note: Restore the backup of source Apps on target Apps.

  1. Copy the database node file system
    Log on to the source system database node as the ORACLE user, and then:
  • Perform a normal shutdown of the source system database
  • Copy the database (DBF) files from the source to the target system
  • Copy the source database ORACLE_HOME to the target system
  •    Start the source Applications system database and application tier processes

Note: Copy and Restore the backup of source DB on target DB.

From source system e.g., PRODDB:

 scp 01_BACKUP_PRODDB.tar.gz oracle@172.16.35.9:/oracle/01_BACKUP_PRODDB.tar.gz

From target system e.g., DEVDB

tar -xzf /oracle/01_BACKUP_PRODAPPS.tar.gz

Same for APPS node.

  1. 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.)

    1. Configure the target system database server
      Log on to the target system as the ORACLE user and enter the following commands to configure and start the database:
      cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
      perl adcfgclone.pl dbTier

NOTE:

[oracle@testdb ~]$ cd $ORACLE_HOME

[oracle@testdb ~]$ cd appsutil/clone/bin

[oracle@testdb ~]$ perl adcfgclone.pl dbTier

Enter the APPS user password: apps

Enter the APPS password: apps

Provide the values required for creation of the new Database Context file.

Target hostname (virtual or normal) [testdb]:                         –enter target db hostname)

Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:        –if no RAC then press enter

Target System database name: PROD                                    –enter your SID name

Target system base directory for source homes:/oracle           –enter base directory of your apps installation

Target system utl_file accessible directories list: /usr/tmp      — enter utl_file directories seperated by space

Number of DATA_TOP’s on the target system [4]:               — accepted the default value (db_sys_files, db_log_files, db_dat_files, db_ndx_files)

Target system DATA_TOP 1:/oracle/db/apps_st/data           –enter path of DATA_TOP

Target system DATA_TOP 2:/oracle/db/apps_st/data           –enter path of DATA_TOP

Target system DATA_TOP 3:/oracle/db/apps_st/data           –enter path of DATA_TOP

Target system DATA_TOP 4:/oracle/db/apps_st/data           –enter path of DATA_TOP

Target system RDBMS ORACLE_HOME directory:/oracle/db/tech_st/10.2.0                   — enter ORACLE_HOME path

Do you want to preserve the Display set to null (y/n) [y] ?:               –press enter

Do you want the the target system to have the same port values as the source system (y/n) [y] ?:   –press enter

    1. Configure the target system application tier server nodes
      Log on to the target system as the APPLMGR user and type the following commands:
      cd <COMMON_TOP>/clone/bin
      perl adcfgclone.pl appsTier

[oracle@testapps ~]$ cd $COMMON_TOP

[oracle@testapps comn]$ cd clone/bin/

[oracle@testapps bin]$ perl adcfgclone.pl appsTier

Enter the APPS user password: apps

Enter the APPS password: apps

Provide the values required for creation of the new APPL_TOP Context file.

Target hostname (virtual or normal) [testapps]:                                  –enter target apps hostname

Target system database SID: PROD                                                  –enter SID

Target system database server node [testapps]:testdb                        –enter target db hostname

Target system base directory for source homes:/oracle                       –enter base directory of your db installation

Target system base directory for instance homes [/oracle/inst]:          –press enter

Do you want to preserve the Display set to testapps:0.0 (y/n) [y] ?:  –press enter

Do you want the the target system to have the same port values as the source system (y/n) [y] ?:   –press enter

UTL_FILE_DIR on database tier consists of the following directories.

  1. /usr/tmp
  2. /oracle/db/tech_st/10.2.0/appsutil/jre
  3. /oracle/db/tech_st/10.2.0/appsutil/jre/bin/java
  4. /oracle/db/tech_st/10.2.0/appsutil/outbound/PROD_proddb
  5. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1]:        –press enter (/usr/tmp)

Section 3: Finishing Tasks (If Required)

This section lists tasks that may be necessary, depending on your implementation and the intended use of the cloned system. 

  1. Update profile options
    Rapid Clone updates only site level profile options. If any other profile options are set to instance specific values, you must update them manually.
  2. Update printer settings
    If the new cloned system needs to utilize different printers, update the target system with the new printer settings now.
  3. Update Workflow configuration settings
    Cloning an Oracle Applications instance will not update the host and instance specific information used by Oracle Workflow. Review the following tables and columns to verify there is no instance specific data in the Workflow configuration on the target system.
Table Name Column Name Column Value Details
WF_NOTIFICATION_ATTRIBUTES TEXT_VALUE Value starts with http://<old web host> : Update to new web host
WF_ITEM_ATTRIBUTE_VALUES TEXT_VALUE Value starts with “http://<old web host> : Update to new web host
WF_SYSTEMS GUID Create a new system defined as the new global database name using the Workflow Administrator Web Applications responsibility.
WF_SYSTEMS NAME Value needs to be replaced with the database global name
WF_AGENTS ADDRESS Update database link with the new database global name.
FND_FORM_FUNCTIONS WEB_HOST_NAME Update with the new web host name
FND_FORM_FUNCTIONS WEB_AGENT_NAME Update to point at the new PLSQL listener name
FND_CONCURRENT_REQUESTS LOGFILE_NAME Update with the correct path to the logfile directory
FND_CONCURRENT_REQUESTS OUTFILE_NAME Update with the new directory path on the target system
  1. Verify the APPLCSF variable setting
    Source the APPS environment and review that the variable APPLCSF (identifying the top-level directory for concurrent manager log and output files) points to a suitable directory. To modify it, change the value of the s_applcsf variable in the context file and then run AutoConfig.
  2. Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
    If the target system is in a different domain name than the source system and SESSION_COOKIE_DOMAIN was not null in the source system, update that value to reflect the new domain name.

Reference: Metalink Note 406982.1 and 387859.1

 

Please do not forget to share knowledge, share this on your social network. Hope you subscribe for email news letter as well, thanks.

Any questions? or Suggestion leave a comment below.

About the author

admin

5 Comments

  • Hi Qamar,

    Thanks for sharing insight for cloning and DB domain. I am non-technical resource but willing to learn and uplift my skills and get at least a literate level capabilities in DB domain.

    So my question is, can I use the same steps for my Oracle EBS R12.2 (Vision installed on oralce virtual machine)?

    Thanks again!
    Zeeshan

    • Hi Zeeshan,

      Thanks for your review. As you know Oracle EBS R12.2 there is change in architecture there are two edition RUN edition and Patch Edition (fs1, fs2). So cloning steps are little bit diffrent and will share the blog soon.

      Best Regards,
      Qamar

  • I see you don’t monetize your blog, don’t waste your traffic, you can earn extra bucks every month.
    You can use the best adsense alternative for any type of website (they approve all websites), for more details simply search in gooogle:
    boorfe’s tips monetize your website

  • Spot on with this write-up, I truly think this website wants far more consideration. I’ll most likely be again to learn far more, thanks for that info.

Leave a Reply

%d bloggers like this: