EBS 12.2 application and database online cloningFull description
Full description
Full description
Auto Receipt in R12Full description
Oracle R12 Table level changes from R12 to 11iFull description
Renault R12 M.R.150 - repair manualDescrição completa
Full description
T24 R12 Release Notes
Full description
R12 Online Patching
software user guide
Renault R12 M.R.150 - repair manualDescripción completa
Full description
Setup Steps to Implement R12 Oracle Sourcing.
Cloning
Page 1 of 15
search...
Home
MAIN MENU
Oracle Apps DBA
R12
Cloning
Cloning
Home
Wednesday, 02 February 2011 04:51
Oracle Zones
Oracle Apps DBA
Cloning
11i
R12 Stage Area Create
Cloning creates an identical copy of an existing Oracle Applications system. There are various reasons for cloning an Oracle Applications system such as: Creating a copy of the production system for testing updates.
Installation
Migrating Migrating an existing system to new hardware. Creating a stage area to reduce patching downtime
Start and Stop Services
Clone the E-Business Suite for Release 12(12.0.6) with Oracle Applications. In this post, we cover the pre-clone steps required to perform a successful clone for Oracle
Patching
Backup
Applications R12 (12.0.6). As an Apps DBA, the ability to quickly produce clones is mandatory to be a successful EBS DBA. The following post will show details on how to clone. First, First, we need to pre-clone the database tier and then we run the pre-clone script for
Recovery
Cloning
the apps tier. Both the Sequence and syntax are critical critical here and the clone will fail. A) Pre-clone for Database B) Pre-clone for Application
Display
C) Shutdown Database & Listener FNDCPASS
D) Copy Data from Source Node To Target Node Menu
E) Cloning the Database Tier
Responsibilities and User
F) Cloning the Applications Tier G) Verification
Reports Intregiration
Web ADI
Oracle Database Administration
A) Pre-clone for Database The pre-clone script for database and apps tier is called adpreclone.pl. adpreclone.pl . It lives under the $ORACLE_HOME/appsutil/scripts/ directory on the database tier. In my scenario the path is cd /d01/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/
Cloning
Page 2 of 15
$ perl adpreclone.pl dbTier Enter the APPS password for the script to execute
It runs for a few minutes and then completes without errors B) Pre-clone For Application The pre-clone script for apps tier is located under the $INST_TOP/admin/scripts or $ADMIN_SCRIPTS_HOME directory and is called adpreclone.sh. To execute it we logon as oracle user and run, in my scenario the path is cd /d01/oracle VIS/inst/apps/VIS_learnozs/admin/scripts/ $ perl adpreclone.pl appsTier Enter the APPS password Oracle Application Server
Cloning
Page 3 of 15
This will run for a short time maybe 5-10 minutes and then complete. Verify that your preclone ran without errors. Check the log file generated by the adpreclone.sh script for the apps tier to ensure no e rrors have occurred C) Shutdown Database & Listener On the database tier, login as the oracle OS user and shutdown both the listener and database, Shutdown listener $ cd /d01/oracleVIS/db/tech_st/10.2.0/appsutil/scripts/VIS_learnozs/ ./addlnctl.sh stop VIS
Cloning
$ cd /d01/oracleVIS/db/tech_st/10.2.0/appsutil/scripts/VIS_learnozs/ ./addbctl.sh stop immediate
D) Copy Data from Source Node To Target Node Copy the application tier file system Before we use Rapid Clone script (adcfgclone.pl) we need to copy over the database and application tier files. Copy the application tier directories from the source node to
Page 4 of 15
Cloning
Page 5 of 15
the target application tier node. So this means that for the Apps tier you need to copy over the $INST_TOP, $COMMON_TOP, $APPL_TOP, 10.1.2 ORACLE_HOME, and 10.1.3 ORACLE_HOME directories and files Copy the database node file system Copy the database (.dbf) files from the source system to the target system, copy the source database ORACLE_HOME to the target system E) Cloning the Database Tier Run the clone script for db tier this is called adcfgclone.pl $ cd /d01/oracle/VIS/db/tech_st/10.2.0/appsutil/clone/bin/ $ perl adcfgclone.pl dbTier
Enter the password for APPS then hit the key Once we enter the choices for the prompt settings the clone will begin for the db tier. You will need to enter settings for your target clone data file location (DATA_TOP) as well as database tier ORACLE_HOME location, and other settings such a s port pool.
Cloning
Page 6 of 15
Cloning
Page 7 of 15
When it finishes you should see a successful screen like below:
Cloning
Page 8 of 15
F) Cloning the Applications Tier Now that our database tier has been cloned its time to clone the apps tier to the new target! We run the adfgclone.pl script on the source apps tier as shown below The cloning script for the apps tier lives under the following directory: $ cd $INST_TOP/clone/bin Login as the applmgr OS user and we run it with the following syntax: $cd /d01/oracle/VIS/apps/apps_st/comn/clone/bin/ perl adcfgclone.pl appsTier
Enter the password for APPS then hit the key Choose 0 for port pool like we did earlier for db tier clone, a complete list is given below:
Cloning
Page 9 of 15
Cloning
Page 10 of 15
Cloning
Page 11 of 15
Cloning
Page 12 of 15
Cloning
G) Verification For verfication please go to Window Explorer and w rite below address http:learnonzs.oraclezones.com:8000
Page 13 of 15
Cloning
Page 14 of 15
Cloning
Page 15 of 15
Successfully R12 cloning has been done Best of Luck ……………………..! Last Updated on Saturday, 02 July 2011 10:09
