In this note, I am going to talk to about the Clone/Refresh of Oracle Applications R12.2.3. This process is applicable to any R12.2.x release. Cloning is the process of creating a copy of an existing Oracle E-Business Suite (EBS) system. Refresh is another word used interchangeably with Clone.
Environment:
Application - Linux x86-64 Oracle Linux 6
This node has the web/weblogic/managed services/forms/concurrent managers. OS user is 'applwms'.
Source Application Node :BLUE1
Target Application Node :PINK1
Database - HP-UX Itanium 11.31
This node have only the database. Both OS user are 'orawms'
Source DB Node: VAIDIYAN1
Source SID: APPLE
Target DB Node: VAIDIYAN2
Target SID: BERRY
Assumption:
- Both source and target will have the same two node architecture.
- Database Source backup is taken with Snapshot/Technology. You can also use RMAN, Snap View, Mirror View or other method for DB backup.
Standard Cloning: Creating a copy of an Oracle EBS system using RapidClone
File System Cloning: Copying the run file system to the patch file system in online patching using adop phase=fs_clone.
Key Pre-requistes:
- Disk Space on the Source system and Target
- Source and Target must be on the same Operating System (OS) and patch level
- Apply the latest AD/TXK patches to the Source system
Overall Cloning/Refresh Process:
- Prepare the Source for Database and Application tier.
- Copy the Database tier from Source to Target.
- Copy the Application Run edition File system from Source to Target Run edition file system.
- Configure the Target Database
- Configure the Target Application Run edition file system.
- Prepare Target Run edition file system to build Target Patch edition file system.
- Configure the Target Patch edition file system.
- Post clone tasks.
1.1 Prepare the Source Database tier:
Log on to the Source Database System as orawms
$ cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
$ perl adpreclone.pl dbTier
orawms/APPLE@VAIDYAN01>cd $ORACLE_HOME/appsutil/scripts/APPLE_VAIDIYAN1
orawms/APPLE@VAIDYAN01> perl adpreclone.pl dbTier
Enter the APPS User Password:
The process takes about 10 minutes
1.2 Prepare the Source Application tier:
Logon to the RUN edition file system of the Source as applwms
$ cd <INST_TOP>/admin/scripts
$ perl adpreclone.pl appsTier
[applwms@BLUE1 scripts]$echo $FILE_EDITION
run
[applwms@BLUE1 scripts]$ perl adpreclone.pl appsTier
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
This process takes 40 minutes. From release R12.2, the adpreclone.pl process creates a complete and compressed archive of Oracle Fusion Middleware and its components (Weblogic Server, Web Tier Utilties, Common Utilities and EBS Home. The files are created in /clone.
2 Copy the files from Source to Target Database tier.
This can be a storage copy, RMAN restore, Flash Copy, Snapshot.
3 Copy the Application Run edition File system from Source to Target Run edition file system.
This can be performed by a rcp -pr, scp -pr. Please note that you only need to copy RUN file system.
4.1 Configure the Target Database
Login to VAIDIYAN2 as orawms and configure the database home
$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
$ perl adcfgclone.pl dbTechStack
orawms/BERRY@VAIDIYAN2> cd $ORACLE_HOME/appsutil/clone/bin
orawms/BERRY@VAIDIYAN2> perl adcfgclone.pl dbTechStack
Enter the APPS password :
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [VAIDIYAN2] : VAIDIYAN2
Target Instance is RAC (y/n) [n] : n
Target System Database SID : BERRY
Target System Base Directory : /wms01/app/oracle/wmsoradb
Target System utl_file_dir Directory List : /tmp,/wms01/app/oracle/wmsoradb/11.2.0/appsutil/outbound/BERRY_VAIDIYAN2
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/wms05/wmsdata] :
Target System RDBMS ORACLE_HOME Directory [/wms01/app/oracle/wmsoradb/11.2.0] :
Do you want to preserve the Display [null] (y/n) : y
Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 19
Checking the port pool 19
done: Port Pool 19 is free
Report file located at /wms01/app/oracle/wmsoradb/11.2.0/appsutil/temp/portpool.lst
This will be followed by rdbms home Apply and starting the listener. The entire process takes 15-20 minutes.
4.2 Create DB Controlfile and Recover the Database
Use the backup controlfile from the Source to build Target Controlfile. Recover the database that you copied through snapshot. Open the Target database.
4.3 Start the Library Update Script against the database
$ cd <RDBMS ORACLE_HOME>/appsutil/install/<CONTEXT NAME>
$ sqlplus "/ as sysdba" @adupdlib.sql <libext>
Where <libext>
orawms/BERRY@VAIDIYAN2> cd $ORACLE_HOME/appsutil/install/BERRY_VAIDIYAN2
orawms/BERRY@VAIDIYAN2> sqlplus / as sysdba @adupdlib.sql sl
4.4 Configure the Target database
$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin $ perl adcfgclone.pl dbconfig <database target Context File>
Where "Database Target Context File" is:
orawms/BERRY@VAIDIYAN2> cd $ORACLE_HOME/appsutil/clone/bin
orawms/BERRY@VAIDIYAN2> perl adcfgclone.pl dbconfig /wms01/app/oracle/wmsoradb/11.2.0/appsutil/BERRY_VAIDIYAN2.xml
Enter the APPS password :
This step will take 5-10 minutes.
5 Configure the Target Application tier
Before we start configuring the Target Application tier, Please make sure that the following folders are only in system base. "FMW_Home" should be removed.
[applwms@PINK1 bin]$ cd /wms/app/oracle/fs1/
[applwms@PINK1fs1]$ ls
EBSapps inst
[applwms@PINK1 fs1]$ cd /wms/app/oracle/fs1/inst/apps
[applwms@PINK1 apps]$ ls
[applwms@PINK1 apps]$
Log on to the RUN edition file system in the Target as applwms
$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier
[applwms@PINK1~]$ cd $COMMON_TOP/clone/bin
[applwms@PINK1 bin]$ perl adcfgclone.pl appsTier
Enter the APPS password :
Enter the Weblogic AdminServer password :
Do you want to add a node (yes/no) [no] :
Target System File Edition type [run] :
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [PINK1] : PINK1
Target System Database SID : BERRY
Target System Database Server Node [PINK1] : VAIDIYAN2
Target System Database Domain Name [XYZ.com] :
Target System Base Directory : /wms/app/oracle
Target System Base Directory set to /wms/app/oracle
Target System Current File System Base set to /wms/app/oracle/fs1
Target System Other File System Base set to /wms/app/oracle/fs2
Target System Fusion Middleware Home set to /wms/app/oracle/fs1/FMW_Home
Target System Web Oracle Home set to /wms/app/oracle/fs1/FMW_Home/webtier
Target System Appl TOP set to /wms/app/oracle/fs1/EBSapps/appl
Target System COMMON TOP set to /wms/app/oracle/fs1/EBSapps/comn
Target System Instance Home Directory [/wms/app/oracle] :
Target System Instance Top set to /wms/app/oracle/fs1/inst/apps/BERRY_PINK1
Do you want to preserve the Display [BLUE1:0.0] (y/n) : n
Target System Display [PINK1:0.0] :
Target System Root Service [enabled] :
Target System Web Administration [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [enabled] :
Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 19
Checking the port pool 19
done: Port Pool 19 is free
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /wms01/app/oracle/wmsoradb/11.2.0/appsutil/outbound/BERRY_VAIDIYAN2
4. /wms01/app/oracle/wmsoradb/11.2.0/appsutil/outbound/BERRY_VAIDIYAN2
5. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
Do you want to startup the Application Services for WMSDEV3? (y/n) [n] : y
This process would take up to 45 minutes.
6.1 Prepare the Target RUN edition file system to build Target PATCH edition file system
Run adpreclone.pl on the run edition file system in the Target System on a new Putty session.
[applwms@PINK1 ~]$ . /wms/app/oracle/EBSapps.env
E-Business Suite Environment Information
----------------------------------------
File System Type : SINGLE
RUN File System : /wms/app/oracle/fs1/EBSapps/appl
PATCH File System : NOT APPLICABLE
Non-Editioned File System : /wms/app/oracle/fs_ne
DB Host: VAIDIYAN2.XYZ.com Service/SID: BERRY
Sourcing the RUN File System ...
[applwms@PINK1 ~]$
[applwms@PINK1 oracle]$ echo $FILE_EDITION
run
[applwms@PINK1 oracle]$
Remove/Move the current clone folder in the Target RUN edition file system
[applwms@PINK1 oracle]$ cd /wms/app/oracle/fs1/EBSapps/comn
[applwms@PINK1 comn]$ mv clone clone_APPLE
[applwms@PINK1 comn]$ cd $ADMIN_SCRIPTS_HOME
[applwms@PINK1 scripts]$ perl adpreclone.pl appsTier
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
This step runs for 20-25 minutes.
6.2 Copy the Target RUN edition file system (EBSapps) to PATCH edition file system
[applwms@PINK1 ~]$ cd /wms/app/oracle/
[applwms@PINK1 oracle]$ mkdir fs2
[applwms@PINK1 oracle]$ cd /wms/app/oracle/fs1
[applwms@PINK1 fs1]$ pwd
/wms/app/oracle/fs1
[applwms@PINK1 fs1]$ cp -rp EBSapps ../fs2/
[applwms@PINK1 fs1]$ cd ../fs2/
[applwms@PINK1 fs2]$ pwd
/wms/app/oracle/fs2
[applwms@PINK1 fs2]$ ls
EBSapps
[applwms@PINK1 fs2]$
7 Configure the Target Patch edition file system
Log on to the PATCH edition file system in the Target System as the applwms user
$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier
The patch edition file system must be aware of the location of the run edition file system that will be configured in the next step. At the prompt "Location of Run System Context File", enter the absolute path to the context file for the run edition file system that was created in the previous step.
[applwms@PINK1 ~]$. /wms/app/oracle/EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /wms/app/oracle/fs1/EBSapps/appl
PATCH File System : /wms/app/oracle/fs2/EBSapps/appl
Non-Editioned File System : /wms/app/oracle/fs_ne
DB Host: VAIDIYAN2.XYZ.com Service/SID: BERRY
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:P
Sourcing the PATCH File System ...
[applwms@PINK1 ~]$ cd /wms/app/oracle/fs2/EBSapps/comn/clone/bin
[applwms@PINK1 bin]$ perl adcfgclone.pl appsTier
Enter the APPS password :
Enter the Weblogic AdminServer password :
Do you want to add a node (yes/no) [no] :
Target System File Edition type [run] : patch
Enter the full path of Run File System Context file : /wms/app/oracle/fs1/inst/apps/BERRY_PINK1/appl/admin/BERRY_PINK1.xml
Provide the values required for creation of the new APPL_TOP Context file.
Target System Fusion Middleware Home set to /wms/app/oracle/fs2/FMW_Home
Target System Web Oracle Home set to /wms/app/oracle/fs2/FMW_Home/webtier
Target System Appl TOP set to /wms/app/oracle/fs2/EBSapps/appl
Target System COMMON TOP set to /wms/app/oracle/fs2/EBSapps/comn
Target System Instance Top set to /wms/app/oracle/fs2/inst/apps/BERRY_PINK1
Target System Port Pool [0-99] : 20
Checking the port pool 20
done: Port Pool 20 is free
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /wms01/app/oracle/wmsoradb/11.2.0/appsutil/outbound/BERRY_VAIDIYAN2
4. /wms01/app/oracle/wmsoradb/11.2.0/appsutil/outbound/BERRY_VAIDIYAN2
5. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
..
..
..
Looking for incomplete CLONE record in ad_adop_session_patches table
The CLONE record status is no rows selected
Updating incomplete CLONE record to COMPLETED
This step would take close to 45 minutes.
8. Post clone tasks.
- Update profile options.
- Update printer settings.
- Update Workflow configuration settings.
- Verify the APPLCSF variable setting.
- Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS.
- Re-Implement SSL and SSO configuration.
You have completed the clone of R12.2.3 One Application and One Database Node environment.
Reference:
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2.(Document 1617461.1)
Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK Delta Information(Document 1583092.1)
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)
No comments:
Post a Comment