How to Clone the Oracle Database using Manual Cold Backup

STEP 1:Create a control file from source instance env

SQL > alter database backup controlfile to trace;

Control File Script:

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "qbay11g" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 240
    MAXINSTANCES 1
    MAXLOGHISTORY 113
LOGFILE
  GROUP 1 '/u03/oracle11g/oracle11g/oradata/qbay11g/redo01.log'  SIZE 50M,
  GROUP 2 '/u03/oracle11g/oracle11g/oradata/qbay11g/redo02.log'  SIZE 50M,
  GROUP 3 '/u03/oracle11g/oracle11g/oradata/qbay11g/redo03.log'  SIZE 50M
DATAFILE
  '/u03/oracle11g/oracle11g/oradata/qbay11g/system01.dbf',
  '/u03/oracle11g/oracle11g/oradata/qbay11g/undotbs01.dbf',
  '/u03/oracle11g/oracle11g/oradata/qbay11g/sysaux01.dbf',
  '/u03/oracle11g/oracle11g/oradata/qbay11g/users01.dbf'
;
# Recovery is required if any of the datafiles are restored
# backups, or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;

STEP 2: Shutdown the Source database

SQL>shutdown immediate;

STEP 3: Copy all data files into the new directories on the new server.

You may change the file names if you want, but you must edit the controlfile to reflect the new data files names on the new server

Example:

scp -r  /u01/oracle/oradata  oracle@targetdatabse.com:/u01/oracle/oradata

STEP 4: Copy and Edit the Control file – Using the output syntax from STEP 1, modify the controlfile creation script by changing the following:

Old:

CREATE CONTROLFILE REUSE DATABASE "qbay11g" NORESETLOGS

New:

CREATE CONTROLFILE SET DATABASE "qborcl" RESETLOGS

STEP 5: Remove the "recover database" and "alter database open" syntax

# Recovery is required if any of the datafiles are restored

# backups, or if the last shutdown was not normal or immediate.

RECOVER DATABASE

# Database can now be opened normally.

ALTER DATABASE OPEN;

STEP 6: Re-names of the data files names that have changed

Save as db_create_controlfile.sql.

Old:

DATAFILE

  '/u03/oracle11g/oracle11g/oradata/qbay11g/system01.dbf',

  '/u03/oracle11g/oracle11g/oradata/qbay11g/undotbs01.dbf',

  '/u03/oracle11g/oracle11g/oradata/qbay11g/sysaux01.dbf',

  '/u03/oracle11g/oracle11g/oradata/qbay11g/users01.dbf'

New:

DATAFILE

  '/u02/oracle11g/oracle11g/oradata/qborcl/system01.dbf',

  '/u02/oracle11g/oracle11g/oradata/qborcl/undotbs01.dbf',

  '/u02/oracle11g/oracle11g/oradata/qborcl/sysaux01.dbf',

  '/u02/oracle11g/oracle11g/oradata/qborcl/users01.dbf'

STEP 7: Create the bdump, udump and cdump directories

cd $DBA/admin

mkdir newlsq

cd newlsq

mkdir bdump

mkdir udump

mkdir cdump

mkdir pfile

STEP 8: Copy-over the old init.ora file

rcp $DBA/admin/source/pfile/*.ora targethost:/u01/oracle/admin/target/pfile

STEP 9: Start the new database

SQL> startup mount pfile=initqborcl.ora;

SQL>@db_create_controlfile.sql

STEP 10: Open the new Cloned database

SQL> alter database open resetlogs;

                    ****ALL THE BEST****

Oracle EBS R12.2.7 Installation with Step by Step

High level Steps Involved to do the R12.2.7 upgrade steps are:
1.Checked Pre requestions for R12.2.7
2.Run ETCC in both database tier and Application tier to get the list of required patches and apply.
3.Upgrade to  AD and TXK Delta 10
4.Apply the R12.2.7 upgrade patch
5.FS_CLONE for filesystem cloning
6.Apply the Help patch.

1.Checked Pre requestions for R12.2.7

In Release 12.2.0 and higher, patching is performed by running the new adop (AD Online Patching) utility. You must use adop instead of the adpatch utility that was provided in previous releases

Download and unzip all the patches to the default Patch Top location for R12.2 ($APPL_TOP_NE/../patch)

If your Oracle E-Business Suite instance is currently on Database version 11.2.0.3, then you should now upgrade to Database 11.2.0.4 or 12.1.0.2 before proceeding with next steps, by following process documented in the oracle


Note: Database desupport schedules have important operational and planning implications for Oracle E-Business Suite environments. Oracle recommends that you review the following document that details the latest database support policies and desupport schedules: My Oracle Support Knowledge Document 742060.1, Release Schedule of Current Database Patch Sets

2.Run ETCC in both database tier and Application tier to get the list of required patches and apply.

EBS Technology Codelevel Checker (ETCC)

ETCC can be downloaded via Patch 17537119 from My Oracle Support

Download the Patch 17537119
p17537119_R12_GENERIC.zip

Unzip p17537119_R12_GENERIC.zip

The two scripts that make up ETCC are:

checkDBpatch.sh

This is the Database EBS Technology Codelevel Checker (DB-ETCC), which determines if all the needed bugfixes exist in the specified database ORACLE_HOME.

./checkDBpatch.sh

checkMTpatch.sh 

 This is the Application Tier EBS Technology Codelevel Checker (MT-ETCC), which determines if all the needed bugfixes exist in the application tier file system.

./checkMTpatch.sh


Note: This patch verifies the missing bugfixes which is not applied for db and middle tiers

For DB Node :

copy all files in the patch directory
cd $PATCH_TOP/17537119

./checkDBpatch.sh

Apply the patches using opatch


Example:

export PATH=$PATH:$ORACLE_HOME/OPatch

To Check the patch:
opatch lsinventory | grep 19908836

cd 18793246

opatch apply

For APP Node :
./checkMTpatch.sh


=================================
PATCH RECOMMENDATION SUMMARY
=================================

Oracle Forms and Reports 10.1.2.3.0
---------------------------------------------
  Patch 25768948
    - Filename: p25768948_101232_LINUX.zip


Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
------------------------------------------------------------------------------
  Patch 17428617
    - Filename: p17428617_111190_Generic.zip

  Patch 24606362
    - Filename: p24606362_111190_Generic.zip

  Patch 24843064
    - Filename: p24843064_111190_Generic.zip

Oracle WebLogic Server (WLS) 10.3.6.0.12
---------------------------------------------------------
  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]
    - Filename: p23743997_1036_Generic.zip

  Patch 25333306 [SU Patch [SUY4]]
    - Filename: p25333306_1036_Generic.zip


Apply the required patches and rerun this script.

+--------------------------------------------------------------------------------------------------------+
A consolidated zip file with the required application tier patches is
available on My Oracle Support via:

  Patch 26328262
    - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2017

+--------------------------------------------------------------------------------------------------------+
[WARNING]  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] is missing.
This is the recommended minimum WLS patch set.
You should install it now, and then rerun this script to check for any
further fixes available.
+--------------------------------------------------------------------------------------------------------+

For APPS Tier Node :

Connecting to database.
Database connection successful.


Oracle Forms and Reports
-------------------------

1.unzip Patch file
2.set Oracle home
  export ORACLE_HOME=/u02/oracle/TST/fs1/EBSapps/10.1.2.
3.set path
  export PATH=$ORACLE_HOME/OPatch:$PATH
4.opatch lsinventory|grep 25768948
5.cd 25768948
6.opatch apply


Oracle Fusion Middleware (FMW) - oracle_common
------------------------------------------------

1.unzip Patch file
2.set Oracle home
  export ORACLE_HOME=/u02/oracle/TST/fs1/FMW_Home/oracle_common
3.set path
  export PATH=$ORACLE_HOME/OPatch:$PATH
4.opatch lsinventory|grep 17428617
5.cd 17428617
6.cd oui
7.opatch apply

Oracle WebLogic Server (WLS)
------------------------------------
1. copy file 23743997 to /u02/oracle/TST/fs1/FMW_Home/util/bsu/cache_dir
2. unzip file (23743997)
3. check the .jar file
    ls -ltr *.jar
4. cd  /u02/oracle/TST/fs1/FMW_Home/util/bsu

5. check the Display
    echo$DISPLAY
    echo$DISPLAY=:1:0

6 To apply the Patch
   . ./bsu.sh -install -patch_download_dir=/u01/oracle/CRP/fs1/FMW_Home/utils/bsu/
   cache_dir -patchlist=EJUW - prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3

7.  To apply patches, first you have to apply patch number 23743997 but you may have conflict warning with the previous patches which has older PSU patches because 23743997 patch number is PSU 10.3.6.0.12 patch

we removed the below patches using following commands
 Delete the files - YSAP,BLTC,1LRI,VKXF,2GYW,CWGT,FCX7
   ./bsu.sh -remove -patchlist=Y5AP -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=BLTC -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=1LRI -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=VKXF -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=2GYW -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=CWGT -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose
   ./bsu.sh -remove -patchlist=FCX7 -prod_dir=/u01/oracle/CRP/fs1/FMW_Home/wlserver_10.3 –verbose

8. Once again apply
  ./bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir - patchlist=EJUW -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3

9. Run ETCC again to get the patch list

    24608998 [QMJP]
    13729611 [Z9PC]
    17319481 [9KCT]
    19259028 [KRDE]
    25804598 [EQDE]

9. Download the above patch list

10.Unzip patches.

11.To install the the patches using following commands

    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=QMJP -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=Z9PC -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=9KCT -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=KRDE -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3
    bsu.sh -install -patch_download_dir=/u02/oracle/TST/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=EQDE -prod_dir=/u02/oracle/TST/fs1/FMW_Home/wlserver_10.3


12. To check  the MTpatchlist again run the following

      ./checkMTpatch.sh

   Now you should get the message as "All required patches are present"

Set Database Parameter (Conditional) 

Oracle Database 12c Release 1 uses cost based optimization. If you are using Oracle Database 12.1.0.2, the following optimizer parameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter.

[appltst@qb]$ #optimizer_adaptive_features=false

You can verify the parameter was set correctly by running the following command, which should return the value FALSE:
SQL>show parameter optimizer_adaptive_features

3.Upgrade to  AD and TXK Delta 10

Note: This step is applicable only for new installation customers and customers upgrading from Oracle E-Business Suite Release 12.2.2 to Release 12.2.7

If you haven't already applied Consolidated Seed Table Upgrade Patch 17204589:12.2.0, then you must first apply Patch 17204589:12.2.0 on the run file system.

Note: If you have upgraded to Release 12.2.0 using Consolidated Upgrade Patch 24690520:12.2.0 (CUP8) or Patch 22742071:12.2.0 (CUP7) or
Patch 19796566:12.2.0 (CUP6) or Patch 18007406:12.2.0 (CUP5) or Patch 17197281:12.2.0 (CUP4), then you can skip this step.

1. Stop all application tier services on the run file system.

sh $ADMIN_SCRIPTS_HOME/adstpall.sh


2. Start up only the Oracle Weblogic Admin Server on the run file system

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

3. Apply the consolidated seed table upgrade Patch 17204589:12.2.0 on the run file system using adop hotpatch mode.
$ adop phase=apply patches=17204589 hotpatch=yes

Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode.
 $ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes


4. Start up all application tier services.

$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh


Section 6: Apply the Latest AD and TXK Delta Release Update Packs

Note: Follow this Oracle Document 1617461.1


Download and unzip the following patches:
Patch 25820806 (R12.AD.C.Delta.10)
Patch 25828573 (R12.TXK.C.Delta.10)
Patch 26720905:R12.AD.C
Patch 19259764:R12.FND.C.

All Downloaded files are moved to /u01/oracle/CRP/fs_ne/EBSapps/Patch
Unzip the patch files.
online patches apply

$ adop phase=prepare
$ adop phase=apply patches=25820806,26720905 merge=yes
$ adop phase=apply patches=25828573
$ adop phase=apply patches=19259764
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=finalize
$ adop phase=cutover
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
$ adop phase=fs_clone

Critical AD Patches

Patch 24591000:R12.AD.C
Patch 26482811:R12.AD.C

Critical TXK Patches

Patch 26400116:R12.TXK.C
Patch 26720231:R12.TXK.C
Patch 25994411:R12.TXK.C

online patches apply

$ adop phase=prepare
$ adop phase=apply patches=24591000
$ adop phase=apply patches=26482811
$ adop phase=apply patches=26400116
$ adop phase=apply patches=26720231
$ adop phase=apply patches=25994411
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=finalize
$ adop phase=cutover
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
$ adop phase=fs_clone

4.Apply the R12.2.7 upgrade patch

1. Source the run edition applications environment

UNIX:
$ . <INSTALL_BASE>/EBSapps.env run

2. Start an online patching cycle.
$ adop phase=prepare

3. Apply Oracle E-Business Suite Release 12.2.7 Patch 24690690. UNIX:
$ adop phase=apply patches=24690690

4. Complete the online patching cycle by running the following commands in the order shown.

 UNIX:
$ adop phase=finalize 
$ adop phase=cutover 
$ . <INSTALL_BASE>/EBSapps.env run 
$ adop phase=cleanup

5.FS_CLONE for filesystem cloning

Synchronize file systems Synchronize the file systems using the command shown below.
This action will copy the new run edition code and configuration to the other file system,
to help the next online patching cycle complete faster.


$ adop phase=fs_clone

6.Post-Update Steps

Note: If you are upgrading from Release 11i, 12.0.x or 12.1.x to Release 12.2.7, then you must continue with 12.2.0 post upgrade steps mentioned in the Upgrade guides before performing the below steps

$ adop phase=apply patches=24690800 hotpatch=yes

Health checking application

http://<hostname>:port/OA_HTML/OA.jsp


**All the Best**

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
 at java.util.HashMap.createEntry(HashMap.java:897)
 at java.util.HashMap.addEntry(HashMap.java:884)
 at java.util.HashMap.put(HashMap.java:505)
 at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:778)
 at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)
 at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)
 at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)
 at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDetails(PatchCatalogHelper.java:695)
 at com.bea.plateng.patch.dao.cat.Version.getPatchDetails(Version.java:41)
 at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getFilteredPatchDetailMap(PatchCatalogHelper.java:1202)
 at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDetails(PatchCatalogHelper.java:1398)
 at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getEveryPatchDetail(PatchCatalogHelper.java:767)
 at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1622)
 at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)
 at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)
 at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)
 at com.bea.plateng.patch.Patch.main(Patch.java:281)


Solution:

cd $MW_Home/utils/bsu

open bsu.sh

step1:

MEM_ARGS="-Xms256m -Xmx512m"
to
MEM_ARGS="-Xms1024m -Xmx1024m"

step2:

"$JAVA_HOME/bin/java" -Xms2048m -Xmx2048m -jar patch-client.jar $*

ORA-03113: end-of-file on communication channel

Error:

SQL> startup;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  2932632 bytes
Variable Size             335544424 bytes
Database Buffers          729808896 bytes
Redo Buffers                5455872 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7900
Session ID: 1 Serial number: 63172

Cause:

The connection between Client and Server process was broken

Solution:

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  2932632 bytes
Variable Size             335544424 bytes
Database Buffers          729808896 bytes
Redo Buffers                5455872 bytes

SQL> alter database mount;
Database altered.

SQL> alter database clear unarchived logfile group 1;
Database altered.

SQL> alter database clear unarchived logfile group 2;
Database altered.

SQL> alter database clear unarchived logfile group 3;
Database altered.

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.


SQL> startup;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  2932632 bytes
Variable Size             335544424 bytes
Database Buffers          729808896 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.

**************Database Opened****************

Create APPS Read Only User in Oracle

Step1:

[oravis@qb ~]$ sqlplus / as sysdba

SQL> Create user db_admin identified by db_admin

         default tablespace APPS_TS_TX_DATA

         temporary tablespace temp

         quota 0M on APPS_TS_TX_DATA;

         User created.

Step2:

SQL>  Create role r_role;

          Grant create session to r_role;

          Grant connect to r_role;

          Grant select any table to r_role;

          Grant execute any procedure to r_role;

          Grant create trigger to r_role;

          Role created.

Step3:

SQL> Grant r_role to qlik;

         Grant succeeded.

Step4:

SQL> conn db_admin/db_admin;

          Connected.

Step5:

SQL>  Create trigger rlogin_trigger

           After logon on db_admin.schema

           Begin

           Execute immediate 'Alter session set current_schema = apps';

           End;  

           Trigger created.

Step6:

SQL>  Revoke create trigger from r_role;

           Revoke succeeded.

  

  

         

Oracle EBS R12.2.6 Cloning with Step by Step

DB Tier Cloning

1. Prepare source node for Cloning

1.1 Prepare source node for  Database Cloning

cd /u01/oracle/CRP/12.1.0/appsutil/scripts/CRP_qb

[orauat@qb scripts]$ perl adpreclone.pl dbTier

1.2 Prepare Souce Node for Application Cloning

Run adpreclone.pl from RUN File System

cd /u02/oracle/CRP/fs1/inst/apps/CRP_qb/admin/scripts

[appluat@qb scripts]$ adpreclone.pl appsTier

                     Copyright (c) 2011, 2014 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.20

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server....

Running perl /u01/oracle/UAT/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisi onEBS.pl ebs-get-serverstatus - contextfile=/u01/oracle/UAT/fs1/inst/apps/UAT_qbuat//appl/admin/
/UAT_qb.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

Running:

perl /u01/oracle/UAT/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/oracle/UAT/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/oracle/UAT/fs1/EBSapps/comn /clone component=appsTier method appctx=/u01/oracle/UAT/fs1/inst/apps/UAT_qbuat/appl/admin/UAT_qb.xml showProgress

Setting the wls environment

Beginning application tier Stage - Thu Apr  6 12:53:24 2017

/u01/oracle/UAT/fs1/EBSapps/comn/util/jdk64/bin/java-Xmx600M-DCONTEXT_VALIDATED_ =false-Doracle.installer.oui_loc=/oui-classpath
/lib/xmlparserv2.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/oracle/UAT/fs1/EBSapps/comn/java/classes:/u01/oracle/UAT/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/../Oracle_EBS-/app1/oui/jlib/srvm.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/oracle/UAT/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/UAT/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jaroracle.apps.ad.clone.e/u01/oracle/UAT/fs1/inst/apps/UAT_qbuat/appl/admin/UAT_qb.xml -stage /u01/oracle/UAT/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg  

Log file located at /u01/oracle/UAT/fs1/inst/apps/UAT_qb/admin/log/clone/StageAppsTier_04061253.log                       

  \     20% completed

Completed Stage...

Thu Apr  6 12:59:21 2017

[appluat@qb scripts]$

2. Shutdown Application and DB

Application:

[appluat@qb ]$ cd $ADMIN_SCRIPTS_HOME
[appluat@qb scripts]$ sh adstpall.sh 

Database:

[orauat@qb ~]$ sqlplus / as sysdba

SQL> shutdown immediate; 

3. Copy db directory from source to target

scp -r /u01/oracle/CRP/db <targetIP>:/u01/oracle/UAT

4. Switch user who own the db binary file system

su - orauat

5. Configure target DB Tier

[orauat@qb bin]$ cd /u01/oracle/UAT/12.1.0/appsutil/clone/bin

[orauat@qb bin]$ perl 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 :

Running: Context clone...

Log file located at /u01/oracle/UAT/12.1.0/appsutil/clone/bin/CloneContext_0406101541.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [qb] :

Target Instance is RAC (y/n) [n] :

Target System Database SID : UAT

Target System Base Directory :  /u01/oracle/UAT

Target System utl_file_dir Directory List : /tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/u01/oracle/UAT/data] :

Target System RDBMS ORACLE_HOME Directory [/u01/oracle/UAT/12.1.0] :

Do you want to preserve the Display [null] (y/n)  : n

Target System Display [qb:0.0] :

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] : 11

Checking the port pool 11

done: Port Pool 11 is free

Report file located at /u01/oracle/UAT/12.1.0/appsutil/temp/portpool.lst

The new database context file has been created :

  /u01/oracle/UAT/12.1.0/appsutil/UAT_qb.xml

Check Clone Context logfile /u01/oracle/UAT/12.1.0/appsutil/clone/bin/CloneContext_0406101541.log for details.

Running Rapid Clone with command:

Running:

perl /u01/oracle/UAT/12.1.0/appsutil/clone/bin/adclone.pl java=/u01/oracle/UAT/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/u01/oracle/UAT/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/oracle/UAT/12.1.0/appsutil/UAT_qb.xml showProgress contextValidated=true

Beginning database tier Apply - Thu Apr  6 10:16:12 2017

/u01/oracle/UAT/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/oracle/UAT/12.1.0/oui -classpath /u01/oracle/UAT/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/oracle/UAT/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/u01/oracle/UAT/12.1.0/appsutil/clone/jlib/java:/u01/oracle/UAT/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/oracle/UAT/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/oracle/UAT/12.1.0/appsutil/clone/jlib/oui/share.jar:/u01/oracle/UAT/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/u01/oracle/UAT/12.1.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /u01/oracle/UAT/ 12.1.0/appsutil/UAT_qb.xml -stage /u01/oracle/UAT/12.1.0/appsutil/clone   

-showProgress                     

APPS Password : Log file located at /u01/oracle/UAT/12.1.0/appsutil/log/UAT_qb /ApplyDBTier_04061016.log

  \     15% completed

Completed Apply...

Thu Apr  6 10:20:54 2017

Starting database listener for UAT:

Running:

/u01/oracle/UAT/12.1.0/appsutil/scripts/UAT_qb/addlnctl.sh start UAT

Logfile: /u01/oracle/UAT/12.1.0/appsutil/log/UAT_qb/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process UAT ...

Listener UAT has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/oracle/UAT/12.1.0/appsutil/log/UAT_qb/addlnctl.txt for more information ...

Do you want to change the password for all EBS Schemas? (y/n) [n]) :

Do you want to change the password for sysadmin user? (y/n) [n]) :

Do you want to change the apps password? (y/n) [n]) :

Do you want to change the sys and system passwords? (y/n) [n]) :

Running ETCC to check status of DB technology patches...

          +==============================================+

                      Copyright (c) 2005, 2016 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/oracle/UAT/12.1.0/appsutil/UAT_qb.xml

Starting Database EBS Technology Codelevel Checker, Version 120.40

Thu Apr  6 10:22:10 EAT 2017

Log file for this session : /u01/oracle/UAT/12.1.0/appsutil/etcc/checkDBpatch_26387.log

Bugfix XML file version: 120.0.12020000.33

This file will be used for identifying missing bugfixes.

Mapping XML file version: 120.0.12020000.6

This file will be used for mapping bugfixes to patches.

[WARNING] DB-ETCC: Bugfix XML file (/u01/oracle/UAT/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 UAT is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

- APPS schema : APPS

- APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

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

All the required one-off bugfixes are present in Database ORACLE_HOME.

Stored Technology Codelevel Checker results in the database UAT successfully.

Finished prerequisite patch testing : Thu Apr  6 10:22:22 EAT 2017

Log file for this session: /u01/oracle/UAT/12.1.0/appsutil/etcc/checkDBpatch_26387.log

Apps Tier Cloning

1. Copy EBSapps directory from source to target (no need to copy FMW_Home and inst Directories)

Create  a directory 

mkdir -p /u01/oracle/UAT/fs1/

mkdir -p /u01/oracle/UAT/fs2/

mkdir -p /u01/oracle/UAT/fs_ne/

Copy EBSapps directory from source to target

scp -r /u01/oracle/CRP/fs1/EBSapps <targetIP>:/u01/oracle/UAT/fs1

2.After finishing the copy CONFIGURE TARGET RUN FILE SYSTEM

Go to clone directory

cd /u01/oracle/UAT/fs1/EBSapps/comn/clone/bin

[appluat@qb bin]$ perl adcfgclone.pl appsTier

                     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

                *********************************************************************************

       In AD-TXK Delta 7, we recommend you clone the run and patch

       file systems in a single operation using the 'dualfs' option.

       Separate cloning of the run and patch file systems will be deprecated

                *********************************************************************************

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone...

Log file located at /u01/oracle/UAT/fs1/EBSapps/comn/clone/bin/CloneContext_0406111013.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) [qb] :

Target System Database SID : UAT

Target System Database Server Node [qb] :

Target System Database Domain Name [qb.com] :

Target System Base Directory : /u01/oracle/UAT

Target System Base Directory set to /u01/oracle/UAT

Target System Current File System Base set to /u01/oracle/UAT/fs1

Target System Other File System Base set to /u01/oracle/UAT/fs2

Target System Fusion Middleware Home set to /u01/oracle/UAT/fs1/FMW_Home

Target System Web Oracle Home set to /u01/oracle/UAT/fs1/FMW_Home/webtier

Target System Appl TOP set to /u01/oracle/UAT/fs1/EBSapps/appl

Target System COMMON TOP set to /u01/oracle/UAT/fs1/EBSapps/comn

Target System Instance Home Directory [/u01/oracle/UAT] :

Target System Instance Top set to /u01/oracle/UAT/fs1/inst/apps/UAT_qb

Do you want to preserve the Display [qbcrp:0.0] (y/n)  : n

Target System Display [qb:0.0] :

Target System Root Service [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] :

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] : 11

Checking the port pool 11

done: Port Pool 11 is free

Report file located at /u01/oracle/UAT/fs1/inst/apps/UAT_qb/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /tmp

3. /u01/oracle/UAT/12.1.0/appsutil/outbound/UAT_qb

4. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] :

The new APPL_TOP context file has been created :

/u01/oracle/UAT/fs1/inst/apps/UAT_qb/appl/admin/UAT_qb.xml

Check Clone Context logfile /u01/oracle/UAT/fs1/EBSapps/comn/clone/bin/CloneContext_0406111013.log for details.

Running Rapid Clone with command:

Running:

perl /u01/oracle/UAT/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/oracle/UAT/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/oracle/UAT/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/UAT/fs1/inst/apps/UAT_qb/appl/admin/UAT_qb.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/oracle/UAT/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/oracle/UAT/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java /u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/log4j.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/java/oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck/u01/oracle/UAT/fs1/inst/apps/UAT_qb/appl/admin/UAT_qb.xml -stage /u01/oracle/UAT/fs1/EBSapp s/EBSapps/comn/clone/FMW/logs/prereqcheck.log 

Beginning application tier Apply - Thu Apr  6 11:12:30 2017

/u01/oracle/UAT/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M - DCONTEXT _VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath
/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/../Oracle_EBSapp1/oui/jlib/srvm.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/UAT/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/UAT/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e u01/oracle/UAT /fs1/inst/apps/UAT_qb /appl/admin/ /UAT_qb.xml -stage /u01/oracle/UAT/fs1/inst/apps/UAT_qb /appl/admin/UAT_qb.xml -stage /u01/oracle/UAT/fs1/EBSapps/comn/clone-showProgress -nopromptmsg

Log file located at /u01 /oracle/UAT/fs1 /inst /apps/UAT_qb/admin /log /clone ApplyAppsTier _04061112.log

  |    100% completed

Completed Apply...

Thu Apr  6 11:37:54 2017

Do you want to startup the Application Services for UAT? (y/n) [n] :

Services not started

Running:

perl /u01/oracle/UAT/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adcleansrccfg.pl context=/u01/oracle/UAT/fs1/inst/apps/UAT_qb/appl/admin/UAT_qb.xml promptmsg=hide logfile=/u01/oracle/UAT/fs1/inst/apps/UAT_qb/admin/log/clone/ApplyAppsTier_04061112.log

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/oracle/UAT/fs1/inst/apps/UAT_qb/logs /appl/rgf/TXK/ /txkSetOAMReg_Thu_Apr_6_11_40_34_2017.log

Removing SSO/OID references if present...

stty: standard input: Inappropriate ioctl for device

stty: standard input: Inappropriate ioctl for device

Config Cleanup Complete

[appluat@qb bin]$

3.Once we are done with everything. Start the application Tier using adstral.sh

RUN the ENV for the Applciation tier

cd $ADMIN_SCRIPTS_HOME

adstral.sh apps/apps

Provide Weblogic Password:

Once application is up do a sample Health Check.

4.RUN adpreclone on TARGET RUN FILESYSTEM

[appluat@qb ]$ cd /u01/oracle/UAT/fs1/inst/apps/CRP_qb/admin/scripts

[appluat@qb scripts]$ adpreclone.pl appsTier

                               Copyright (c) 2011, 2014 Oracle Corporation

                                       Redwood Shores, California, USA

                                   Oracle E-Business Suite Rapid Clone

                                                  Version 12.2

                                adpreclone Version 120.31.12020000.20

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server....

Running perl /u01/oracle/UAT/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvision               EBS.plebs-get-serverstatus - contextfile =/u01/oracle/UAT /fs1/inst/apps/UAT_qbuat/appl/admin /appl/admin/UAT_qb.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

Running:

perl /u01/oracle/UAT/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/oracle/UAT/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/oracle/UAT/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/oracle/UAT/fs1/inst/apps/UAT_qbuat/appl/admin/UAT_qb.xml showProgress

Setting the wls environment

Beginning application tier Stage - Thu Apr  6 12:53:24 2017

/u01/oracle/UAT/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED =false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/UAT/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6 .jar:/u01/oracle/UAT/fs1/EBSapps/comn/ /java/classes:/u01/oracle/UAT/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar: /u01/oracle/UAT/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/oracle/oui/jlib/share.jar:/u01/oracle/UAT/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/ srvm.jar: /u01/oracle/UAT/fs1/ /FMW_HOME /webtier/jlib/ojmisc.jar:/u01/oracle /UAT/fs1/FMW_Home/wlserver_10.3/server/wlserver_10.3/server/lib/weblogic.jar: /u01/oracle/UAT/fs1/FMW_Home /oracle_commonjlib/ obfuscatepass  word.jar /u01/oracle/UAT/fs1/inst/apps/UAT_qbuat /appl/admin/UAT_qb.xml -stage /u01/oracle/UAT/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg

Log file located at /u01/oracle/UAT/fs1/inst/apps/UAT_qb/admin/log/clone/                                   StageAppsTier_04061253.log

  \     20% completed

Completed Stage...

Thu Apr  6 12:59:21 2017

[appluat@qb scripts]$

5.Shutdown the Application which is running on RUN File system

cd $ADMIN_SCRIPTS_HOME

adstpal.sh apps/apps

provide Weblogic admin password:

6.Copy the Target RUN File system to Target PATCH File system

make sure you already created the directory structure like

mkdir -p /u01/oracle/UAT/fs1/

mkdir -p /u01/oracle/UAT/fs2/<------Here We need to copy EBSapps from /u01/oracle/UAT/fs1/

mkdir -p /u01/oracle/UAT/fs_ne/

[appluat@qb ]$ cd /u01/oracle/UAT/fs1/

[appluat@qb  fs1]$ cp EBSapps  /u01/oracle/UAT/fs2/ .

UNSET the application Enviroment.

7.Once Finished copying Start Configuring TARGET PATCH File system

[appluat@qb ]$ cd /u01/oracle/UAT/fs2/EBSapps/comn/clone/bin

[appluat@qb scripts]$ perl adcfgclone.pl appsTier

                             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

                **********************************************************************

                In AD-TXK Delta 7, we recommend you clone the run and patch

                file systems in a single operation using the 'dualfs' option.

                Separate cloning of the run and patch file systems will be deprecated                                                                                        

                **********************************************************************

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone...

Log file located at /u01/oracle/UAT/fs2/EBSapps/comn/clone/bin/CloneContext_0406152616.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /u01/oracle/UAT/fs1/inst/apps/UAT_qb/appl/admin/UAT_qb.xml

Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /u01/oracle/UAT/fs2/FMW_Home

Target System Web Oracle Home set to /u01/oracle/UAT/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/oracle/UAT/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/oracle/UAT/fs2/EBSapps/comn

Target System Instance Top set to /u01/oracle/UAT/fs2/inst/apps/UAT_qb

Target System Port Pool [0-99] : 12

Checking the port pool 12

done: Port Pool 12 is free

Report file located at /u01/oracle/UAT/fs2/inst/apps/UAT_qb/admin/out/portpool.lst

The new APPL_TOP context file has been created :

/u01/oracle/UAT/fs2/inst/apps/UAT_qb/appl/admin/UAT_qb.xml

Check Clone Context logfile /u01/oracle/UAT/fs2/EBSapps/comn/clone/bin/CloneContext_0406152616.log for details.

Running Rapid Clone with command:

Running:

perl /u01/oracle/UAT/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/oracle/UAT/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/oracle/UAT/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/UAT/fs2/inst/apps/UAT_qb/appl/admin/UAT_qb.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/oracle/UAT/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/oracle/UAT/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath/prereq UAT /u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl- log4j.jar:/u01/oracle/UAT/OraPrereqChecks.jar:log4j.jar:/u01/oracle/
UAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01 .jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/java

oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/oracle/UAT/fs2/inst/apps/UAT_qb/appl/admin/UAT_qb.xml -stage /u01/oracle/UAT/fs2/EBSapps/comn/clone -log /u01/oracle/UAT/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply - Thu Apr  6 15:26:50 2017

/u01/oracle/UAT/fs2/EBSapps/comn/clone/bin/............................./jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath//u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/oracle/UAT/fs2/FMW_Home/webtier/Oracle_EBS/oui/jlib/srvm.jar:/u01/oracle/UAT/fs2/EBSapps//jlibapp1/fs2/
 /oui/jlib/ojmisc.jar:/u01/oracle/UAT/fs2/EBSapps/jlibapp1/oui/jlib /ojmisc.jar:  /UAT/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/UAT/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone Apply
AppsTier -e /u01/oracle/UAT/ fs2/inst/ /apps/UAT_qb/appl/admin/UAT_qb.xml -stage  -showProgress -nopromptmsg 

Log file located at /u01/oracle/UAT/fs2/inst/apps/UAT_qb/admin/log/clone/ApplyAppsTier_04061526.log

  -    100% completed

Completed Apply...

Thu Apr  6 15:55:55 2017

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

[appluat@qb bin]$

8.Once we are done with everything. Start the application Tier using adstral.sh

This time set the env to RUN File System

. /u01/oracle/UAT/EBSapps.env run

cd $ADMIN_SCRIPTS_HOME

adstral.sh apps/apps

                                           ***********All the Best*****************

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 4128M

Error:

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 4128M

Cause: The specified value of MEMORY_TARGET was less than the sum of the specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.

Action:

1.  Take a backup PFILE

2.  SQL>CREATE PFILE FROM SPFILE;

3.  Manually Edit the MEMORY_TARGET to at least the recommended value

4.  SQL>CREATE SPFILE FROM PFILE

5.  instance start again

     SQL>startup