Saturday, March 25, 2017

RAPID CLONE FOR EBS R12.2

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


--- Perform full Cold Backup ---

Database backup
[root@rac1 ~]# cd /u01
[root@rac1 u01]# tar –cvzf db.tar.gz db_PROD
[root@rac1 u01]#

Application Backup
[root@rac1 ~]# cd /u01
[root@rac1 u01]# tar -cvzf apps.tar.gz apps
[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
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 ~]#
==============================================================================================================
Apply latest etcc patch Patch 17537119: EBS Technology Codelevel Checker(ETCC)
latest opatch   6880880

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 ~]$
[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 ~]#
[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
[root@rac1 CLONE]#

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]$ 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.

Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)