Hai, in this article I will demonstrate RAPID CLONE for EBS
R12.2in Linux 5.7_x64Bit
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Troubleshooting Rapid Install for E-Business Suite Release 12.2 (Doc ID 1378579.1)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
================================================================================================================
+++++++++++++++++++++++++++++
Application Release: 12.2.6
Application Release: 12.2.6
Database Release: 12.1.0.2.0
+++++++++++++++++++++++++++++
Major Steps performed for Cloning
1.
Preparation
of SOURCE SYSTEM
2.
Perform
all prerequisites for New Clone and
unzip Files
3.
Configure
DATABASE TIER
4.
Configure
Application Tier
1)
Preparation of SOURCE
SYSTEM
--- Verfiy Below two query result should match with CLONED DB
To check component list and last applied bundel patch
As some time component MGD will be missing when cloning an OCI db with(CDB-PDB)
SQL> select comp_id,comp_name,version,status from dba_registry;
SQL>
SQL> select description from dba_registry_sqlpatch;
--- Preparation SOURCE Database ---
[oracle@rac1 ~]$
[oracle@rac1 ~]$ echo
$FILE_EDITION
run
[oracle@rac1 ~]$ cd
/u01/db_PROD/12.1.0/appsutil/scripts/PROD_rac1
[oracle@rac1
PROD_rac1]$ ll adpreclone.pl
-rwx------ 1 oracle
dbaerp 27190 Mar 23 14:30 adpreclone.pl
[oracle@rac1
PROD_rac1]$ perl adpreclone.pl dbTier
--- Preparation SOURCE
Application ---
[oracle@rac1 ~]$
[oracle@rac1 ~]$ echo
$FILE_EDITION
run
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cd
/u01/apps/PROD/fs1/EBSapps/comn/clone/bin
[oracle@rac1 bin]$ perl adpreclone.pl
appsTier
--- Shutdown Application
and database Tier ---
[oracle@rac1 ~]$
[oracle@rac1 ~]$ echo $FILE_EDITION
run
[oracle@rac1 ~]$
[oracle@rac1 scripts]$ echo adstpall.sh apps/apps
You are running adstpall.sh version 120.22.12020000.5
Enter the WebLogic Server password:weblogicr12
[oracle@rac1 scripts]$ echo adstpall.sh apps/apps
You are running adstpall.sh version 120.22.12020000.5
Enter the WebLogic Server password:weblogicr12
--- Perform full Cold
Backup ---
Database backup
[root@rac1 ~]# cd
/u01
[root@rac1 u01]# tar –cvzf
db.tar.gz db_PROD
[root@rac1 u01]#
[root@rac1 u01]#
Application Backup
[root@rac1 ~]# cd
/u01
[root@rac1 u01]# tar -cvzf
apps.tar.gz apps
[root@rac1 u01]#
[root@rac1 u01]#
Application Backup in solaris 11
[root@rac2 ~]# tar Ecf - /u01/AHC/fs2/EBSapps | gzip -3 - > /u01/BKP/EBSapps.tar.gz
untar folder
[root@rac2 ~]# gunzip EBSapps.tar.gz
[root@rac2 ~]# tar -xvf EBSapps.tar
--------------
tar -C /home/oracle/expdp/ -cvzf /home/oracle/expdp/AJAR_LIVE_27092021.dmp.tar.gz AJAR_LIVE_27092021.dmp (to tar in different loc. & Exclude path /home/oracle/expdp while uncompress)
2)
Perform all prerequisites at TARGET
--- Prepare all prerequisite for Target Linux by following here
--- Linux Machine Details:
--- Threading Model in Linux must be NPTL as per
--- Networking Configuration:
--- Remove the file “network” form following Location:
--- Install all the following Packages to Install EBS R12.2:
--- Kernel Parameter Settings:
--- Limits.conf Settings:
--- Oracle HTTP Server Patch (Offline Download)
--- Creation of Softlinks for EBS R12.2 Installation:
--- Creation of oraInst.loc:
==============================================================================================================
--- Creation of Groups,
Users and Directories ---
[root@rac1 ~]#
[root@rac1 ~]#
userdel oracle
userdel oracle
rm -rf
/home/oracle /var/mail/oracle
groupadd dbaerp
useradd -g
dbaerp oracle
mkdir -p /u01/apps/CLONE/fs1
mkdir -p
/u01/apps/CLONE/fs2
mkdir -p
/u01/oracle/oraInventory/
chown -R oracle:dbaerp /u01
==============================================================================================================
UNTAR backup files and
change permission
[root@rac1
EBS_R_12_2_6]#
[root@rac1
EBS_R_12_2_6]# tar -xvzf db_R12_2_6_FRESH_INSTALL.tz -C /u01/
[root@rac1
EBS_R_12_2_6]# tar -xvzf appsR12_2_6_FRESH_INSTALL.tz -C /u01/apps/CLONE/fs1
[root@rac1 ~]# chown -R
oracle:dbaerp /u01
[root@rac1 ~]#
==============================================================================================================
Database Home OPatch check:
[oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.21
OPatch succeeded.
Application Home OPatch check:
[oraerp@rac1 ~]$ $ORACLE_HOME/OPatch/opatch version | grep "Installer version"
Oracle Interim Patch Installer version 1.0.0.0.64
[oracle@rac1 ~]$
Unzip patch 17537119 in
appsutil/etcc directory.
Check the etcc directory.
If not there then create
[oracle@rac1 ~]$
[oracle@rac1 ~]$ mkdir -p
/u01/db_CLONE/12.1.0/appsutil/etcc/
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cp
p17537119_R12_GENERIC.zip /u01/db_CLONE/12.1.0/appsutil/etcc/
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cd
/u01/db_CLONE/12.1.0/appsutil/etcc/
[oracle@rac1 etcc]$
[oracle@rac1 etcc]$ unzip
p17537119_R12_GENERIC.zip
[oracle@rac1 etcc]$ ls -ltr -- all the below files and folders need to be created upon unzip. If not checkMT will not execute.
total 765
drwxr-xr-x 4 oracle oinstall 4 May 8 2018 db
drwxr-xr-x 2 oracle oinstall 4 Feb 8 2019 mw
-rwxrwxrwx 1 oracle oinstall 26032 May 19 18:24 README.txt
-rwxr-xr-x 1 oracle oinstall 51349 May 25 00:37 checkMTpatch.cmd
-rwxrwxrwx 1 oracle oinstall 46927 Jun 7 21:44 checkMTpatch.sh
-rwxr-xr-x 1 oracle oinstall 89739 Aug 19 19:56 checkDBpatch.sh
-rwxr-xr-x 1 oracle oinstall 53653 Aug 19 19:56 checkDBpatch.cmd
-rwxrwxrwx 1 oracle oinstall 116439 Sep 6 08:26 p17537119_R12_GENERIC.zip
[oracle@rac1 etcc]$
==============================================================================================================
3)
Configure Target
Database Tier
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ cd /u01
[oracle@rac1 u01]$ ll
total 8
drwxrwxr-x 5 oracle
dbaerp 4096 Feb 16 15:59 db_PROD
drwxr-xr-x 5 oracle
dbaerp 4096 Feb 16 14:44 apps
[oracle@rac1 u01]$
[oracle@rac1 u01]$ mv db_PROD/
db_CLONE
before running adcfg check the patch 17537119 is there in etcc folder or not:
[oracle @rac1 u01]$ cd
/u01/db_CLONE/12.1.0/appsutil/clone/bin/
[oracle @rac1 bin]$
[oracle @rac1 bin]$
[oracle@rac1 bin]$ ./adcfgclone.pl
dbTier
Copyright (c) 2002, 2015
Oracle Corporation
Redwood Shores,
California, USA
Oracle E-Business Suite
Rapid Clone
Version 12.2
adcfgclone Version
120.63.12020000.56
Enter the APPS
password : apps
Running: Context
clone...
Log file located at
/u01/db_CLONE/12.1.0/appsutil/clone/bin/CloneContext_0323142500.log
Provide the values
required for creation of the new Database Context file.
Target System Hostname
(virtual or normal) [rac1] :
Target Instance is RAC
(y/n) [n] :
Target System Database
SID : CLONE
Target System Base
Directory : /u01/db_CLONE
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/db_CLONE/data] :
Target System RDBMS
ORACLE_HOME Directory [/u01/db_CLONE/12.1.0] :
Do you want to
preserve the Display [null] (y/n) : y
Target System Port
Pool [0-99] : 10
Checking the port pool
10
done: Port Pool 10 is
free
Report file located at
/u01/db_CLONE/12.1.0/appsutil/temp/portpool.lst
The new database
context file has been created :
/u01/db_CLONE/12.1.0/appsutil/CLONE_rac1.xml
Check Clone Context
logfile /u01/db_CLONE/12.1.0/appsutil/clone/bin/CloneContext_0323142500.log for
details.
Running Rapid Clone
with command:
Running:
perl
/u01/db_CLONE/12.1.0/appsutil/clone/bin/adclone.pl
java=/u01/db_CLONE/12.1.0/appsutil/clone/bin/../jre mode=apply
stage=/u01/db_CLONE/12.1.0/appsutil/clone component=dbTier method=CUSTOM
dbctxtg=/u01/db_CLONE/12.1.0/appsutil/CLONE_rac1.xml showProgress
contextValidated=true
Beginning database
tier Apply - Thu Mar 23 14:25:31 2017
/u01/db_CLONE/12.1.0/appsutil/clone/bin/../jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=true
-Doracle.installer.oui_loc=/u01/db_CLONE/12.1.0/oui -classpath
/u01/db_CLONE/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/db_CLONE/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/u01/db_CLONE/12.1.0/appsutil/clone/jlib/java:/u01/db_CLONE/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/db_CLONE/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/db_CLONE/12.1.0/appsutil/clone/jlib/oui/share.jar:/u01/db_CLONE/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/u01/db_CLONE/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e
/u01/db_CLONE/12.1.0/appsutil/CLONE_rac1.xml -stage
/u01/db_CLONE/12.1.0/appsutil/clone
-showProgress
APPS Password : Log
file located at /u01/db_CLONE/12.1.0/appsutil/log/CLONE_rac1/ApplyDBTier_03231425.log
\
15% completed
Completed Apply...
Thu Mar 23 14:30:12
2017
Starting database
listener for CLONE:
Running:
/u01/db_CLONE/12.1.0/appsutil/scripts/CLONE_rac1/addlnctl.sh
start CLONE
Logfile: /u01/db_CLONE/12.1.0/appsutil/log/CLONE_rac1/addlnctl.txt
You are running
addlnctl.sh version 120.4
Starting listener
process CLONE ...
Listener CLONE has
already been started.
addlnctl.sh: exiting
with status 0
addlnctl.sh: check the
logfile /u01/db_CLONE/12.1.0/appsutil/log/CLONE_rac1/addlnctl.txt for more
information ...
Do you want to change
the password for all EBS Schemas? (y/n) [n]) :Press Enter
Do you want to change
the password for sysadmin user? (y/n) [n]) : Press Enter
Do you want to change
the apps password? (y/n) [n]) : Press Enter
Do you want to change
the sys and system passwords? (y/n) [n]) : Press Enter
==============================================================================================================
Patch if you didn’t
applied the patch 17537119
Then you will get a
following WARNING:
Running ETCC to
check status of DB technology patches...
WARNING: ETCC does
not exist under /u01/db_CLONE/12.1.0/appsutil/etcc.
Download patch
17537119 from My Oracle Support, unzip it under
/u01/db_CLONE/12.1.0/appsutil/etcc and run ETCC to avoid ADOP related issues.
==============================================================================================================
Running ETCC to check
status of DB technology patches...
+===============================================================+
|
Copyright (c) 2005, 2017 Oracle and/or its affiliates. |
| All rights reserved. |
|
Oracle E-Business Suite Release 12.2 |
|
Database EBS Technology Codelevel Checker |
+===============================================================+
Using context file
from command line argument:
/u01/db_CLONE/12.1.0/appsutil/CLONE_rac1.xml
Starting Database EBS
Technology Codelevel Checker, Version 120.41
Thu Mar 23 14:30:26
AST 2017
Log file for this
session : /u01/db_CLONE/12.1.0/appsutil/etcc/checkDBpatch_9900.log
Bugfix XML file
version: 120.0.12020000.34
This file will be used
for identifying missing bugfixes.
Mapping XML file
version: 120.0.12020000.7
This file will be used
for mapping bugfixes to patches.
[WARNING] DB-ETCC:
Bugfix XML file (/u01/db_CLONE/12.1.0/appsutil/etcc/txk_R1220_DB_base_bugs.xml)
in current directory is more than 30 days old.
Check if a newer version is available in patch
17537119.
Identifying database
release.
Database release set
to 12.1.0.2.
Connecting to
database.
Database connection
successful.
Database CLONE is in
READ WRITE mode.
Identifying APPS and
APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC
results table.
Creating DB-ETCC
results table.
Created the table to
store DB-ETCC results.
Checking if InMemory
option is enabled.
InMemory option is not
enabled in the database.
Checking Bugfix XML
file for 12.1.0.2
Obtained list of
bugfixes to be applied and the list to be rolled back.
Now checking database
ORACLE_HOME.
The opatch utility is
version 12.1.0.1.10.
DB-ETCC is compatible
with this opatch version.
Found patch records in
the inventory.
Checking Mapping XML
file for 12.1.0.2
. . . .
. . . .
. . . .
. . . .
Apply the required
patches and rerun this script
You should check the
patch READMEs for minimum opatch version requirements.
The latest opatch is
available from My Oracle Support via Patch 6880880.
+-----------------------------------------------------------------------------+
A consolidated zip
file with the required patches for Database release
12.1.0.2.0 is
available on My Oracle Support via:
Patch 25201332 [12.1.0.2.0 version]
- EBS RELEASE 12.2 CONSOLIDATED DATABASE
FIXES FOR JAN 2017
Note: This zip does
not include any database bundle patches or PSUs.
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1
for any special instructions for these patches.
Note: Footnotes in Doc
ID 1594274.1 also apply to corresponding overlay patches.
Stored Technology
Codelevel Checker results in the database CLONE successfully.
Finished prerequisite
patch testing : Thu Mar 23 14:30:38 AST 2017
Log file for this
session: /u01/db_CLONE/12.1.0/appsutil/etcc/checkDBpatch_9900.log
===============================================================================
Post Clone Steps after adcfgclone.pl
1. Disable archivelog, flashback, force logging
[oracle@rac1 bin]$
[oracle@rac1 bin]$ . /u01/db_CLONE/12.1.0/CLONE_rac1.env
[oracle@rac1 bin]$ sqlplus / as sysdba
[oracle@rac1 bin]$
SQL> select LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database;
LOG_MODE FLASHBACK_ON FORCE_LOGGING
------------ ------------------ ---------------------------------------
NOARCHIVELOG NO NO
SQL>
2. clear fnd nodes
SQL> conn apps/apps
SQL> select release_name from apps.fnd_product_groups;
SQL> select NODE_NAME from fnd_nodes;
SQL> exec fnd_conc_clone.setup_clean;
SQL> commit;
3. Run Autoconfig it would complete successfully:
[oracle@rac1 bin]$ adautocfg.sh
[oracle@rac1 bin]$
4. check du -sh for size
[oracle@rac1 bin]$ cd /u01
[oracle@rac1 u01]$ du -sh *
[oracle@rac1 u01]$
Database cloning completed successfully:
4)
Configure Target
Application Tier
Configure Application “RUN FILE SYSTEM”
[oracle@rac1 ~]$
[oracle@rac1 ~]$
cd /u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/
[oracle@rac1 bin]$ ll
total 184
-rwxr-xr-x 1 oracle
dbaerp 7413 Nov 26 2012 adaddnode.pl
-rwxr-xr-x 1 oracle
dbaerp 47025 Nov 26 2012 adcfgclone.pl
-rwxr-xr-x 1 oracle
dbaerp 5101 Nov 26 2012 adchkutl.sh
-rwxr-xr-x 1 oracle
dbaerp 37265 Nov 26 2012 adclonectx.pl
-rwxr-xr-x 1 oracle
dbaerp 76411 Nov 26 2012 adclone.pl
[oracle@rac1 bin]$
[oracle@rac1 bin]$
While cloning to a new OL 7.9 got error "Module" when executing adcfg script click here for details:
[oracle@rac1 bin]$
[oracle@rac1 bin]$ ./adcfgclone.pl
appsTier
Copyright (c) 2011 Oracle
Corporation
Redwood Shores,
California, USA
Oracle E-Business Suite
Rapid Clone
Version 12.2
adcfgclone Version
120.63.12020000.7
Enter the APPS
password : apps
Enter the Weblogic
AdminServer password : weblogicr12
Running:
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath
/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/java
oracle.apps.ad.clone.util.OPWrapper
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath
/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/java
oracle.apps.ad.clone.util.OPWrapper /u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource
Do you want to add a
node (yes/no) [no] :Press Enter
Running:
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -cp
/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/java:/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/apps/CLONE/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar
oracle.apps.ad.context.CloneContext -e
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_11779.lst -stage
/u01/apps/CLONE/fs1/EBSapps/comn/clone
2> /tmp/adcfgclone_11779.err; echo $? > /tmp/adcfgclone_11779.res
Log file located at
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/CloneContext_0323143205.log
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) [rac1] :
Target System Database
SID : CLONE
Target System Database
Server Node [rac1] :
Target System Database
Domain Name [dell.com] :
Target System Base
Directory : /u01/apps/CLONE
Target System Base
Directory set to /u01/apps/CLONE
Target System Run File
System Base set to /u01/apps/CLONE/fs1
Target System Patch
File System Base set to /u01/apps/CLONE/fs2
Target System Fusion
Middleware Home set to /u01/apps/CLONE/fs1/FMW_Home
Target System Web
Oracle Home set to /u01/apps/CLONE/fs1/FMW_Home/webtier
Target System Appl TOP
set to /u01/apps/CLONE/fs1/EBSapps/appl
Target System COMMON
TOP set to /u01/apps/CLONE/fs1/EBSapps/comn
Target System Instance
Home Directory [/u01/apps/CLONE] :
Target System Instance
Top set to /u01/apps/CLONE/fs1/inst/apps/CLONE_rac1
Do you want to
preserve the Display [rac1:0.0] (y/n) : y
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 [disabled] :
Target System Port
Pool [0-99] : 10
Checking the port pool
10
done: Port Pool 10 is
free
Report file located at
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/admin/out/portpool.lst
Complete port
information available at
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/admin/out/portpool.lst
UTL_FILE_DIR on
database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3.
/u01/db_CLONE/12.1.0/appsutil/outbound/CLONE_rac1
4. /usr/tmp
Choose a value which
will be set as APPLPTMP value on the target node [1] :Press Enter
Creating the new
APPL_TOP Context file from :
/u01/apps/CLONE/fs1/EBSapps/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP
context file has been created :
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml
Log file located at
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/CloneContext_0323143205.log
Check Clone Context
logfile /u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/CloneContext_0323143205.log
for details.
Running Rapid Clone
with command:
Running:
perl
/u01/apps/CLONE/fs1/EBSapps/comn/clone/bin/adclone.pl . . . .
. . . .
. . . .
. . . .
Log file located at
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/admin/log/ApplyAppsTier_03231432.log
/
100% completed
Completed Apply...
Thu Mar 23 14:55:40
2017
Do you want to
startup the Application Services for CLONE? (y/n) [y] : Press Enter
Starting application
Services for CLONE:
Running:
. . . .
. . . .
. . . .
. . . .
Starting WLS Admin
Server...
. . . .
. . . .
. . . .
. . . .
All enabled services
for this node are started.
adstrtal.sh: Exiting
with status 0
adstrtal.sh: check the
logfile /u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/logs/appl/admin/log/adstrtal.log
for more information ...
[oracle@rac1 bin]$
Configure Application “PATCH FILE SYSTEM”
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cd /u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/admin/scripts
[oracle@rac1 ~]$
[oracle@rac1 ~]$ echo
$FILE_EDITION
[oracle@rac1 ~]$ .
/u01/apps/CLONE/fs1/EBSapps/appl/CLONE_rac1.env
[oracle@rac1 ~]$
[oracle@rac1 ~]$ echo
$FILE_EDITION
run
[oracle@rac1 ~]$[oracle@rac1 ~]$ cd /u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/admin/scripts
[oracle@rac1 scripts]$
[oracle@rac1 scripts]$
ll
adpreclone.pl
-rwx------ 1 oracle
dbaerp 17847 Mar 23 14:40 adpreclone.pl
[oracle@rac1 scripts]$
[oracle@rac1 scripts]$
./adpreclone.pl
appsTier
[oracle@rac1 scripts]$
./adpreclone.pl appsTier
Copyright (c) 2011 Oracle
Corporation
Redwood Shores,
California, USA
Oracle E-Business Suite
Rapid Clone
Version 12.2
adpreclone Version
120.31.12020000.3
Enter the Weblogic
AdminServer password : weblogicr12
Checking the status of the Oracle WebLogic
Administration Server....
Running perl
/u01/apps/CLONE/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl
ebs-get-serverstatus -contextfile=/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml
-servername=AdminServer -promptmsg=hide
The Oracle WebLogic
Administration Server is up.
Running:
perl
/u01/apps/CLONE/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl
java=/u01/apps/CLONE/fs1/EBSapps/comn/util/jdk32 mode=stage
stage=/u01/apps/CLONE/fs1/EBSapps/comn/clone component=appsTier method=
appctx=/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml
showProgress
Beginning application
tier Stage - Thu Mar 23 15:33:46 2017
/u01/apps/CLONE/fs1/EBSapps/comn/util/jdk32/bin/java
-Xmx600M -DCONTEXT_VALIDATED=false
-Doracle.installer.oui_loc=/oui -classpath
/u01/apps/CLONE/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/apps/CLONE/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/apps/CLONE/fs1/EBSapps/comn/java/classes:/u01/apps/CLONE/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/apps/CLONE/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/apps/CLONE/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/apps/CLONE/fs1/FMW_Home/webtier/oui/jlib/srvm.jar:/u01/apps/CLONE/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/apps/CLONE/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/apps/CLONE/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml -stage
/u01/apps/CLONE/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/admin/log/StageAppsTier_03231533.log
\
20% completed
Completed Stage...
Thu Mar 23 15:39:03
2017
[oracle@rac1 scripts]$
[oracle@rac1 scripts]$
cd
/u01/apps/CLONE/fs1/
[oracle@rac1 fs1]$ ll
total 12
drwxr-xr-x 5 oracle dbaerp 4096 Feb 16 14:44 EBSapps
drwxr-x--- 11 oracle
dbaerp 4096 Mar 23 14:43 FMW_Home
drwxr-xr-x 3 oracle dbaerp 4096 Mar 23 14:32 inst
[oracle@rac1 appl]$
[oracle@rac1 appl]$ echo
$FILE_EDITION
run
--- Shutdown Application Tier ---
[oracle@rac1 appl]$
[oracle@rac1 appl]$ adstpall.sh
apps/apps
You are running
adstpall.sh version 120.22.12020000.5
Enter the WebLogic
Server password: weblogicr12
. . . .
. . . .
. . . .
. . . .
All enabled services
on this node are stopped.
adstpall.sh:Exiting
with status 0
adstpall.sh: check the
logfile
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/logs/appl/admin/log/adstpall.log for
more information ...
[oracle@rac1 appl]$
[oracle@rac1 appl]$
[oracle@rac1 appl]$ ps -ef |
grep FNDLIBR -c
1
[oracle@rac1 appl]$
Copy EBSapps form Run-FS
to Patch-FS
[oracle@rac1 fs1]$
[oracle@rac1 fs1]$ cp -R
EBSapps/ /u01/apps/CLONE/fs2/
[oracle@rac1 bin]$ cd
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin
[oracle@rac1 bin]$ ll
total 224
-rw-r--r-- 1 oracle
dbaerp 168 Mar 23 15:42 03231432.log
-rwxr-xr-x 1 oracle
dbaerp 7413 Mar 23 15:42 adaddnode.pl
-rwxr-xr-x 1 oracle dbaerp
47025 Mar 23 15:42 adcfgclone.pl
-rwxr-xr-x 1 oracle
dbaerp 5101 Mar 23 15:42 adchkutl.sh
-rwxr-xr-x 1 oracle
dbaerp 37265 Mar 23 15:42 adclonectx.pl
-rwxr-xr-x 1 oracle
dbaerp 76411 Mar 23 15:42 adclone.pl
-rw-r--r-- 1 oracle
dbaerp 33329 Mar 23 15:42 CloneContext_0323143205.log
[oracle@rac1 bin]$
[oracle@rac1 appl]$ echo
$FILE_EDITION
run
[oracle@rac1 appl]$
[oracle@rac1 ~]$ cd
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/
[oracle@rac1 bin]$ ll
total 224
-rw-r--r-- 1 oracle
dbaerp 168 Mar 23 15:42 03231432.log
-rwxr-xr-x 1 oracle
dbaerp 7413 Mar 23 15:42 adaddnode.pl
-rwxr-xr-x 1 oracle
dbaerp 47025 Mar 23 15:42 adcfgclone.pl
-rwxr-xr-x 1 oracle
dbaerp 5101 Mar 23 15:42 adchkutl.sh
-rwxr-xr-x 1 oracle
dbaerp 37265 Mar 23 15:42 adclonectx.pl
-rwxr-xr-x 1 oracle
dbaerp 76411 Mar 23 15:42 adclone.pl
-rw-r--r-- 1 oracle
dbaerp 33329 Mar 23 15:42 CloneContext_0323143205.log
[oracle@rac1 bin]$
[oracle@rac1 bin]$ ./adcfgclone.pl
appsTier
Copyright (c) 2011 Oracle
Corporation
Redwood Shores,
California, USA
Oracle E-Business Suite
Rapid Clone
Version 12.2
adcfgclone Version
120.63.12020000.7
Enter the APPS
password : apps
Enter the Weblogic
AdminServer password : weblogicr12
Running:
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath
/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/java
oracle.apps.ad.clone.util.OPWrapper
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath
/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/java
oracle.apps.ad.clone.util.OPWrapper
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource
Do you want to add a
node (yes/no) [no] : Press Enter
Running:
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -cp
/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/java:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar
oracle.apps.ad.context.CloneContext -e /u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_13146.lst -stage
/u01/apps/CLONE/fs2/EBSapps/comn/clone
2> /tmp/adcfgclone_13146.err; echo $? > /tmp/adcfgclone_13146.res
Log file located at
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/CloneContext_0323160310.log
Target System File Edition type [run] : patch
Location of Run File System context file : /u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml
Provide the values
required for creation of the new APPL_TOP Context file.
Target System Fusion
Middleware Home set to /u01/apps/CLONE/fs2/FMW_Home
Target System Web
Oracle Home set to /u01/apps/CLONE/fs2/FMW_Home/webtier
Target System Appl TOP
set to /u01/apps/CLONE/fs2/EBSapps/appl
Target System COMMON
TOP set to /u01/apps/CLONE/fs2/EBSapps/comn
Target System Instance
Top set to /u01/apps/CLONE/fs2/inst/apps/CLONE_rac1
Target System Port
Pool [0-99] : 10
Patch file system
should have different port pool than Run file system..
Target System Port
Pool [0-99] : 11
Checking the port pool
11
done: Port Pool 11 is
free
Report file located at
/u01/apps/CLONE/fs2/inst/apps/CLONE_rac1/admin/out/portpool.lst
Complete port
information available at /u01/apps/CLONE/fs2/inst/apps/CLONE_rac1/admin/out/portpool.lst
UTL_FILE_DIR on
database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3.
/u01/db_CLONE/12.1.0/appsutil/outbound/CLONE_rac1
4. /usr/tmp
Choose a value which
will be set as APPLPTMP value on the target node [1] : Press Enter
Creating the new
APPL_TOP Context file from :
/u01/apps/CLONE/fs2/EBSapps/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP
context file has been created :
/u01/apps/CLONE/fs2/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml
Log file located at /u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/CloneContext_0323160310.log
Check Clone Context
logfile /u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/CloneContext_0323160310.log
for details.
Running Rapid Clone
with command:
Running:
perl
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/adclone.pl
java=/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../jre mode=apply
stage=/u01/apps/CLONE/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM
appctxtg=/u01/apps/CLONE/fs2/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml
showProgress contextValidated=true
FMW Pre-requisite
check log file location :
/u01/apps/CLONE/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running:
/u01/apps/CLONE/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath
/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/java
oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e
/u01/apps/CLONE/fs2/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml -stage
/u01/apps/CLONE/fs2/EBSapps/comn/clone -log
/u01/apps/CLONE/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application
tier Apply - Thu Mar 23 16:05:53 2017
/u01/apps/CLONE/fs2/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=true
-Doracle.installer.oui_loc=/oui -classpath
/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/java:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/oui/srvm.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/apps/CLONE/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/apps/CLONE/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e
/u01/apps/CLONE/fs2/inst/apps/CLONE_rac1/appl/admin/CLONE_rac1.xml -stage
/u01/apps/CLONE/fs2/EBSapps/comn/clone
-showProgress –noprompt
Log file located at
/u01/apps/CLONE/fs2/inst/apps/CLONE_rac1/admin/log/ApplyAppsTier_03231605.log
\
100% completed
Completed Apply...
Thu Mar 23 16:01:04
2017
[oracle@rac1 bin]$
[oracle@rac1 bin]$ echo
$FILE_EDITION
Run
[oracle@rac1 bin]$
[oracle@rac1 bin]$ adstrtal.sh
apps/apps
You are running
adstrtal.sh version 120.24.12020000.6
Enter the WebLogic
Server password:weblogicr12
. . . .
. . . .
. . . .
. . . .
All enabled services
for this node are started.
adstrtal.sh: Exiting
with status 0
adstrtal.sh: check the
logfile
/u01/apps/CLONE/fs1/inst/apps/CLONE_rac1/logs/appl/admin/log/adstrtal.log for
more information ...
[oracle@rac1 bin]$
Disk storage size after cloning both FS.
[root@rac1 CLONE]#
Disk storage size after cloning both FS.
[root@rac1 ~]#
[root@rac1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 4.8G 0 4.8G 0% /dev
tmpfs 3.0G 13M 3.0G 1% /dev/shm
tmpfs 4.8G 9.9M 4.8G 1% /run
tmpfs 4.8G 0 4.8G 0% /sys/fs/cgroup
/dev/mapper/ol-root 100G 7.1G 93G 8% /
/dev/mapper/ol-tmp 30G 42M 30G 1% /tmp
/dev/mapper/ol-u01 839G 154G 686G 19% /u01
/dev/sda1 1014M 241M 774M 24% /boot
vmhgfs-fuse 489G 303G 186G 63% /mnt/hgfs
tmpfs 968M 28K 968M 1% /run/user/0
/dev/sr0 4.6G 4.6G 0 100% /run/media/root/OL-7.9 Server.x86_64
[root@rac1 ~]# cd /u01
[root@rac1 u01]# du -sh *
65G apps
89G db_CLONE
0 db_PROD
33M oracle
[root@rac1 u01]# cd /u01/apps/CLONE/
[root@rac1 CLONE]# du -sh *
33G fs1
32G fs2
220K fs_ne
URL find for EBS using grep
[oracle@rac1 bin]$
[oracle@rac1 bin]$ grep login $CONTEXT_FILE
<login_page oa_var="s_login_page">http://rac1.dell.com:8010/OA_HTML/AppsLogin</login_page>
[oracle@rac1 bin]$
[oracle@rac1 bin]$
[oracle@rac1 bin]$ grep login $CONTEXT_FILE
<login_page oa_var="s_login_page">http://rac1.dell.com:8010/OA_HTML/AppsLogin</login_page>
[oracle@rac1 bin]$
[oracle@rac1 bin]$ sqlplus
apps/apps
SQL*Plus: Release
10.1.0.5.0 - Production on Sat Mar 25 16:42:38 2017
Copyright (c) 1982,
2005, Oracle. All rights reserved.
Connected to:
Oracle Database 12c
Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Advanced Analytics and Real Application Testing options
SQL> select
home_url from icx_parameters;
HOME_URL
--------------------------------------------------------------------------------
http://rac1.dell.com:8010/OA_HTML/AppsLogin
SQL>
Check DBA security Policy:
SQL> select count(*) from DBA_POLICIES; --5171
SQL>
SQL> select POLICY_GROUP, POLICY_NAME, OBJECT_NAME, PACKAGE, FUNCTION from DBA_POLICIES; --security policies in DB
SQL>
To check component list and last applied bundel patch connect
SQL> select comp_id,comp_name,version,status from dba_registry;
SQL>
SQL> select description from dba_registry_sqlpatch;
SQL> select * from ad_trackable_entities where abbreviation in('ad','txk','atg_pf','fnd','fwk','au','gl','per','xdo','cc_pf'); -- Codelevel check
SQL> SELECT value AS db_charset FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET'; -- Database characterset
DB_CHARSET
----------------------------------------------------------------
AR8MSWIN1256
SQL>
SQL> SELECT value AS db_ncharset FROM nls_database_parameters WHERE parameter = 'NLS_NCHAR_CHARACTERSET'; -- Database characterset
DB_NCHARSET
----------------------------------------------------------------
AL16UTF16
SQL>
Check Archivelog Mode:
SQL> select LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database;
LOG_MODE FLASHBACK_ON FORCE_LOGGING
------------ ------------------ ---------------------------------------
ARCHIVELOG YES YES
SQL>
SQL> SELECT ad_zd.get_edition_type from dual; -- Current File system session
GET_EDITION_TYPE
--------------------------------------------------------------------------------
RUN
SQL>
SQL> SELECT ad_zd.get_edition_type from dual; -- Current File system session & adop apply patch check
GET_EDITION_TYPE
--------------------------------------------------------------------------------
PATCH
SQL>
Hope this article helps those who are looking for cloning for
EBS R12.2
Thanks for Reading
Regards,
Mohammed Areefuddin.
No comments:
Post a Comment