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

Creating a custom application Top in Oracle E-Business Suite Release 12.2

This Document describes the basic steps needed to create a custom application in Oracle E-Business Suite Release 12.2.

Step 1: Create A Custom Application Using adsplice
Step 2: Verify Creation of Custom Product in the Database
Step 3: Create Custom Objects
Step 4: Propagate Changes to Other File System

Step 1: Create A Custom Application Using adsplice

1.Download Patch 3636980 "Support Diagnostics (IZU) patch for AD Splice" from My Oracle Support.

2.Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory.

3.Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will be using "xxqbprod.txt".

4.Rename izterr.txt to <CUSTOM MODULE>terr.txt. In this example, we will be using "xxqbterr.txt".

4.a )Open newprods.txt in a text editor.

Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM       MODULE> (i.e. keep the case sensitivity).

Note: In this example, we will be changing references of "izu" to be "xxqb" and "IZU" to be "XXQB".

4.b) Modify any other values as appropriate.

In this example case, the modified version of this file will look like the following:

product=xxqb

base_product_top= *APPL_TOP*

oracle_schema=xxqb

sizing_factor=100

main_tspace= USER_DATA

index_tspace=USER_IDX

temp_tspace=TEMP

default_tspace= USER_DATA

5.Open xxqbprod.txt in a text editor.

5.a) Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (keeping the case sensitivity).

Note: In this example, we will be changing references of "izu" to be "xxqb" and "IZU" to be "XXQB".

5.b) Change all references to prodid 278 to your own application ID.

You can run the following SQL to find out if your selected custom application ID number is available:

SQL>select decode(count ,0, 'Selected number is available', 'Selected number is already in use') Status, &&enter_custom_applID selected_number

from

(

select count(*) as count from

(

select 'x' from fnd_oracle_userid

where oracle_id= &&enter_custom_applID

union

select 'x' from fnd_application

where application_id= &&enter_custom_applID

)

);

Note: In this example, we will use a production_id of 277.

6. Open xxqbterr.txt in a text editor.

6.a) Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOMMODULE> (keeping the case sensitivity).

Note: In this example, we will be changing references of "izu" to be "xxqb" and "IZU" to be "XXQB".

6.b) Change the text "Oracle_Support_Diagnostic_Tools" to be "xxqb_custom_app".

7.Copy the following text files to the $APPL_TOP/admin directory:

   xxqbprod.txt

   xxqbterr.txt

   newprods.txt

8.Change directory to the admin directory under $APPL_TOP

Run AD Splice

Note: In Oracle E-Business Suite Release 12.2, AD Splice first makes the new user edition-enabled,and then enables Edition-Based Redefinition (EBR) for the custom objects.AD Splice must be run from the admin directory under APPL_TOP, and is invoked by running the command :

$ adsplice

When prompted for the following, you can press Enter to accept the default location :

Enter the directory where your AD Splicer control file is located.The default directory is [/oracle/VIS/apps/apps_st/appl/admin] :

When prompted for the following, you can press Enter to accept the default filename:

Please enter the name of your AD Splicer control file [newprods.txt] :

When prompted for the following, you can press Enter to accept the default value and regenerate the environment file :

Do you wish to regenerate your environment file [Yes] ?

AutoConfig will be run automatically as part of this procedure.

Review the AD Splice log file to ensure the procedure completed successfully.

Review the AutoConfig log file to ensure the procedure completed successfully.

Step 2: Verify Creation of Custom Product in the Database

Log in to SQL*Plus as APPS, and run the following SQL to confirm that the fnd_application table has one row :

SQL>select * from fnd_application where application_short_name = 'XXQB';

This statement should return one row only.

Run the following SQL to check the product installations table has one row for your custom product :

SQL>select * from fnd_product_installations where APPLICATION_ID = 50201;

This statement should return one row only.

Run the following SQL to check the database user :

SQL>select * from dba_users where username = 'XXQB';

This statement should return one row only.

To ensure the new environment file is picked up, log out and back in again as applmgr, then run the following command to confirm the $XXQB_TOP variable is correctly set :

$ env | grep XXQB

Run the following command to check the file system has been created correctly. You should see a directory listing returned as shown :

$ ls $XXQB_TOP

admin log mesg out sql

Note: If you have registered any schemas using the fnd_oracle_user_pkg.lod_row API, their passwords will not be encrypted. As a result,adpatch and adsplice will fail. To correct this, you need to run the FNDCPASS utility to set the password for the schemas.

Step 3: Create Custom Objects

You can now create any custom objects required.

In the $XXQB_TOP directory, create source code files appropriate to the type of object. For example, forms would be located in $XXQB_TOP/forms/US,and package source code in $XXQB_TOP/admin/sql.

You may also want to create custom request group, responsibilities, menus, etc. that your users require to access your custom objects.

Database objects such as tables, indexes, and sequences should be created in the XXQB schema.

Grant all privilege from each custom data object to the APPS schema.

For example, logged in as the XXQB user:

SQL>grant all privileges on myTable to apps;

Create a synonym in APPS for each custom data object.

For example, logged in as the APPS user:

SQL>create synonym myTable for XXQB.myTable;

Step 4: Propagate Changes to Other File System

When you start the next online patching cycle, the prepare phase will run AD Splice sync-up actions to synchronize the two file systems.

If the AD Splice sync-up fails when the prepare phase is run, check the $APPL_TOP/admin/$TWO_TASK/log/adsplicelog log file for the following :

UPDATE FND_ORACLE_USERID SET READ_ONLY_FLAG = 'A' WHERE ORACLE_ID

If you see this, apply Patch 18283295:R12.AD.C.Delta.5 and restart the prepare phase.

Note: Instructions for applying this patch can be found in My Oracle Support Knowledge Document 1617461.1,Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2.

Migrating Oracle E-Business Suite to Oracle Cloud a Complete Insight

Options Available
===============
You can now run Oracle E-Business Suite on Oracle Cloud.  EBS customers can take advantage of rapid environment provisioning, elastic infrastructure that scales up on demand, and a pay-as-you-go model to reduce capital expenditures.

EBS customers have the option of deploying their EBS 12.1.3 and 12.2 environments on the Oracle Compute Cloud Service, and optionally in combination with the Oracle Database Cloud Service DBCS), or the Exadata Cloud Service. 

What EBS customers can do on the cloud?

Provision new instances of E-Business Suite
Clone your own E-Business Suite environments to the cloud
Deploy development tools for E-Business Suite
Customize and extend your cloud-based E-Business Suite environments
Migrate those customizations to other cloud-based or on-premise EBS environments
Manage cloud and on-premise EBS environments using Oracle Application Management Suite
Use your certified third-party products with EBS cloud-based environments 

What additional fees are required for EBS customers?
Oracle Cloud resources and services are available for subscription by Oracle customers. 
Customers who already own Oracle E-Business Suite product licenses may use their Oracle Cloud subscription to provision and deploy Oracle E-Business Suite instances on the Oracle Cloud. The   deployed instances may be used for development, testing, training, production, etc. Once a               customer acquires a subscription to Oracle Cloud,no additional Oracle E-Business Suite license or       usage license is required. 

Do I need to purchase EBS product licenses?
Oracle customers who already own Oracle E-Business Suite licenses may use the Oracle Cloud to   host instances of their applications. 
Oracle’s Compute Cloud uses a “Bring your Own License” model, so customers who wish to use   the Oracle Compute Cloud must already own a valid license to the software deployed on virtual machines in Oracle Compute Cloud. 

Migrating an Oracle E-Business Suite Installation(On-Premise) to the Oracle Compute Cloud Service:

Cloning Oracle Applications Release 12 with Rapid Clone

The content applies to all Release 12.x.x versions, such as 12.0, 12.0.4, and 12.1.x. Where applicable, 12.0.x releases will in general be referred to as Release 12.0, and 12.1.x releases as Release 12.1.

The  most  current version of  this document can be obtained in Oracle Support Knowledge Document 406982.1.
In This Document
    Section 1: Prerequisite Tasks
    Section 2: Cloning Tasks
    Section 3: Finishing Tasks
    Section 4: Advanced Cloning Options
Cloning is the process used to create a copy of an existing Oracle Applications system. There are various scenarios for cloning an Oracle Applications system, including:

Standard cloning - Making a copy of an existing Oracle Applications system, for example a copy of a production system to test updates.

System scale-up - Adding new machines to an Oracle Applications system to provide the capacity for processing an increased workload.

System transformations - Altering system data or file systems, including actions such as platform migration, data scrambling, and provisioning of high availability architectures.

Patching and upgrading - Delivering new versions of Applications components, and providing a mechanism for creating rolling environments to minimize downtime.

An important principle in Oracle Applications cloning is that the system is cloned, rather than the topology. Producing an exact copy of the patch level and data is much more important than creating an exact copy of the topology, as a cloned system must be able to provide the same output to the end user as the source system. However, while a cloned system need not have the full topology of its source, it must have available to it all the topology components that are available to the source.
Note: The Cloning methodology posted on this document requires full Autoconfig compliance.

Table 1:Conventions used in this document include the following:

Term or Usage	Meaning or Action
Source system	Oracle Applications system being cloned.
Target system	Oracle Applications system being created as a copy of the source.
APPLMGR	User that owns the application tier file system (APPL_TOP and application tier technology stack).
ORACLE	User that owns the database tier file system (RDBMS ORACLE_HOME and database files).
CONTEXT_NAME	The CONTEXT_NAME variable refers to the name of the Applications context file. By default, CONTEXT_NAME is [SID]_[HOSTNAME].
Monospace Text	Represents command line text. Type this command exactly as shown. [ ] Text enclosed in brackets represents a variable. Substitute a value for the variable text. *Do not type the brackets.

Section 1: Prerequisite Tasks
Before cloning, prepare the source system by applying any required patches and running AutoConfig.

1.Verify OS requirements on target system.
2.Before cloning to a new server, ensure the target system meets all the requirements for Oracle. Applications Release 12 stated on the Oracle Applications Release Notes, and on the Oracle. Applications Installation and Upgrade Notes for each Platform. For the latest installation guidelines refer to My Oracle Support Knowledge Document 405565.1.
Note: On Microsoft Windows, Rapid Clone is not currently certified for use from Domain User Accounts.
Verify source and target system software components and versions In addition to the Oracle Applications software requirements (see Oracle Applications Installation Guide: Using Rapid Install), the following software component versions must exist on the source or target nodes as applicable. The 'Location' column indicates the node where the software component must reside.

Table 2: Software Requirements

Software Component	Minimum Version	Required Location	Comments
Zip	2.3(or higher)	All source system nodes	Download from InfoZip. Zip must be in your $PATH. If using files bigger than 2Gb, you should use InfoZip ZIP 3.0 or higher.
Unzip	5.52(or higher)	All source system nodes	Download from InfoZip. Unzip must be in your $PATH. If using files bigger than 2Gb, you should use InfoZip UNZIP 5.52 or higher.
Operating system utilities	N/A	All target system nodes	The required operating system utilities for your platform must be in your $PATH when running adcfgclone.pl. For example, make, ld, and ar on UNIX. Refer to Oracle Applications Installation Guide: Using Rapid Install (see Footnote 1)
Perl	5.x	All target system nodes	Use the Perl shipped with OracleAS 10.1.3 and Database 10g, or download it from Perl.com. Perl must be in your $PATH, and $PERL5LIB must be set correctly before cloning

Footnote 1 This is the Release 12.1.1 version; versions for earlier releases are also available from the Oracle E-Business Suite Online Documentation Library

Apply the latest AD patch

For Release 12.0:
Apply patches as listed in below.
Patch: 6510214
Description:R12.AD.A.DELTA.4

For Release 12.1:
Apply patches as listed in below.
     
Patch:9239089
Description:R12.AD.B.DELTA.3

Apply the latest AutoConfig template patch
Update the Oracle Applications file system with the latest AutoConfig template files by applying the TXK AutoConfig Template Rollup patch to all application tier server nodes. Refer to My Oracle Support Knowledge Document 387859.1 for details of the latest AutoConfig Template Rollup patch.

In addition, apply the patches as listed below.
For Release 12.0:
Apply patches as listed in below.
           
Patch:9712546 
Description:R12.TXK.A ONE_OFF: NEED BACKPORT OF 12.1 FIX 7035377 FOR 12.0.6 RC CUSTOMERS

Apply the latest Rapid Clone patches
Update the Oracle Applications file system with the latest Rapid Clone files by applying the following patches to all Applications nodes.

For Release 12.0:
Apply patches as listed in below.

Patch:5484000 
Description:Oracle E-Business Suite 12.0.2 Release Update Pack (RUP2) or higher
Patch:9171651
Description:R12.OAM.A 12.0 RAPIDCLONE CONSOLIDATED FIXES JUL/2010
Patch:9833058
Description:R12.OAM.A HOT CLONE FAILS WITH ORA-00201 DURING RECOVERY MANAGER
Patch:15969020
Description:R12.OAM.A APPSST12C: INCORRECT DIRECTORY WHEN RUNNING ADCFGCLONE.PL
Patch:16958896
Description:R12.OAM.A R12.0 FWDPRT BUG16958392 TCH12C: ADCFGCLONE.PL FAILURE DUE TO DEPRECATED PARAM
Patch:16959080
Description:R12.OAM.A TCH12C: R120+ ONE-OFF FOR S_DB_LISTENER BUG 12362010
Patch:20408489
Description:R12.OAM.A DB12102: RAPID CLONE SUPPORT FOR EBS 12.0.6 WITH DATABASE 12.1.0.2

For Release 12.1:

Apply patches as listed in below.

Patch :9171651
Description:R12.OAM.B 12.1 RAPIDCLONE CONSOLIDATED FIXES JUL/2010
Patch :9833058
Description:R12.OAM.B HOT CLONE FAILS WITH ORA-00201 DURING RECOVERY MANAGER
Patch :12404574
Description:R12.OAM.B ORACLE_HOME REGISTRATION DOES NOT HAPPEN WITH CENTRAL INVENTORY ON LOZ
Patch :12598630
Description:R12.OAM.B R12.1 ONE-OFF FOR S_DB_LISTENER BUG 12362010
Patch :15969020
Description:R12.OAM.B APPSST12C: INCORRECT DIRECTORY WHEN RUNNING ADCFGCLONE.PL
Patch :16958896
Description:R12.OAM.B R12.1 FWDPRT BUG16958392 TCH12C: ADCFGCLONE.PL FAILURE DUE TO DEPRECATED PARAM
Patch :13942692
Description:R12.OAM.B ADPRECLONE.PL FAILS INTERMITTENTLY ON DB TIER WHILE CHECKING LISTENER STATUS
Patch :18991480
Description:R12.OAM.B R12.1.3::12C DATAPATCH FAILS ON EBS CLONED ENVIRONMENTS
Patch :17889841
Description:R12.OAM.B 12C OUI REGISTRATION FAILS BUT CLONING COMPLETES SUCCESSFULLY
Patch :18835102
Description:R12.OAM.B CAN NOT CLONE 12.1.3 APPLICATION TIER AFTER APPLYING PATCH 17889841
Patch :18813637
Description:R12.OAM.B ADCLONECTX.PL FAILS ON 12C ENVIRONMENT WITH ORACLE E-BUSINESS SUITE 12.1.3

Other Patches (All releases):

Apply patches as listed in below.

Patch 8246709
Description:Required for Microsoft Windows if using OracleAS 10.1.3.4. This patch must be re-applied to the OracleAS 10.1.3.4 ORACLE_HOME before every cloning operation.

Warning: Failing to use the latest code may jeopardize the success of the clone. If new Rapid Clone or AutoConfig updates are applied to the system, steps 6, 7, and 8 below must be executed again in order to apply the new files to the database node.

Run AutoConfig on the application tiers
Follow the steps under section " Run AutoConfig on the Application Tiers " in My Oracle Support Knowledge Document 387859.1 to run AutoConfig on all application tier nodes.

Synchronize appsutil on the database tier nodes
Follow the steps under section "Copy AutoConfig to the RDBMS ORACLE_HOME" in My Oracle Support Knowledge Document 387859.1 to copy AutoConfig and Rapid Clone files to each database node via the admkappsutil.pl utility.

Run AutoConfig on the database tier
Follow the steps under section "Run AutoConfig on the Database Tier" in My Oracle Support Knowledge Document 387859.1 to run AutoConfig on the database tier nodes.

Maintain Snapshot Information
Log in to each application tier node as the APPLMGR user, and run "Maintain Snapshot Information" in AD Administration. To update the snapshot, please select the following options "Update Current View Snapshot" and "Update Complete APPL_TOP".
Note: If a snapshot was never created for that APPL_TOP, you will need to create a new one before proceeding with the clone. Refer to Oracle Applications Maintenance Utilities for more information (this is the Release 12.1 version; versions for earlier releases are also available from the Oracle E-Business Suite Online Documentation Library).

Section 2: Cloning Tasks

Use Rapid Clone to create template files for cloning on the source system. After the source system is copied to the target, Rapid Clone updates these templates to contain the new target system configuration settings.
Note: Rapid Clone never changes the source system configuration.
The cloning process consists of three phases, each of which is made up of several logical sections and their steps.
Prepare the source system
Execute the following commands to prepare the source system for cloning:

1.Prepare the source system database tier for cloning
Log on to the source system as the ORACLE user, and run the following commands:
       $ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
       $ perl adpreclone.pl dbTier

2. Prepare the source system application tier for cloning
Log on to the source system as the APPLMGR user, and run the following commands on each nod          node that contains an APPL_TOP:
          $ cd [INST_TOP]/admin/scripts
          $ perl adpreclone.pl appsTier
Note: If new Rapid Clone or AutoConfig updates are applied to the system, adpreclone.pl must be executed again on the dbTier and on the appsTier in order to apply the new files into the clone directory structures that will be used during the cloning configuration stage.

3.Copy the source system to the target system
Copy the application tier file system from the source Applications system to the target node by executing the following steps in the order listed. Ensure the application tier files copied to the target system are owned by the target APPLMGR user, and that the database node files are owned by the target ORACLE user.
Note: In the copying tasks below, UNIX/Linux users should ensure that the symbolic links (soft links) are preserved when copying. On most UNIX platforms, this can be accomplished with the cp -RH command. Consult the UNIX man page for the cp command to check the parameters available on your platform.

For example: cd /target_dest_dir/db 
                         cp -RH /source_dir/db/*

• Alternatively, the tar command can be used to compress the directories into a temporary staging area. UNIX/Linux users should ensure that the symbolic links (soft links) are preserved when compressing. On most UNIX platforms, this is the default behavior of tar command. Consult the UNIX man page for the tar command to check the parameters available on your platform.
• Additionally, verify the permissions of the executables under ORACLE_HOME/bin that can potentially be owned by root (i.e. nmo, nmhs, nmb, etc).

3.1. Copy the application tier file system.

Log on to the source system application tier nodes as the APPLMGR user and shut down the application tier server processes.Copy the following application tier directories from the source node to the target application tier node:
            [APPL_TOP]
            [COMMON_TOP]
            Applications Technology Stack:
            [OracleAS Tools ORACLE_HOME]
            [OracleAS Web IAS_ORACLE_HOME]

3.2. Copy the database node file system
Log on to the source system database node as the ORACLE user, and then:Perform a normal shutdown of the source system database

Copy the database (.dbf) files from the source system to the target system

Copy the source database ORACLE_HOME to the target system

Start the source Applications system database and application tier processes

4.Configure the target system

Change the following in the /etc/hosts file.

<Priviate ip of cloud server>  <Public host name of the cloud server>

*** The above setting in the host file is required if you are directly using the public host name to communicate to the local private ip of server instead of using Oracle web entry point configuration.

Run the following commands to configure the target system. You will be prompted for specific target system values such as SID, paths, and ports.

4.1 Configure the target system database server
Log on to the target system as the ORACLE user and enter the following commands:
        $ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
        $ perl adcfgclone.pl dbTier
Note: If the database version is 12c Release 1, ensure to add the following line in your sqlnet_ifile.ora after adcfgclone.pl execution completes:

For E-Business Suite Release 12.0
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

For E-Business Suite Release 12.1
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 (if the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE)
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10 (if SEC_CASE_SENSITIVE_LOGON is set to TRUE) 

4.2 Configure the target system application tier server nodes
Log on to the target system as the APPLMGR user and enter the following commands:
         $ cd [COMMON_TOP]/clone/bin
         $ perl adcfgclone.pl appsTier   
Note: If you are cloning between different versions of the Operating System (e.g. Linux 5 to Linux 4) it is recommended that you relink the AD_TOP product binaries using [adrelinknew "ad all"] followed by APPL_TOP executables with adadmin.

Section 3: Finishing Tasks

This section lists tasks that may be necessary, depending on your implementation and the intended use of the cloned system.

Update profile options
Rapid Clone updates only site level profile options. If any other profile options are set to instance specific values, you must update them manually.

Update printer settings
If the new cloned system needs to utilize different printers, update the target system with the new printer settings now.

Update Workflow configuration settings
Cloning an Oracle Applications instance will not update the host and instance-specific information used by Oracle Workflow. Review the tables and columns listed in Table 4 to check for any instance-specific data in the Workflow configuration on the target system.

Table 3: Workflow configuration settings    

Table Name	Column Name	Column Value Details
WF_NOTIFICATION_ATTRIBUTES	TEXT_VALUE	Value starts with http://[old web host]: Update to new web host.
WF_ITEM_ATTRIBUTE_VALUES	TEXT_VALUE	Value starts with "http://[old web host]: Update to new web host.
WF_SYSTEMS	GUID	Using the Workflow Administrator Web Applications responsibility, create a new system defined as the new global database name.
WF_SYSTEMS	NAME	Replace value with the database global name
WF_AGENTS	ADDRESS	Update database link with the new database global name.
FND_FORM_FUNCTIONS	WEB_HOST_NAME	Update with the new web host name.
FND_FORM_FUNCTIONS	WEB_AGENT_NAME	Update to point at the new PL/SQL listener name.
FND_CONCURRENT_REQUESTS	LOGFILE_NAME	Update with the correct path to the logfile directory
FND_CONCURRENT_REQUESTS	OUTFILE_NAME	Update with the correct path to the logfile directory.

    
Verify the APPLCSF variable setting
Source the APPS environment and review that the variable APPLCSF (identifying the top-level directory for concurrent manager log and output files) points to a suitable directory. To modify it, change the value of the s_applcsf variable in the context file and then run AutoConfig.
    
Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
   

If the target system is in a different domain name than the source system and SESSION_COOKIE_DOMAIN was not null in the source system, update that value to reflect the new domain name.

Re-Implement SSL and SSO configuration

If the Source System was SSL or SSO enabled, and the Target is wished to be SSL or SSO enabled, then reconfigure the Target by following the SSL/SSO documentation. Otherwise, if the Target is wished to be non-SSL or non-SSO, then follow the same SSL/SSO documentation to undo the SSL/SSO setup.