Complete Guide to Cloning Oracle E-Business Suite R12.1.3

Environment Overview

Source Environment

Component	Details
EBS Version	R12.1.3
Database Version	12.1.0.2
SID	FBS
Server	fbstest.finsys.co.ke
DB OS User	oracle
Apps OS User	applmgr
OEL Version	8.10

Target Environment

Component	Details
EBS Version	R12.1.3
Database Version	12.1.0.2
SID	VIS
Server	ebstest.finsys.co.ke
DB OS User	oracle
Apps OS User	applmgr
OEL Version	8.10 (or any supported version)

Prerequisites

Before beginning the cloning process, ensure your target machine has all required prerequisites for an EBS environment. Additionally, apply the following critical patches on the source application tier:

Required Patches

Patch Number	Description
23569686	R12.AD.B.delta.8
27102203	TXK AutoConfig Template Rollup
27135427	12.1 RAPIDCLONE CONSOLIDATED FIXES AUG/2018

Steps to Apply Patches

1. Copy adgrants.sql

[oracle@fbsebs ~]$ cd /u01/app/FBS/db/tech_st/12.1.0/
[oracle@fbsebs 11.1.0]$ . FBS_fbsebs.env
[oracle@fbsebs 11.1.0]$ sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Dec 2 12:40:35 2024

Copyright (c) 1982, 2008, Oracle. All rights reserved.

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps

Note: Copy adgrants.sql from the 23569686/admin folder to $DB_ORACLE_HOME/appsutil/admin. Create the admin directory if it doesn't exist.

2. Apply Patches Using adpatch

Switch to the APPLMGR user and apply each patch:

[applmgr@fbsebs stubs]$ . /u01/app/FBS/apps/apps_st/appl/APPSFBS_fbsebs.env
[applmgr@fbsebs stubs]$ cd /u01/patches/app/23569686
[applmgr@fbsebs 23569686]$ adpatch apply=yes driver=u23569686.drv

[applmgr@fbsebs stubs]$ cd ../27135427
[applmgr@fbsebs 27135427]$ adpatch apply=yes driver=u27135427.drv

[applmgr@fbsebs stubs]$ cd ../27102203
[applmgr@fbsebs 27102203]$ adpatch apply=yes driver=u27102203.drv

3. Verify Patches

Run the following SQL query to verify installed patches:

select bug_number from ad_bugs where bug_number in ('9171651','9833058','12404574','12598630','15969020','16958896','13942692','8919489');

4. Run AutoConfig and Prepare appsutil

[applmgr@fbstest ~]$ cd $APPL_TOP
[applmgr@fbstest ~]$ . APPSFBS_fbstest.env
[applmgr@fbstest ~]$ perl $AD_TOP/bin/admkappsutil.pl

The command will generate appsutil.zip at:
/u01/apps/FBS/inst/apps/FBS_fbstest/admin/out/appsutil.zip

Database Tier Preparation

Copy appsutil.zip to Database Tier

[oracle@fbstest ~]$ . 12c.env
[oracle@fbstest ~]$ cd $ORACLE_HOME
[oracle@fbstest 12.1.0]$ mv appsutil.zip appsutil.zip_orig
[oracle@fbstest 12.1.0]$ cp /u01/apps/FBS/inst/apps/FBS_fbstest/admin/out/appsutil.zip .
[oracle@fbstest 12.1.0]$ unzip -o appsutil.zip

Generate Context File

[oracle@fbstest 12.1.0]$ cd $ORACLE_HOME/appsutil/bin
[oracle@fbstest bin]$ perl adbldxml.pl appsuser=apps appspasswd=apps jtop=$ORACLE_HOME/jdk

Run AutoConfig on Database Tier

[oracle@fbstest bin]$ perl adconfig.pl contextfile=/u01/app/FBS/db/tech_st/12.1.0/appsutil/FBS_fbstest.xml
Enter the APPS user password:

Create Required Soft Links

For Linux 7 and 8:

# cd /usr/lib
# ln -s libdb-5.3.so libdb-4.3.so
# cd /usr/lib
# ln -s libXm.so.4.0.4 libXm.so.2

For Linux 6 and 5:

# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Running Pre-Clone on Source System

Database Tier Pre-Clone

[oracle@fbstest ~]$ . FBS_fbstest.env
[oracle@fbstest ~]$ cd $ORACLE_HOME/appsutil/scripts
[oracle@fbstest scripts]$ cd FBS_fbstest
[oracle@fbstest FBS_fbstest]$ adpreclone.pl dbTier

Enter the APPS User Password:

Application Tier Pre-Clone

[applmgr@fbstest ~]$ . APPSFBS_fbstest.env
[applmgr@fbstest ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@fbstest scripts]$ perl adpreclone.pl appsTier

Copying File Systems

Stop Source Services

Shut down the source system's database and application tier processes.

Copy Application Tier Directories

As APPLMGR user, copy these directories:

[APPL_TOP]
[COMMON_TOP]
OracleAS Tools ORACLE_HOME
OracleAS Web IAS_ORACLE_HOME

Copy Database Tier Directories

As ORACLE user, copy:

Database (.dbf) files
Database ORACLE_HOME

Create Backups

# Database backup
[oracle@fbstest db]$ cd /u01/backup/
[oracle@fbstest db]$ tar -zcvf db_121.tar.gz /u01/app/FBS/db/apps_st /u01/app/FBS/db/tech_st

# Application backup
[applmgr@fbstest backup]$ tar -zcvf appp_ebs121.tar.gz /u01/apps/FBS/apps

Transfer Files to Target

# Move backups to backup directory
[oracle@fbstest db]$ mv db_121.tar.gz /u01/backup/
[applmgr@fbstest FBS]$ mv appp_ebs121.tar.gz /u01/backup/

# On target machine, extract files
[oracle@fbsebs]$ cd /u01/app/FBS/db
[oracle@fbsebs]$ tar -zxvf db_121.tar.gz

[applmgr@fbsebs]$ cd /u01/app/FBS
[applmgr@ebstest APPS]$ tar -zxvf appp_ebs121.tar.gz

Create oraInst.loc File

[root@fbsebs]# cat /etc/oraInst.loc
inventory_loc=/u01/app/inventory
inst_group=dba

Configuring Target System

Database Tier Configuration

Navigate to the clone bin directory and set environment variables:

[oracle@fbsebs]$ cd /u01/app/FBS/db/tech_st/12.1.0/appsutil/clone/bin
[oracle@fbsebs bin]$ export ORACLE_HOME=/u01/app/FBS/db/tech_st/12.1.0
[oracle@fbsebs bin]$ export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH
[oracle@fbsebs bin]$ export ORACLE_SID=FBS
[oracle@fbsebs bin]$ export PERL5LIB=$ORACLE_HOME/perl/lib/5.14.1:$ORACLE_HOME/perl/site_perl/5.14.1:$ORACLE_HOME/appsutil/perl

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

Provide the following values when prompted:

Parameter	Value
Target System Hostname	fbsebs
Target Instance is RAC	n
Target System Database SID	FBS
Target System Base Directory	/u01/app/FBS/db
Target System utl_file_dir Directory	/u01/app/FBS/utlfiledir
Number of DATA_TOP's	1
Target System DATA_TOP Directory	/u01/app/FBS/db/apps_st/data
Target System RDBMS ORACLE_HOME	/u01/app/FBS/db/tech_st/12.1.0
Preserve Display	n
Target System Display	fbsebs:0.0
Same port values as source	n
Target System Port Pool	10

Application Tier Configuration

[applmgr@fbsebs bin]$ cd /u01/app/FBS/apps/apps_st/comn/clone/bin
[applmgr@fbsebs bin]$ perl adcfgclone.pl appsTier