How to upgrade EBS 12.1.3 to 12.2.12

Upgrade EBS 12.1.3 to 12.2.12:

Prerequisites:

Run Gather Statistics:

Shut Down EBS 12.1.3 Application.

Run Gather Statistics on Database:
export ORACLE_PDB_SID=UPG

sqlplus / as sysdba
begin
dbms_stats.gather_schema_stats(
SYS',
options=>'GATHER STALE',
estimate_percent =>
DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL COLUMNS SIZE AUTO',
cascade => TRUE);
end;
/

exec dbms_stats.gather_fixed_objects_stats;
exec dbms_stats.gather_dictionary_stats;

sqlplus apps/apps
EXEC FND_STATS.gather_schema_statistics('ALL');

Parameter File Changes:

recyclebin=off                           #Add this Parameter
#*.local_listener='proddb:1521'          #Comment this Parameter
#*.service_names='UPG'                   #Comment this Parameter

Make following changes in pfile and Bounce the DB.

Add space to following Tablespaces:

APPS_TS_SEED should be 5 GB FREE  
System should be 25 GB FREE  
SYSAUX should be 5GB FREE

Stop the EBS R12.1.3 Application and keep Database and Listener running

Build R12.2 Staging Area: Following this Doc

Run Rapidwiz

cd /app/R12/stage1220/startCD/Disk1/rapidwiz/
./rapidwiz

Click on Next

Select “Upgrade to Oracle E-Business Suite Release 12.2.0”

Uncheck security updates if you do not want to receive Security Updates

Click YES

Select “Create Upgrade File System”

Click Next

Type Passwords and Click NEXT

Check Use Existing Oracle Home and Click NEXT

Verify OS users and groups, Click NEXT

Type WebLogic Password and APPS OS user (oracle or applmgr) password

Click Next

System Validation in Progress

Ignore DB service_names Check and Click NEXT

Click NEXT

Click YES

Upgrade in Progress

Upgrade File System is ready. Click NEXT

Click Finish

Now EBS 12.2.0 Upgrade File System is Created. We have to Apply latest patches. We do not have to apply patches manually. We will use EBS Technology Patch Automation Tool.

Run ETCC on DB and Apps Node

Now Patch Apps Tier using ETPAT-AT:

mkdir -p /app/UPG/APPS/fs_ne/EBSapps/patch/etpat-at
mkdir -p /app/UPG/APPS/fs_ne/EBSapps/patch/stage

Download Patch 32208510 and place it under ettpat-at and unzip
cd /app/UPG/APPS/fs_ne/EBSapps/patch/etpat-at

Download the following patches and place it under Stage Area:
Note: "These are the patches mentioned in my etcc report that I ran on previous
step, You have to download the patches as per your etcc report"
/app/UPG/APPS/fs_ne/EBSapps/patch/stage

Patch 35047661: EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR APR 2023
Patch 33186618: WLS PSU 10.3.6.0.211019 FOR ORACLE E-BUSINESS SUITE
Patch 35001508: EBS REHOSTED: 34900723 WLS PATCH SET UPDATE 10.3.6.0.230418
p34788326_R12_GENERIC.zip
p6880880_111000_LINUX.zip
p6880880_111000_Linux-x86-64.zip
p17537119_R12_GENERIC.zip
p6880880_101000_LINUX.zip
p6880880_101000_Linux-x86-64.zip
p33845432_R12_GENERIC.zip

Note: Download Patches according to your ETCC report. Do not unzip above
patches.

Run ETPAT-AT and Start patching:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd /app/UPG/APPS/fs_ne/EBSapps/patch/etpat-at
perl etpat_at.pl

Enter 12.2.0 Run edition file system context file:
/app/UPG/APPS/fs1/inst/apps/UPG_upg-inst/appl/admin/UPG_upg-inst.xml

Enter APPS schema name [APPS]:
Enter password for apps schema:

Enter directory where you downloaded ETCC Patch 17537119:
/app/UPG/APPS/fs_ne/EBSapps/patch/stage

Current stage area: /app/UPG/APPS/fs_ne/EBSapps/patch/stage
Enter 'Yes' to Continue (Yes/No): Yes

Enter patch stage area:
/app/UPG/APPS/fs_ne/EBSapps/patch/stage

Select the WLS PSU you want to upgrade to:
1. JAN23 [10.3.6.0.230117] - Recommended
2. JUL22 [10.3.6.0.220719]
3. APR22 [10.3.6.0.220419]
4. JAN22 [10.3.6.0.220118]
5. OCT21 [10.3.6.0.211019]
6. JUL21 [10.3.6.0.210720]

Enter your choice (1 or 2 or 3 or 4 or 5 or 6): 1
You have opted to apply WLS PSU version: 10.3.6.0.230117
Enter 'Yes' to Continue (Yes/No): Yes

Download above patches under patch stage area and Enter 'Yes' 
to Continue (Yes/No): Yes

AutoPatching will start

Script etpat_at.pl ran successfully.

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
. $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh
java weblogic.version

On Database Node:

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPG_upg19c.env
sqlplus apps/apps@UPG
exec sys.utl_recomp.recomp_parallel;
commit;

On Application Tier:

mkdir -p /app/UPG/APPS/fs_ne/EBSapps/patch/10117518_CUP13
mkdir -p /app/UPG/APPS/fs_ne/EBSapps/patch/AD_source
cd /app/UPG/APPS/fs_ne/EBSapps/patch/AD_source

Download below patches and upload it on AS_source    
Patch 10117518: R12.AD.C: Oracle Application DBA 12.2 PATCH    
Patch 33526872: ORACLE APPLICATIONS DBA CONSOLIDATED UPGRADE PATCH 13 
(AD CUP13) FOR R12.2.0

UNZIP both patches and then delete zip files:

cd /app/UPG/APPS/fs_ne/EBSapps/patch/AD_source
unzip p10117518_R12_LINUX.zip   
unzip p33526872_R12.AD.C_R12_LINUX.zip
rm -rf p10117518_R12_LINUX.zip p33526872_R12.AD.C_R12_LINUX.zip

cd /app/UPG/APPS/fs_ne/EBSapps/patch
. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env

Run below command:
admrgpch -s AD_source -d 10117518_CUP13 -merge_name 10117518_cup13 -admode

"Patch merge completed successfully"

Copy Adgrants from CUP13 and paste it in DB Appsutil and fs1

cd /app/UPG/APPS/fs_ne/EBSapps/patch/10117518_CUP13/admin
cp adgrants.sql /app/UPG/APPS/fs1/EBSapps/appl/admin/
scp adgrants.sql oracle@DbIP:/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin

On Database Tier: Run adgrants

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env  
export ORACLE_PDB_SID=UPG  
sqlplus /nolog  
@/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin/adgrants.sql APPS

On Application Tier:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
adadmin

"Enable Maintainance Mode"

Apply ORACLE APPLICATIONS DBA CONSOLIDATED UPGRADE PATCH 13 (AD CUP13):

cd /app/UPG/APPS/fs_ne/EBSapps/patch/10117518_CUP13
adpatch

The default directory is [/app/UPG/APPS/fs_ne/EBSapps/patch/10117518_CUP13] :
Please enter the name of your AutoPatch driver file : u_10117518_cup13.drv

"AutoPatch is complete."

Run Adadmin:
adadmin

Compile/Reload Applications Database Entities menu -> Compile APPS schema
"Type "No" when prompt for Run Invoker Rights processing in incremental mode [No] ?"

On Database Tier:

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env        
export ORACLE_PDB_SID=UPG        
perl $ORACLE_HOME/nls/data/old/cr9idata.pl        
        
Directory /app/UPG/APPS/19.0.0/nls/data/9idata already exist. Overwriting...        
Copying files to /app/UPG/APPS/19.0.0/nls/data/9idata...        
Copy finished.        
Please reset environment variable ORA_NLS10 to /app/UPG/APPS/19.0.0/nls/data/9idata!

sqlplus / as sysdba @?/rdbms/admin/utlrp.sql     
commit;     
     
SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);     
COUNT(*)     
----------     
17     
     
Varify gms userconnectivity:
sqlplus gms/gms@upg

Apply the Consolidated Upgrade Patch (CUP) for Release 12.2.0 (Patch 33526362:12.2.0) in pre-installation mode on the run edition file system:

Patch 33526362: ORACLE E-BUSINESS SUITE CONSOLIDATED UPGRADE PATCH 13 (CUP13) FOR R12.2.0        
Place the patch in /app/UPG/APPS/fs_ne/EBSapps/patch and unzip        
        
cd /app/UPG/APPS/fs_ne/EBSapps/patch        
cp /app/R12/mergeR12/p33526362_12.2.0_R12_LINUX.zip .        
cp /app/R12/mergeR12/p33526362_12.2.0_R12_ar.zip  .        
unzip p33526362_12.2.0_R12_LINUX.zip        
        
After unzip, remove the zip file:        
. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env        
cd /app/UPG/APPS/fs_ne/EBSapps/patch/33526362        
adpatch preinstall=y        
Enter Enter Enter Enter

When prompt for driver file:
u33526362.drv


cd $APPL_TOP/admin/$TWO_TASK/preinstall     
ls     
u33526362.drv     
     
cd $AU_TOP/patch/115/driver     
ls     
augenmsg.drvx ausstats.drvx u10124646.drv u10201000.drv     
     
admrgpch -d . -preinstall -master u10124646.drv     
     
2 unified drivers merged.     
Patch merge completed successfully

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env     
cd $AU_TOP/patch/115/driver     
ls     
u_merged.drv     
     
adpatch options=nocopyportion,nogenerateportion     
     
The default directory is [/app/UPG/APPS/fs1/EBSapps/appl/au/12.0.0/patch/115/driver] :     
u_merged.drv     
     
Do you want to run AutoPatch with these actions turned off [Yes] ?     
enter     
     
Done purging timing information for prior sessions.     
AutoPatch is complete.

Disable Maintenance Mode:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
adadmin
Successfully disabled Maintenance Mode

Make appsutil on APPS Tier:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
perl $AD_TOP/bin/admkappsutil.pl
output located at /app/UPG/APPS/fs1/inst/apps/UPG_upg-inst/admin/out/appsutil.zip
MakeAppsUtil completed successfully.

Transfer Appsutil.zip to Database Node:
scp /app/UPG/APPS/fs1/inst/apps/UPG_upg-inst/admin/out/appsutil.zip oracle@172.x.x.x:/u01/app/oracle/product/19.0.0.0/dbhome_1/

On Database Node:

cd /u01/app/oracle/product/19.0.0.0/dbhome_1
unzip -o appsutil.zip

sqlplus apps/apps@UPG
EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit;
exit

cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/bin
sh adconfig.sh contextfile=/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/UPG_upg19c.xml
AutoConfig completed successfully.

On Application Tier:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $AD_TOP/patch/115/sql
sqlplus apps/apps @txkDropAdxPreAutoConfig.sql
Commit complete

sqlplus apps/apps
DROP INDEX JTF.JTF_AMV_ITEMS_URL_CTX;
index droped
exit
cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh
AutoConfig completed successfully

Run Rapidwiz:

cd /app/R12/stage1220/startCD/Disk1/rapidwiz/
./rapidwiz

Run Adadmin after rapidwiz completes:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
adadmin

Regenerate jar files:
1 > 4 
Do you wish to force regeneration of all jar files? [No] ? Yes

Recompile APPS
3 > 1
Type "No" when prompt for Run Invoker Rights processing in incremental mode [No] ? Press Enter

Regenerate forms and pll's
1 > 2
All Enter Enter Enter

Recompile Menus
3 > 2
Do you wish to force compilation of all menus? [No] ? Yes

Recompile APPS
3 > 1
Type "No" when prompt for Run Invoker Rights processing in incremental mode [No] ? Press Enter

Exit

Run ChkFormsDeployment:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
perl $FND_TOP/bin/txkrun.pl -script=ChkFormsDeployment

*** LaTEST frmall.jar has NOT been copied ***
Copying the laTEST JAR file...
=============================================
Copying the laTEST JAR file

Successfully Completed the script

cd $ORACLE_HOME/forms/lib
make -f ins_forms.mk sharedlib
make -f ins_forms.mk install

cd $ORACLE_HOME/reports/lib
make -f ins_reports.mk install

adrelink.sh force=y link_debug=y "fnd fndfmxit.so" 
adrelink is exiting with status 0

cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh
AutoConfig completed successfully.

On Database Node:

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPG_upg19c.env
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/scripts/UPG_upg19c
sh adautocfg.sh
AutoConfig completed successfully.

Bounce the Database:
. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env
sqlplus / as sysdba
shu immediate;
startup;

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env
export ORACLE_PDB_SID=UPG
sqlplus / as sysdba

begin
dbms_stats.gather_schema_stats(
'SYS',
options=>'GATHER STALE',
estimate_percent =>
DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL COLUMNS SIZE AUTO',
cascade => TRUE);
end;
/

commit;
exit;

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env
export ORACLE_PDB_SID=UPG
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin

strings -a adgrants.sql | grep '$Header'
REM $Header: adgrants.sql 120.67.12020000.69 2020/03/20 00:56:38 jwsmith ship $

sqlplus /nolog
@adgrants.sql apps
ignore warnings
exit

sqlplus / as sysdba

CREATE OR REPLACE PUBLIC SYNONYM "V$SYSTEM_PARAMETER2" FOR "SYS"."V_$SYSTEM_PARAMETER2" ;
grant select on sys.V_$SYSTEM_PARAMETER2 to apps ;
grant select on sys.AUX_STATS$ to apps;
grant select on DBA_STAT_EXTENSIONS to apps;
grant select on DBA_TABLES to apps;
grant select on WRI$_OPTSTAT_TAB_HISTORY to apps;
grant select on WRI$_OPTSTAT_IND_HISTORY to apps;
grant select on DBA_INDEXES to apps;
grant select on DBA_OBJECTS to apps;
grant select on DBA_SCHEDULER_JOBS to apps;
grant select on sys.V$CELL_STATE to apps;

Apply patch on Application:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd /app/R12/readiness/31026891
adpatch options=hotpatch
u31026891.drv
AutoPatch is complete.

Create the Online Patching log file location and set it as the current directory and run the following Readiness reports:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
mkdir $LOG_HOME/appl/op
cd $LOG_HOME/appl/op

sqlplus system/OffTst#2F_1M @$AD_TOP/sql/ADZDPSUM.sql
mv adzdpsum.txt adzdpsum_pre_dbprep.txt

sqlplus system/OffTst#2F_1M @$AD_TOP/sql/ADZDPMAN.sql
mv adzdpman.txt adzdpman_pre_dbprep.txt

sqlplus system/OffTst#2F_1M @$AD_TOP/sql/ADZDPAUT.sql
mv adzdpaut.txt adzdpaut_pre_dbprep.txt

sqlplus apps/apps @$AD_TOP/sql/ADZDEXRPT.sql
mv adzdexrpt.txt adzdexrpt_pre_dbprep.txt

sqlplus apps/apps
exec sys.utl_recomp.recomp_parallel;
commit;
exit

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env
export ORACLE_PDB_SID=UPG
sqlplus / as sysdba @$ORACLE_HOME/rdbms/admin/dbmsxdbschmig.sql;
exit
sqlplus / as sysdba @$ORACLE_HOME/rdbms/admin/prvtxdbschmig.plb;
exit
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin
sqlplus /nolog
@adgrants.sql apps
ignore warnings

sqlplus / as sysdba
GRANT SELECT, UPDATE, DELETE, INSERT on sys.xdb$moveSchemaTab to apps;
exit

Make sure there is no ADOP related invalid object:

sqlplus apps/apps@UPG
select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like'%ADOP%';
select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like'%PREP%';
ALTER PACKAGE AD_ZD_ADOP COMPILE BODY;
alter package apps.AD_ZD_PREP compile body;
select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like'%PREP%';
exit

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd /app/R12/readiness/13543062
adpatch options=hotpatch,forceapply

Monitor enablement patch application progress at any time by running the DDL Status Report (ADZDSHOWDDLS.sql):

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $LOG_HOME/appl/op
sqlplus apps/apps @$AD_TOP/sql/ADZDSHOWDDLS.sql
cp adzdshowddls.out adzdshowddls.txt

sqlplus apps/apps
exec sys.utl_recomp.recomp_parallel;
commit;
exit

Re-run the Online Patching Enablement Status Report after the Online Patching Enablement patch has been applied:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $LOG_HOME/appl/op

sqlplus apps/apps @$AD_TOP/sql/ADZDEXRPT.sql
mv adzdexrpt.txt adzdexrpt_post_dbprep.txt

sqlplus system/OffTst#2F_1M @$AD_TOP/sql/ADZDPSUM.sql
mv adzdpsum.txt adzdpsum_post_dbprep.txt

sqlplus system/OffTst#2F_1M @$AD_TOP/sql/ADZDPMAN.sql
mv adzdpman.txt adzdpman_post_dbprep.txt

sqlplus system/OffTst#2F_1M @$AD_TOP/sql/ADZDPAUT.sql
mv adzdpaut.txt adzdpaut_post_dbprep.txt

Run the Online Patching Database Compliance Checker report to check for coding standards violations:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $LOG_HOME/appl/op
sqlplus apps/apps @$AD_TOP/sql/ADZDDBCC.sql

Review the log file:
vi adzddbcc.lst

On Database Node:

Make sure below parameters are included in database pfile and spfile if not enter in the spfile and bounce the database by adding them.

recyclebin=off
_SYSTEM_TRIG_ENABLED=true

Copy ADFIXUSER.sql from Apps Node to DB node:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd /app/UPG/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql
scp ADFIXUSER.sql oracle@172.x.x.x:/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin

On Database Node:

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env
export ORACLE_PDB_SID=UPG
mkdir -p /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/etcc
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin
sqlplus / as sysdba
@ADFIXUSER.sql

Run the Following scripts on Application Node:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $AD_TOP/patch/115/sql/
sqlplus apps/apps @adrevokegrants.sql
sqlplus apps/apps @$AD_TOP/sql/ADZDEXRPT.sql

Start Weblogic Admin server:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $ADMIN_SCRIPTS_HOME
sh adadminsrvctl.sh start
adadminsrvctl.sh: exiting with status 0

cd /app/R12/adtxk
cp -r 3* /app/UPG/APPS/fs_ne/EBSapps/patch/
cp -r 26787701 /app/UPG/APPS/fs_ne/EBSapps/patch/

cd /app/UPG/APPS/fs_ne/EBSapps/patch/34669333/admin
scp adgrants.sql oracle@172.x.x.x:/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin/

On Database Node:

. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPGCDB_upg19c.env
export ORACLE_PDB_SID=UPG
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/admin
sqlplus /nolog
@adgrants.sql apps
sqlplus / as sysdba
ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
ALTER USER EBS_SYSTEM IDENTIFIED BY OffTst#2F_1M;

alter system set "_disable_actualization_for_grant"=true scope=both;
exit

cd /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin
sqlplus / as sysdba @utlrp.sql

Take new session
. /u01/app/oracle/product/19.0.0.0/dbhome_1/UPG_upg19c.env
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/etcc
./checkDBpatch.sh

Apply AD-TXK 14 patches on Application:

AD - Patches (DELTA 14):

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
Apply AD Patch First
adop phase=apply patches=33600809 hotpatch=yes
adop exiting with status = 0 (Success)

Apply Critical Pathches
adop phase=apply patches=34668508,34669333,34681299,35280947 hotpatch=yes merge=yes
adop exiting with status = 0 (Success)

TXK - Patches (DELTA 14):

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
Apply TXK Patch First
adop phase=apply patches=33602997 hotpatch=yes
The apply phase completed successfully.
Apply Critical Pathches
adop phase=apply patches=34708635,34654260 hotpatch=yes merge=yes

Oracle E-Business Suite Release 12.2.12 Readme (Doc ID 2876726.1):

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
Admin Server and NodeManager running
ps -ef | grep weblogic
ps -ef | grep NodeManager
adop phase=apply patches=26787701 hotpatch=yes
adop exiting with status = 0 (Success)

sqlplus apps/apps
exec fnd_stats.gather_table_stats('MSC','MSC_ST_REGIONS', dbms_stats.auto_sample_size);
commit;
exit
Stop Oracle WebLogic Server's Admin Server and Node Manager services.

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

Make Sure no Application related process is running:
ps -ef | grep oracle

Make Appsutil on Application and Copy it to Database:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
perl $AD_TOP/bin/admkappsutil.pl
output located at /app/UPG/APPS/fs1/inst/apps/UPG_upg-inst/admin/out/appsutil.zip
MakeAppsUtil completed successfully.

scp /app/UPG/APPS/fs1/inst/apps/UPG_upg-inst/admin/out/appsutil.zip oracle@172.x.x.x:/u01/app/oracle/product/19.0.0.0/dbhome_1/

Run Autoconfig on Database:

cd /u01/app/oracle/product/19.0.0.0/dbhome_1
unzip -o appsutil.zip
. UPG_upg19c.env

cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/scripts/UPG_upg19c
sh adautocfg.sh

Apply EBS 12.2.12 patch on Application:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh

cd /app/R12/R12212/EnglishR12212
cp -r 33527700 /app/UPG/APPS/fs_ne/EBSapps/patch/

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
cd $PATCH_TOP
adop phase=apply apply_mode=downtime patches=33527700

Once Patch Applies successfully:

cd /app/UPG/APPS/fs1/FMW_Home/oracle_common/bin
chmod 755 *.sh
cd /app/UPG/APPS/fs2/FMW_Home/oracle_common/bin
chmod 755 *.sh

Run Autoconfig on Database and Application Tier:

. /app/UPG/APPS/fs1/EBSapps/appl/APPSUPG_upg-inst.env
perl $AD_TOP/bin/admkappsutil.pl
output located at /app/UPG/APPS/fs1/inst/apps/UPG_upg-inst/admin/out/appsutil.zip
MakeAppsUtil completed successfully.

scp /app/UPG/APPS/fs1/inst/apps/UPG_upg-inst/admin/out/appsutil.zip oracle@172.x.x.x:/u01/app/oracle/product/19.0.0.0/dbhome_1/

On database Node: 
cd /u01/app/oracle/product/19.0.0.0/dbhome_1 
unzip -o appsutil.zip 
. UPG_upg19c.env 
 
cd /u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/scripts/UPG_upg19c 
sh adautocfg.sh 
 
On Application Tier :
. /app/UPG/APPS/EBSapps.env run 
 
cd $ADMIN_SCRIPTS_HOME 
 
sqlplus system/OffTst#2F_1M 
alter trigger ebs_logon disable; 
 
sh adautocfg.sh 
 
sqlplus system/OffTst#2F_1M 
alter trigger ebs_logon enable;

cd /app/UPG/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain_UPG/config
cp config.xml config.xml_bkp
vi config.xml
Search for connection -filter-rule
Change the string “deny” to “allow”
wq!

Start the Application EBS 12.2.12 and run FS_CLONE:

cd $ADMIN_SCRIPTS_HOME
sh adstrtal.sh apps/apps

adop phase=cleanup

cd /app/UPG/APPS/fs1/FMW_Home/oracle_common/bin
chmod 755 *.sh
cd /app/UPG/APPS/fs2/FMW_Home/oracle_common/bin
chmod 755 *.sh

Run FS_CLONE:
adop phase=fs_clone