Totally taken 300 hrs to complete the first iteration along with the documenting the steps.
Initial plan and Pre-requisities steps to Upgrade ERP
=========================================
Oracle Database Software 10.2.0.4 64bit installation
10.2.0.4 64bit RDBMS dbTechStack Configuration in Testplan
Done Analysis of Migration of 32bit data to 64bit Data using RMAN
Recovered 32bit database and migrated to 64bit using RMAN
Done Analysis on OLAP Conversion from 32bit to 64bit
OLAP conversion from 32bit to 64bit
Apps binaries copy is done location test server – appldev /d02
11.2.0.4 Software copy to the server
Apps clone and Basic validation of 11.5.10.2 after clone.
Database upgrade from 10.2.0.4 64bit to 11.2.0.4 64bit
Downloaded the Interoperability Patches
Downloaded the rdbms Patches
Done Patch analysis of all the Patches
11.2.0.4 software only installation and apply all the RDBMS Patches
Apply all the application interoperability Patches
Post upgrade steps for 10.2.0.4 to 11.2.0.4
Done analysis on OATM Conversion
Perform the OATM Conversion
Downloaded the R12.2 Software from e-delivery
Done analysis for Upgrade Steps to R12.2 from 11.5.10.2 with 11.2.0.4 64 bit database
Done Basic validation after database upgrade of 11.5.10.2 Application ,Post steps and taken RMAN Backup
Upgrade Steps of R12.2.0
========================
Build Stage R12.2.0
Done Analysis and Applied all the 24 RDBMS Patches specific to 11.2.0.4 for R12.2.0
Ran Tums Utility and verified the steps to take care before upgrade
Perform Pre-requistie’s steps before going to upgrade
Ran Rapidwiz and install the Application in upgrade mode by providing existing database
Perform Post Upgraade Steps
Done analysis and Applied AD R12.2 Upgrade Driver Patch
Done analysis and Applied CUP Patch
Pre-requisities steps before running American Driver patch
Ran American Driver patch
Post Steps after the patching
=============================
Configure Release 12.2 E-Business Suite instance
Run Rapid Install to configure Release 12.2 E-Business Suite instance.
Done analysis and Applied E-Business Suite:Online Patching Readiness and GSCC Report patch
Ran the scripts of GSCC Report and worked on the pre and post recommendations provided
Preformed pre-requisties Steps before applying online patching
Done Analysis and Applied adop Patch
Oracle E-Business Suite NLS Release 12.2.0 Latin American Spanish
Done Analysis on ADOP
Done Analysis and applied latest AD and TXK for Release 12.2 both US and NLS patches
Upgrade Steps of R12.2.4
Done analysis and prepared the execution steps for upgrade from R12.2.0 to R12.2.4
Performed pre-requisties Steps before applying 12.2.4 upgrade pack
Done Analysis and Applied Oracle E-Business Suite 12.2.4 Release Update Pack
Skipping the step for oracle database upgrade from 10.2.0.3 to 11.2.0.4. Also attaching the bit conversion of oracle database from 10.2.0.4 32 bit to 10.2.0.4 64bit and OATM migration. Remaining all just an upgrade steps.
So assuming database upgraded from 10.2.0.4 32bit to 11.2.0.4 64 bit. Please follow the other steps.
To complete the upgrade to Release 12.2, you must upgrade your database to at least
Oracle 11g Release 2 (11.2.0.4).
Assume like we are on 11.2.0.4 database
==>1349240.1This document details the database preparation process for Oracle E-Business Suite Release 11i and R12 (12.0, 12.1) customers planning to upgrade to Release 12.2
==>Interoperability Notes Oracle EBS R12 with Oracle Database 11gR2 (11.2.0.3) (Doc ID 1585578.1)
12951696 (only this one is missing, remaining all patches are applied)
==>PSU patch already applied (1147107.1)
==>The note1349240.1 refers to
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=223414393749160&id=1594274.1&_afrWindowMode=0&_adf.ctrl-state=rc7l1w56r_744
Refer Section 2.2: Database 11.2.0.4 Patches and Bug Numbers
==>Important patching point: -Included in startCD’ column is not relevant for 11.2.0.4 Database. Apply all the patches listed for your platform.
Hence need to apply all the patches mentioned in table1 of section 2.2(mentioned under LinuxX86-64)
==>
1)4189542 –Applied
2)4247037 –Applied
# Once applied with opatch, the files are located in $ORACLE_HOME/md/admin
# and $ORACLE_HOME/md/support for patchset_mgdsys_validity.sql
# Patch Special Instructions:
# To install:
# connect to the database using sqlplus / as sysdba
# sqlplus> @catmgdidcode
# If checking with patchset_mgdapp_validity.sql you find invalid objects
# please run $ORACLE_HOME/rdbms/admin/utlrp.sql which should resolve any issues.
# Thepatchset_mgdsys_validity.sql script in support was written by
# BDE engineer to check the status of the build not by development
# Todeinstall
# connect to the database using sqlplus / as sysdba
# sqlplus> @catnomgdidcode (NOTE: file is located in $OH/md/admin)
3)12949905 – Applied
4)16929165 – Applied
5)16989137 -Applied
The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.
1. For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the below script as follows:
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @?/sqlpatch/16989137/postinstall.sql
2. Check the output for any errors.
6)16992075 -Applied
7)17402822 -Applied
8)17420796 _Applied
9)17429475-Applied
10)17468141-Already Applied as part of PSU
11)17478145 -Applied
12)17501296 –Already Applied as Part of PSU
(3) Postinstallation
———————-
Note: This step is needed only if the database is already upgraded to 11.2.0.4
The following steps load modified SQL files into the database. For a RAC
environment, perform these steps on only one node.
1. For each database instance running on the Oracle home being patched,
connect to the database using SQL*Plus. Connect as SYSDBA and run the below
script as follows:
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @?/sqlpatch/17501296/postinstall.sql
2. Check the output for any errors.
13)17600719–Appiled
14)17629476 This database patch is required to support the latest AD and TXK release update packs, as described 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. –Applied
(III) Postinstallation
———————-
The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.
1. For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the below script as follows:
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @?/sqlpatch/17629476/postinstall.sql
2. Check the output for any errors.
15)17892268 -Applied
16)17912217
17)17944018 -Applied
(III) Postinstallation
———————-
The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.
1. For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the below script as follows:
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @?/sqlpatch/17944018/postinstall.sql – Ran 15min
2. Check the output for any errors.
18)18061712 For a more recent version of this fix that also includes additional fixes, refer to Patch 19122520 and its associated footnote.
19)18241194 This database patch is no longer available. For a more recent version of this fix refer to Patch 19122520 and its associated footnote.
Patch 19122520 is enough instead of above patches – Applied
20)18419770 -> Applied
21) 18614015 – Applied
(III) Postinstallation
———————-
The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.
1. For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the below script as follows:
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @?/sqlpatch/18614015/postinstall.sql
2. Check the output for any errors.
22) 18665660 – Applied
23) 18685209 -Applied
24) 19122520 – Already Applied Above
Step 2) Install TUMS Patch Utility for 11i to upgrade to R12.2
TUMS Utility for Release 11i to Release 12.2 upgrade – 18342870
1. Apply the following driver file using adpatch:
u18342870.drv (This is the unified driver)
2. Generate the TUMS report by executing the following command:
$ cd $AD_TOP/patch/115/sql
$ sqlplus/ @adtums.sql
A report file called tumsr12.html will be created in the directory. This
directory path must have been listed in the UTL_FILE_DIR parameter of your
database.
TUMS Utility RecommendationsPreparing for the Upgrade:-
==========================================
1. Back up database, Applications, and customizations (recommended).
2. Prepare an upgrade plan for customizations (conditional).
Preserve the CUSTOM library by making a backup copy of CUSTOM.pll. You
can use this copy later in the upgrade process to migrate your CUSTOM library
to Release 12.2.
4) Drop event alert triggers in custom schemas (conditional).
Applies to 11i release level: All
TUMS step key: N/A
To drop all event alert database triggers in custom schemas, run the alrdtrig.sql
script, located in $ALR_TOP/admin/sql (in your Release 11i system). Re-create the
triggers after the upgrade is complete.
5. Review sizes of old and new tablespaces (required).
Applications Release 12 Upgrade Sizing and Best Practices (Doc ID: 399362.1).
Applications Technology Tasks
Supply Chain Management Tasks
Checking for Duplicate Records
Applies to 11i release level: All
TUMS step key: EGO_CHECK_FOR_DUPLICATES
Run the following query and verify the output:
SELECT COUNT(1)
FROM SYS.ALL_IND_COLUMNS
WHERE INDEX_NAME = ‘EGO_MTL_SY_ITEMS_EXT_B_U2’
AND COLUMN_NAME = ‘UNIQUE_VALUE’
AND INDEX_OWNER = ‘EGO’;
SQL> SELECT COUNT(1)
FROM SYS.ALL_IND_COLUMNS
WHERE INDEX_NAME = ‘EGO_MTL_SY_ITEMS_EXT_B_U2’
AND COLUMN_NAME = ‘UNIQUE_VALUE’
AND INDEX_OWNER = ‘EGO’; 2 3 4 5
COUNT(1)
———-
0
If the above query returns ‘0’ as the output, then perform the following steps:
1. Take backup of ego_mtl_sy_items_ext_b table
2. Refer to Note ID: 953449.1 and run the script provided in the ‘Identification
Script’ column within the ‘Solution – Datafix’ section to identify duplicate
records.
If there are duplicate records, then run the scripts provided in the ‘Fix’ column
within the ‘Solution – Datafix’ section for the appropriate base version to delete
duplicate records.
Note: You must eliminate duplicate records before upgrading
to Release 12.2. If you require help eliminating duplicate
records, then contact Oracle Support.
Checked the note id no duplicate records found
SQL> SELECT COUNT(*) AS v_count ,
inventory_item_id,
2 3 organization_id,
4 revision_id,
5 attr_group_id
6 FROMapps.ego_mtl_sy_items_ext_b a
7 WHERE EXISTS (SELECT 1
8 FROMapps.ego_fnd_dsc_flx_ctx_ext b
9 WHEREa.attr_group_id = b.attr_group_id
10 ANDapplication_id = 431
11 ANDmulti_row<> ‘Y’)
12 GROUP BY inventory_item_id,
13 organization_id,
revision_id,
14 15 attr_group_id
16 HAVING COUNT(*) > 1;
no rows selected
Enterprise Asset Management:
Perform these tasks if you are using Oracle Enterprise Asset Management (EAM).
1. Set up the Install Base Parameters and Services Profile Option
Applies to 11i release level: All
TUMS step key: EAM_CHECK_SETUP
You must set up the Install Base Parameters and Services Profile Option in
2-26 Oracle E-Business Suite Upgrade Guide
accordance with Note 884201.1. If this note is not checked and the IB Parameters are
not verified and set up as described, then the eamsnupd.sql file will fail during
patching, therefore creating data corruptions and the upgraded database will be
compromised. Asset Numbers Upgrade will fail, and half of the Asset Numbers
will be lost after the upgrade process.
Step2)
==>Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1).
Verify above note id and set parameters if any
_optimizer_autostats_job=FALSE #MP Turn off automatic statistics.
recyclebin=off
service_names=%s_dbSid%,ebs_patch ==>UAT,ebs_patch
local_listener=%s_dbSid%_LOCAL ==> UAT_LOCAL
==>Ensure that the GUEST account is valid and active and that the fnd_user USER_ID for
the GUEST account is set to a value of ‘6’.
==>Gather Schema Statistics :- Submit the Gather Schema Statistics program for ALL schemas
From your Release 11i APPL_TOP, complete the following steps:
1. Log in to Oracle E-Business Suite as the System Administrator.
2. Navigate to the Submit Request window (Requests > Run).
3. Submit the Gather Schema Statistics program.
Alternatively, run the following procedure manually:
FND_STATS.GATHER_SCHEMA_STATISTICS(‘ALL’, 10, :parallel_degree,
‘NOBACKUP’, NULL, ‘LASTRUN’, ‘GATHER AUTO’, 10, ‘N’);
Where: parallel_degree is set to the value of the database initialization
==>Install JRE on the database tier: – If you are planning to run Rapid Install in Upgrade Mode by using the Use ExistingORACLE HOME option, then you must install JRE in the Database
ORACLE_HOME as follows:
Download the latest JRE 6.0 Update.
http://www.oracle.com/technetwork/java/javase/downloads/index.html
Note: Do not download the Java SE Development Kit (JDK). To download platform specific JRE and additional information on installation, refer to Using Latest Java 6.0 Update With Oracle E-Business Suite Release 12 (Doc ID 455492.1).
[root@testplantmp]# ls -ltrjre*
-rw-r–r–. 1 root root 33632504 Oct 13 14:08 jre-7u67-linux-x64.rpm
[root@testplantmp]# rpm -ivUh jre-7u67-linux-x64.rpm
Preparing… ########################################### [100%]
1:jre ########################################### [100%]
Unpacking JAR files…
rt.jar…
jsse.jar…
charsets.jar…
localedata.jar…
jfxrt.jar…
[root@testplantmp]#
It will create jre under /usr/java
[root@testplan jre1.7.0_67]# pwd
/usr/java/jre1.7.0_67
copy it to $ORACLE_HOME/appsutil
$ cd [ORACLE_HOME]/appsutil
$ mvjrejre_old –> if it already exists
$ mv jre1.7.0_67/ jre
Run Rapid Install :-
[oracle@testplan R12.2]$ ls -ltr *.zip
-rw-r–r–. 1 oracle dba 8100608 Oct 14 02:37 V46139-01.zip
-rw-r–r–. 1 oracle dba 85594608 Oct 14 02:37 V46243-01_2of3.zip
-rw-r–r–. 1 oracle dba 616473105 Oct 14 02:37 V35231-01_3of5.zip
-rw-r–r–. 1 oracle dba 398816986 Oct 14 02:37 V46140-01.zip
-rw-r–r–. 1 oracle dba 5167637434 Oct 14 02:39 V46243-01_1of3.zip
-rw-r–r–. 1 oracle dba 101976210 Oct 14 02:39 V46243-01_3of3.zip
-rw-r–r–. 1 oracle dba 979195792 Oct 14 02:40 V35231-01_1of5.zip
-rw-r–r–. 1 oracle dba 2738693963 Oct 14 02:41 V35811-01.zip
-rw-r–r–. 1 oracle dba 659229728 Oct 14 02:41 V35231-01_2of5.zip
-rw-r–r–. 1 oracle dba 1142195302 Oct 14 02:42 V35230-01_2of2.zip
-rw-r–r–. 1 oracle dba 113915106 Oct 14 02:42 V35231-01_5of5.zip
-rw-r–r–. 1 oracle dba 479890040 Oct 14 02:42 V35231-01_4of5.zip
-rw-r–r–. 1 oracle dba 1358454646 Oct 14 02:43 V35230-01_1of2.zip
-rw-r–r–. 1 oracle dba 3000447453 Oct 14 02:44 V35809-01.zip
-rw-r–r–. 1 oracle dba 2425982543 Oct 14 02:45 V35812-01.zip
-rw-r–r–. 1 oracle dba 3366737284 Oct 14 02:46 V35807-01.zip
-rw-r–r–. 1 oracle dba 2939997663 Oct 14 02:48 V35810-01.zip
-rw-r–r–. 1 oracle dba 1174163462 Oct 14 02:48 V35806-01_2of3.zip
-rw-r–r–. 1 oracle dba 2993600143 Oct 14 02:50 V35808-01.zip
-rw-r–r–. 1 oracle dba 1444937228 Oct 14 02:50 V35805-01_1of2.zip
-rw-r–r–. 1 oracle dba 1469296893 Oct 14 02:51 V35806-01_1of3.zip
-rw-r–r–. 1 oracle dba 1722651490 Oct 14 02:52 V35804-01_2of2.zip
-rw-r–r–. 1 oracle dba 1092680934 Oct 14 02:52 V35806-01_3of3.zip
-rw-r–r–. 1 oracle dba 1388965561 Oct 14 02:53 V35805-01_2of2.zip
-rw-r–r–. 1 oracle dba 746176239 Oct 14 02:53 V35802-01.zip
-rw-r–r–. 1 oracle dba 1664375467 Oct 14 02:54 V29764-01.zip
-rw-r–r–. 1 oracle dba 1305341704 Oct 14 02:54 V35804-01_1of2.zip
-rw-r–r–. 1 oracle dba 1301604194 Oct 14 02:55 V35803-01_1of3.zip
-rw-r–r–. 1 oracle dba 1072459718 Oct 14 02:55 V35803-01_2of3.zip
-rw-r–r–. 1 oracle dba 1439731111 Oct 14 02:56 V35803-01_3of3.zip
-rw-r–r–. 1 oracle dba 766477637 Oct 14 02:56 V35813-01.zip
-rw-r–r–. 1 oracle dba 195152 Oct 14 02:56 V46241-01_2of9.zip
-rw-r–r–. 1 oracle dba 1067931167 Oct 14 02:57 V29856-01.zip
-rw-r–r–. 1 oracle dba 645976865 Oct 14 02:57 V36805-01.zip
-rw-r–r–. 1 oracle dba 280206475 Oct 14 02:57 V46198-01.zip
-rw-r–r–. 1 oracle dba 545468978 Oct 14 02:58 V46241-01_4of9.zip
-rw-r–r–. 1 oracle dba 21151272 Oct 14 02:58 V46241-01_1of9.zip
-rw-r–r–. 1 oracle dba 509451855 Oct 14 02:58 V46241-01_3of9.zip
-rw-r–r–. 1 oracle dba 272711208 Oct 14 02:58 V46241-01_5of9.zip
-rw-r–r–. 1 oracle dba 102613913 Oct 14 02:58 V46241-01_9of9.zip
-rw-r–r–. 1 oracle dba 218120 Oct 14 02:58 V46241-01_7of9.zip
-rw-r–r–. 1 oracle dba 591609251 Oct 14 02:58 V46241-01_6of9.zip
-rw-r–r–. 1 oracle dba 570439034 Oct 14 02:58 V46241-01_8of9.zip
[oracle@testplan R12.2]$
==>Unzip only bow file first
[oracle@testplan R12.2]$ ls -ld *46243*
-rw-r–r–. 1 oracle dba 5167637434 Oct 14 02:39 V46243-01_1of3.zip
-rw-r–r–. 1 oracle dba 85594608 Oct 14 02:37 V46243-01_2of3.zip
-rw-r–r–. 1 oracle dba 101976210 Oct 14 02:39 V46243-01_3of3.zip
Then
cd/d01/software/R12.2/startCD/Disk1/rapidwiz/bin
[applmgr@upgdb bin]$ ./buildStage.sh
Running command:
/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /d01/software/R12.2/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64
Specify the directory containing the zipped installation media:
/d01/software/R12.2
File list:
/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The set of zip files is complete.
Unzip command is: /d01/software/R12.2/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Unzipping V35230-01_1of2.zip
Unzipping V35230-01_2of2.zip
Unzipping V35231-01_1of5.zip
Unzipping V35231-01_2of5.zip
Unzipping V35231-01_3of5.zip
Unzipping V35231-01_4of5.zip
Unzipping V35231-01_5of5.zip
Unzipping V35802-01.zip
Unzipping V35803-01_1of3.zip
Unzipping V35803-01_2of3.zip
Unzipping V35803-01_3of3.zip
Unzipping V35804-01_1of2.zip
Unzipping V35804-01_2of2.zip
Unzipping V35805-01_1of2.zip
Unzipping V35805-01_2of2.zip
Unzipping V35806-01_1of3.zip
Unzipping V35806-01_2of3.zip
Unzipping V35806-01_3of3.zip
Unzipping V35807-01.zip
Unzipping V35808-01.zip
Unzipping V35809-01.zip
Unzipping V35810-01.zip
Unzipping V35811-01.zip
Unzipping V35812-01.zip
Unzipping V35813-01.zip
Unzipping V29764-01.zip
Unzipping V29856-01.zip
Unzip command is: /d01/software/R12.2/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Applying one-off patches…
All files have been unzipped successfully.
Stage area is confirmed to be complete.
Command = cp /d01/software/R12.2/V35813-01.zip /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip
Finished unzipping shiphome.
Directory /d01/software/R12.2/TechPatches
Unzipping Oracle Software Delivery Cloud one-off patches…
Command: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip -d /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/..
Press Enter to continue…
Archive: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13877559/p13877559_111160_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/10638758/p10638758_111160_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/7695070/p7695070_111070_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14059667/p14059667_R12_LINUX.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13583235/p13583235_1036_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14616819/p14616819_111160_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13572948/p13572948_1036_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13642485/p13642485_1036_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13025456/p13025456_111160_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/12873715/p12873715_R12_GENERIC.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14157219/p14157219_R12_LINUX.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13845626/p13845626_1036_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14272383/p14272383_1036_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/11857015/p11857015_R12_LINUX.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14588599/p14588599_111160_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/12949905/p12949905_111070_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14026577/p14026577_111160_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/6880880/p6880880_111000_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/12959202/p12959202_111160_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14621810/p14621810_1036_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/11835003/p11835003_R12_GENERIC.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14049348/p14049348_1036_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13643211/p13643211_111160_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13800626/p13800626_111170_LINUX.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14574453/p14574453_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14296972/p14296972_112030_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/8547978/p8547978_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14598522/p14598522_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/12949905/p12949905_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/6880880/p6880880_112000_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13040331/p13040331_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/12955701/p12955701_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14005749/p14005749_112030_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14013094/p14013094_112030_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/11071989/p11071989_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13388104/p13388104_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13808632/p13808632_112030_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14153501/p14153501_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14832335/p14832335_112030_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/11820674/p11820674_R12_LINUX.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14649883/p14649883_112030_Generic.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13602312/p13602312_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13819954/p13819954_112030_Linux-x86-64.zip
extracting: /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14237793/p14237793_112030_Linux-x86-64.zip
Finished unzipping Oracle Software Delivery Cloud one-off patches.
Press Enter to continue…
Stage Builder will now stage the one-off patches for Linux_x64…
Press Enter to continue…
Copying latest one-off patches to stage area…
Running command:
/d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../../../../TechPatches
Press Enter to continue…
unzip: cannot find or open /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip, /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip.zip or /d01/software/R12.2/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip.ZIP.
Verifying stage area…
Directory /d01/software/R12.2/TechInstallMedia is valid.
Directory /d01/software/R12.2/TechPatches/DB is valid.
Directory /d01/software/R12.2/TechPatches/MiddleTier is valid.
Directory /d01/software/R12.2/EBSInstallMedia/AppDB is valid.
Directory /d01/software/R12.2/EBSInstallMedia/Apps is valid.
Directory /d01/software/R12.2/EBSInstallMedia/AS10.1.2 is valid.
Directory /d01/software/R12.2/TechInstallMedia/database is valid.
Directory /d01/software/R12.2/TechInstallMedia/ohs11116 is valid.
Directory /d01/software/R12.2/TechInstallMedia/wls1036_generic is valid.
Stage area verified.
Press Enter to continue…
Build Stage Menu
——————————————————
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu
Enter your choice [4]:
Go to s/w location
[oracle@upgdbrapidwiz]$ pwd
/d03/soft_12/startCD/Disk1/rapidwiz
./rapidwiz
WLS Password: welcome1
Check log in directory/d01/oracle/uatdb/11.2.0/appsutil/log/UAT_testplan
Jre folder not correctly copied from /usr/java after applying jre rpm as part of db requirements
Have done issue got rectified
==>Important: After completing Rapid Install in Upgrade Mode, in DBTier’s , ensure that values of context variables -s_dbhome1, s_dbhome2, s_dbhome3, s_dbhome4, s_archive_destpoints to proper data file location where the DBFs are located, and
alsos_base points to proper location. If not, update the DB Tier.
[oracle@upgdb ~]$ grep -i s_dbhome $CONTEXT_FILE
<db_sysfilesoa_var=”s_dbhome1″>/d03/oracle/upg1data
<db_logfilesoa_var=”s_dbhome2″>/d03/oracle/upg1data
<db_datfilesoa_var=”s_dbhome3″>/d03/oracle/upg1data
<db_ndxfilesoa_var=”s_dbhome4″>/d03/oracle/upg1data
[oracle@upgdb ~]$ grep -i s_archive_dest $CONTEXT_FILE
/d02/app/oracle/product/data/archive
[oracle@upgdb ~]$ grep -i s_base $CONTEXT_FILE
<base_langoa_var=”s_base_lang”>US
/d02/app/oracle/product
==>Make sure apps passwor id default
==>Synchronize values of APPLPTMP with UTL_FILE_DIR for PL/SQL based Concurrent Requests (required)
Concurrent processing (CP) may run PL/SQL (inside of the database) that creates
output and log files using the utl_file package. On all CP nodes, ensure that the
$APPLPTMP environment variable is set to the first directory listed in the
UTL_FILE_DIR parameter from the database init.ora.
[applmgr@upgdb ~]$ echo $APPLTMP
/d01/oracle/UPG1/inst/apps/UPG1_upgdb/appltmp
[applmgr@upgdb ~]$ ls -ld /d01/oracle/UPG1/inst/apps/UPG1_upgdb/appltmp
drwxrwxrwx 3 applmgrdba 4096 Feb 25 14:06 /d01/oracle/UPG1/inst/apps/UPG1_upgdb/appltmp
==>Shutdown apps if any is running
==>If your processes and sessions values in the init.ora file is the default values provided by
the E-Business installation of 300 and 600, then you should consider doubling these
during the upgrade process to avoid connection issues.
==>Disable custom triggers or constraints on Oracle E-Business Suite tables. Re-enable
these triggers after the upgrade.
custom indexes below are all normal none unique so no need to worry, for constraints there is none for custom so no need to worry.
TAC_GL_PERIOD_STAT1_N1
TAC_GL_PERIOD_STAT_N1
TAC_WF_ITM_ACT_STATUSES_N4
for triggers below are disabled.
[oracle@testplan ~]$ pwd
/home/oracle
[oracle@testplan ~]$ ls -l disable_trg.sql
-rw-r–r–. 1 oracle dba 430 Oct 14 19:58 disable_trg.sql
[oracle@testplan ~]$ sqlpllus apps/apps @disable_trg.sql
-bash: sqlpllus: command not found
[oracle@testplan ~]$ sqlplus apps/apps @disable_trg.sql
SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 14 19:58:56 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> conn apps/apps
Connected.
SQL> alter trigger APPS.INSTEAD_OF_UPDATE disable;
Trigger altered.
SQL> alter trigger APPS.TAC_AUDIT_WLPN disable;
Trigger altered.
SQL> alter trigger APPS.TAC_ONHAND_QUANTITIES_DTL_BRI disable;
Trigger altered.
SQL> alter trigger APPS.TAC_PO_LIST_PRICE1 disable;
Trigger altered.
SQL> alter trigger APPS.TAC_UNIT_PRICE disable;
Trigger altered.
SQL> alter trigger APPS.XXTAC_BACK_ORDER_TXN disable;
Trigger altered.
SQL> alter trigger APPS.XXTAC_DELIVERY_CAP disable;
Trigger altered.
SQL> alter trigger APPS.XXTAC_MTLACCT_UPDATE_POUNIT disable;
Trigger altered.
SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@testplan ~]$
Drop MRC schema (conditional)
TUMS step key: N/A
All programs and reports now use the APPS schema. Because the MRC_APPS
schema is no longer needed, dropping it frees space and reduces processing
overhead during the upgrade. If you have not previously done so, drop the MRC
schema now.
UNIX:
$ cd APPL_TOP/admin
$ sqlplus/ @addrpmrc.sql
FORCE
QL> @addrpmrc.sql
Enter value for 1:
SQL>
SQL> @addrpmrc.sql APPLSYS FORCE
=============================================================
NAME
addrpmrc.sql
DESCRIPTION
Drop MRC schema if release >= 11.5.10.
=============================================================
Getting the name of the MRC schema….
begin
*
ERROR at line 1:
ORA-20000: MRC schema name not registered in FND_ORACLE_USERID
ORA-06512: at line 11
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
MRC Schema is not registered so we can ignore
Run adgrants
[oracle@testplan admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 14 20:19:27 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
1.Create $ORACLE_HOME/appsutil/admin on the database server.
2. Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin
to that in patch directory.
Or, compare the version of adgrants_nt.sql(Windows)
in %APPL_TOP%\admin to that in patch directory.
3. Copy the higher version of adgrants.sql (UNIX) to
$ORACLE_HOME/appsutil/admin.
Or, copy higher version of adgrants_nt.sql (Windows) to
%ORACLE_HOME%\appsutil\admin.
4. Set the environment to point to ORACLE_HOME on the database server.
5. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
.
SQL> @adgrants.sql apps
Connected.
==>Enable Maintenance Mode
==>ApplyAD 12.2 upgrade driver
Download and unzip the AD Upgrade Patch for 12.2 (patch 10117518).
************ Caution: Ensure that the environment file from the 12.2 RUN File System is sourced prior to applying this patch. ***************
Instructions to merge and apply R12.AD.C and AD CUP5 [required
When directed to apply AD 12.2.0 (R12.AD.C) in Chapter 3, Upgrading to Release 12.2 within “Oracle E-Business Suite Upgrade Guide 12.0 and 12.1 to 12.2” and “Oracle E-Business Suite Upgrade Guide 11i to 12.2”, perform the following steps instead:
1. Merge R12.AD.C (patch#10117518) and AD CUP5 patch (patch#18040523:R12.AD.C).
Note: This merge should be a full merge using -admode. Do not use -preinstall or – driveronly mode.
Example:
a. Download R12.AD.C (patch#10117518) and 12.2.0 AD CUP5 patch#18040523:R12.AD.C under /AD_source
b. mkdir -p /10117518_CUP4
c. admrgpch -s /d01/R12.2_patches -d /d01/10117518_CUP45-merge_name 10117518_cup5 -admode
2. Apply the merged patch driver in its entirety following the Pre-Install and Post-Install Tasks of R12.AD.C (patch#10117518) .
Got Perl issue while running admrgpch
[applmgr@testplan R12.2_patches]$ admrgpch
Perl lib version (5.10.0) doesn’t match executable version (v5.10.1) at /d01/oracle/uatapp/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi/Config.pm line 46.
Compilation failed in require at /d01/oracle/uatapp/fs1/FMW_Home/webtier/perl/lib/5.10.0/File/Copy.pm line 14.
BEGIN failed–compilation aborted at /d01/oracle/uatapp/fs1/FMW_Home/webtier/perl/lib/5.10.0/File/Copy.pm line 14.
Compilation failed in require at /d01/oracle/uatapp/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl line 40.
BEGIN failed–compilation aborted at /d01/oracle/uatapp/fs1/EBSapps/appl/ad/12.0.0/bin/admerge.pl line 40.
export PERL5LIB=/perl/lib/5.10.0:/perl/site_perl/5.10.0:/appsutil/perl
[applmgr@testplan R12.2_patches]$ admrgpch -s /d01/R12.2_patches -d /d01/10117518_CUP5 -merge_name 10117518_cup5 -admode
Executing the merge of the patch drivers
— Processing patch: /d01/R12.2_patches/10117518
— Processing file: /d01/R12.2_patches/10117518/u10117518.drv
— Done processing file: /d01/R12.2_patches/10117518/u10117518.drv
— Done processing patch: /d01/R12.2_patches/10117518
— Processing patch: /d01/R12.2_patches/18040523
— Processing file: /d01/R12.2_patches/18040523/u18040523.drv
— Done processing file: /d01/R12.2_patches/18040523/u18040523.drv
— Done processing patch: /d01/R12.2_patches/18040523
Copying files…
5% complete. Copied 47 files of 923…
10% complete. Copied 93 files of 923…
15% complete. Copied 139 files of 923…
20% complete. Copied 185 files of 923…
25% complete. Copied 231 files of 923…
30% complete. Copied 277 files of 923…
35% complete. Copied 324 files of 923…
40% complete. Copied 370 files of 923…
45% complete. Copied 416 files of 923…
50% complete. Copied 462 files of 923…
55% complete. Copied 508 files of 923…
60% complete. Copied 554 files of 923…
65% complete. Copied 600 files of 923…
70% complete. Copied 647 files of 923…
75% complete. Copied 693 files of 923…
80% complete. Copied 739 files of 923…
85% complete. Copied 785 files of 923…
90% complete. Copied 831 files of 923…
95% complete. Copied 877 files of 923…
100% complete. Copied 923 files of 923…
Character-set converting files…
2 unified drivers merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.
prepratch step :-
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy the higher version of adgrants.sql (UNIX) to
$ORACLE_HOME/appsutil/admin.
Set the environment to point to ORACLE_HOME on the database server.
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
************ Caution: Ensure that the environment file from the 12.2 RUN File System is sourced prior to applying this patch. ***************
[applmgr@testplan d01]$ cd 10117518_CUP5/
[applmgr@testplan 10117518_CUP5]$ ls -ltr
total 3100
drwxr-xr-x. 13 applmgrdba 4096 Oct 14 19:53 ad
drwxr-xr-x. 7 applmgrdba 4096 Oct 14 19:53 fnd
-rw-r–r–. 1 applmgrdba 1531771 Oct 14 19:53 j10117518_ad.zip
-rw-r–r–. 1 applmgrdba 767174 Oct 14 19:53 j10117518_fnd.zip
drwxr-xr-x. 2 applmgrdba 4096 Oct 14 19:53 metadata_files
drwxr-xr-x. 2 applmgrdba 4096 Oct 14 19:53 admin
-rw-r–r–. 1 applmgrdba 5336 Oct 14 19:53 10117518_README.txt
-rw-r–r–. 1 applmgrdba 8299 Oct 14 19:53 10117518_README.html
-rw-r–r–. 1 applmgrdba 160065 Oct 14 19:53 b10117518.ldt
-rw-r–r–. 1 applmgrdba 176668 Oct 14 19:53 f10117518.ldt
-rw-r–r–. 1 applmgrdba 632 Oct 14 19:53 18040523_README.txt
-rw-r–r–. 1 applmgrdba 3011 Oct 14 19:53 18040523_README.html
-rw-r–r–. 1 applmgrdba 5316 Oct 14 19:53 f18040523.ldt
-rw-r–r–. 1 applmgrdba 5977 Oct 14 19:53 b18040523.ldt
-rw-r–r–. 1 applmgrdba 465765 Oct 14 19:53 u_10117518_cup5.drv
Post step :-
1. Run adadmin -> Compile/Reload Applications Database Entities menu ->
Compile APPS schema.
2. Type “No” when prompt for Run Invoker Rights processing in incremental mode [No] ?
==>Apply all Consolidated Upgrade Patches (CUPs)
Apply all Consolidated Upgrade Patches (CUPs) listed in the Oracle E-Business
Suite-wide Release Notes, Release 12.2. Search for the Consolidated Upgrade Patches
(CUPs) section and follow the instructions on how to apply them.
ORACLE E-BUSINESS SUITE CONSOLIDATED UPGRADE PATCH 4 (CUP4) FOR R12.2.0 Patch#17197281
Oracle E-Business Suite Consolidated Upgrade Patch5 (CUP5) for Release 12.2 (patch 18007406:12.2.0)
Refer to step ‘Apply Consolidated Upgrade Patch and Run 12.2.0 Upgrade’ in section ‘4. Notes forUpgrade Customers’ of Oracle E-Business Suite Release Notes, Release 12.2 (MyOracle Support Knowledge Document 1320300.1)
Apply patch 18007406using adpatch preinstall=y (on Run File System)
==>beforeapplying this patch clean up the directory /admin//preinstall (rename it if exists)
[applmgr@testplan preinstall]$ pwd
/d01/oracle/uatapp/fs1/EBSapps/appl/admin/UAT/preinstall
[applmgr@testplan 18007406]$ cd /d01/oracle/uatapp/fs1/EBSapps/appl/admin/UAT/preinstall
[applmgr@testplan preinstall]$ ls -ltr
total 132
-rw-r–r–. 1 applmgrdba 132742 Oct 15 00:05 u18007406.drv
==>Run the American English upgrade patch driver
To bring your database to the full Oracle E-Business Suite Release 12.2 level, use AutoPatch to run the (American English) unified driver (u10124646.drv). It is located in $AU_TOP/patch/115/driver.
Caution: Ensure tablespace APPS_TS_TX_DATA has enough space (below the threshold) and resize the data file if necessary.
Source the environment file from the RUN file system and run the driver on the administration server node on your Release 12.2 APPL_TOP using the following commands:
TABLESPACE_NAME FILE_NAME BYTES/1024/1024 MAXBYTES/1024/1024 AUT
—————————— ———————————————————— ————— —————— —
APPS_TS_TX_DATA /d01/oracle/uatdb/uatdata/APPS_TS_TX_DATA01.dbf 8000 15360 YES
APPS_TS_TX_DATA /d01/oracle/uatdb/uatdata/APPS_TS_TX_DATA02.dbf 8000 15360 YES
APPS_TS_TX_DATA /d01/oracle/uatdb/uatdata/APPS_TS_TX_DATA03.dbf 8000 15360 YES
APPS_TS_TX_DATA /d01/oracle/uatdb/uatdata/APPS_TS_TX_DATA04.dbf 8000 15360 YES
APPS_TS_TX_DATA /d01/oracle/uatdb/uatdata/APPS_TS_TX_DATA05.dbf 8000 15360 YES
APPS_TS_TX_DATA /d01/oracle/uatdb/uatdata/APPS_TS_TX_DATA06.dbf 8000 15360 YES
==>Merge the patch drivers in $APPL_TOP/admin/$TWO_TASK/preinstall directory with the 12.2.0 upgrade driver $AU_TOP/patch/115/driver/u10124646.drv(1320300.1)
cd $AU_TOP/patch/115/driver
[applmgr@testplan driver]$ admrgpch -d . -preinstall -master u10124646.drv
Executing the merge of the patch drivers
— Processing file: /d01/oracle/uatapp/fs1/EBSapps/appl/admin/UAT/preinstall/u18007406.drv
— Done processing file: /d01/oracle/uatapp/fs1/EBSapps/appl/admin/UAT/preinstall/u18007406.drv
— Processing file: u10124646.drv
— Done processing file: u10124646.drv
2 unified drivers merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.
==> The default merged driver by name u_merged.drv is then created in the destination directory that is specified.
[applmgr@testplan driver]$ ls -ltr
total 177300
-rwxr-xr-x. 1 applmgrdba 755 Nov 24 2012ausstats.drvx
-rw-r–r–. 1 applmgrdba 83457868 Nov 25 2012 u10124646.drv
-rw-r–r–. 1 applmgrdba 14305818 Nov 25 2012 u10201000.drv
-rwxr-xr-x. 1 applmgrdba 242 Oct 15 00:03 augenmsg.drvx
-rw-r–r–. 1 applmgrdba 83774363 Oct 15 00:13 u_merged.drv
-rw-r–r–. 1 applmgrdba 1099 Oct 15 00:13 admrgpch.log
[applmgr@testplan driver]$ du -sh u10124646.drv
80M u10124646.drv
[applmgr@testplan driver]$ pwd
/d01/oracle/uatapp/fs1/EBSapps/appl/au/12.0.0/patch/115/driver
$ adpatch options=nocopyportion,nogenerateportion
Apply the newly merged 12.2.0 upgrade driver u_merged.drv with adpatch options=nocopyportion,nogenerateportion. using RUN File System.
==>issue:-
adwork001.log:
sqlplus -s APPS/***** @/d01/oracle/uatapp/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/d01/oracle/uatapp/fs1/EBSapps/appl/xdp/12.0.0/patch/115/sql/XDPMIGFX.sql ‘
Connected.
PL/SQL procedure successfully completed.
DECLARE
*
ERROR at line 1:
ORA-20100: File XDPMIGFX20141015123507.out creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 410
ORA-06512: at “APPS.FND_FILE”, line 517
ORA-06512: at line 69
sqlplus -s APPS/***** @/d01/oracle/uatapp/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/d01/oracle/uatapp/fs1/EBSapps/appl/xdp/12.0.0/patch/115/sql/XDPMIGFX.sql ‘
Connected.
PL/SQL procedure successfully completed.
adwork002.log:
DECLARE
*
ERROR at line 1:
ORA-20100: File XDPMIGFX20141015123507.out creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 410
ORA-06512: at “APPS.FND_FILE”, line 517
ORA-06512: at line 69
sqlplus -s APPS/***** @/d01/oracle/uatapp/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/d01/oracle/uatapp/fs1/EBSapps/appl/jtf/12.0.0/patch/115/sql/jtfpfcreate.sql &un_apps&un_jtf’
Connected.
PL/SQL procedure successfully completed.
DECLARE
*
ERROR at line 1:
ORA-20100: File o0089424.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 410
ORA-06512: at “APPS.FND_FILE”, line 517
ORA-06512: at line 36
ISSUE 2:
AD Worker error:
The following ORACLE error:
ORA-04007: MINVALUE cannot be made to exceed the current value
occurred while executing the SQL statement:
ALTER SEQUENCE IEM.IEM_ACCOUNT_TAG_KEYS_S1 MINVALUE 10000
AD Worker error:
Unable to compare or correct sequences
because of the error above
solution:
ORA-04007 Error When Altering Email Center Sequences (Doc ID 1140115.1)
The sequence has not previously been used and requires initialization prior to executing the alter statement.
SQL> select IEM.IEM_ACCOUNT_TAG_KEYS_S1.nextval from dual;
NEXTVAL
———-
10000
SQL> select IEM.IEM_TAG_KEYS_S1.nextval from dual;
NEXTVAL
———-
10000
SQL> select IEM.IEM_ENCRYPTED_TAGS_S1.nextval from dual;
NEXTVAL
———-
10000
SQL> select IEM.IEM_ENCRYPTED_TAG_DTLS_S1.nextval from dual;
NEXTVAL
———-
10000
ISSUE 3:
ERROR
———————–
CREATE UNIQUE INDEX CN.”CN_SCA_RULE_ATTRIB_ALL_TL_U2″ ON
CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL (SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE)
LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
MAXTRANS 225 COMPUTE STATISTICS TABLESPACE APPS_TS_SEED
AD Worker error:
The index cannot be created as the table has duplicate keys.
Solution:
During Upgrade to 12.2.0, Script CNSCA.ODF Fails – Create Index CN_SCA_RULE_ATTRIB_ALL_TL_U2 – The index cannot be created as the table has duplicate keys.(Doc ID 1674721.1)
(2) Create a copy of the table cn_sca_rule_attributes_all_tl
CREATE table cn_sca_rule_attrib_all_tl_bkp AS SELECT * FROM cn_sca_rule_attributes_all_tl;
CN_SCA_RULE_ATTRIBUTES_ALL_TL
(3) Delete the unregistered/in-active Language records in the instance
DELETE FROM cn_sca_rule_attributes_all_tl WHERE org_id IS NULL;
(4) Run the failed job again (cnsca.odf).
ISSUE 4:
Uploading from the data file /d01/oracle/uatapp/fs1/EBSapps/appl/iec/12.0.0/patch/115/import/US/iecadmmn.ldt
Error loading seed data for FUNCTION: FUNCTION_NAME = IEC_SETUP_SSS, ORA-00001: unique constraint (APPLSYS.FND_FORM_FUNCTIONS_U2) violated
ORA-06512: at “APPS.FND_FORM_FUNCTIONS_PKG”, line 1157
ORA-06512: at “APPS.FND_FORM_FUNCTIONS_PKG”, line 897
ORA-01403: no data found
Solution
R12 Upgrade Fails On Upload Of File Iecadmmn.ldt (Doc ID 452082.1)
SQL> select function_id from fnd_form_functions where function_name=’IEC_SETUP_SSS’;
FUNCTION_ID
———–
11733
SQL> delete from FND_FORM_FUNCTIONS where FUNCTION_ID =11733;
1 row deleted.
SQL> commit;
Commit complete.
ISSUE 5:
ISSUR 6:
Importing file “/d01/oracle/uatapp/fs1/EBSapps/appl/msc/12.0.0/mds/mscntexc/webui/MSC_NET_EXCP_HEADER.xml” as “/oracle/apps/msc/mscntexc/webui/MSC_NET_EXCP_HEADER”.
Error:
ORA-01654: unable to extend index APPLSYS.JDR_COMPONENTS_N1 by 128 in tablespace APPS_TS_SEED
ATTENTION: All workers either have failed or are waiting:
FAILED: file XMLImporter.class on worker 1.
FAILED: file XMLImporter.class on worker 2.
FAILED: file XMLImporter.class on worker 3.
FAILED: file XMLImporter.class on worker 4.
FAILED: file XMLImporter.class on worker 5.
FAILED: file XMLImporter.class on worker 6.
FAILED: file XMLImporter.class on worker 7.
FAILED: file XMLImporter.class on worker 8.
FAILED: file XMLImporter.class on worker 9.
FAILED: file XMLImporter.class on worker 10.
FAILED: file XMLImporter.class on worker 11.
FAILED: file XMLImporter.class on worker 12.
FAILED: file XMLImporter.class on worker 13.
FAILED: file XMLImporter.class on worker 14.
FAILED: file XMLImporter.class on worker 15.
FAILED: file XMLImporter.class on worker 16.
Added the space to the mentioned tablespace
TABLESPACE_NAME NUM_FILES FREE_BYTES MAX_BYTES USED_BYTES PERCENT_USED
—————————— ——— ————– ————– ————– ————
APPS_TS_ARCHIVE 2 1724907520 8388608000 8388608000 80
APPS_TS_INTERFACE 2 1577058304 6291456000 6291456000 75
APPS_TS_MEDIA 1 68157440 2097152000 2097152000 97
APPS_TS_QUEUES 2 805306368 6291456000 6291456000 88
APPS_TS_TX_IDX 7 5098176512 51380224000 51380224000 91
SYSTEM 2 966516736 11534336000 11534336000 92
Disable the Maintenance Mode
Add following parameters in init.ora w.r.t 11.2.0.4
alter system set parallel_force_local=TRUE scope=both;
alter system set sec_case_sensitive_logon=FALSE scope=both;
alter system set plsql_code_type=NATIVE scope=both;
Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
==>Configure Release 12.2 E-Business Suite instance
Update the RDBMS ORACLE_HOME file system with AutoConfig and Clone files
On the application tier (as the APPLMGR user), log on to the APPL_TOP environment (source the environment file) and run this perl script to create
appsutil.zip in /admin/out. Source the applications run file system environment file as found in the fs1 file system appl_top.
perl/bin/admkappsutil.pl
[oracle@testplan 11.2.0]$ mv appsutil.zip appsutil.zip.old
[oracle@testplan 11.2.0]$ cp /d01/oracle/uatapp/inst/fs1/inst/apps/UAT_testplan/admin/out/appsutil.zip .
[oracle@testplan 11.2.0]$ ls -ltr appsutil.zip
-rw-r–r–. 1 oracle dba 3359578 Oct 16 14:19 appsutil.zip
On the database tier (as the ORACLE user), copy or FTP the appsutil.zip file tothe and unzip the file. Change directory to RDBMS
Oracle Home as follows:
cd
Unzip the file with the following command:
unzip -o appsutil.zip
Create a directory such as RDBMS_ORACLE_HOME
under $ORACLE_HOME/network/admin, where CONTEXT_NAME is
_. Copy listener.ora and tnsnames.ora from the
$ORACLE_HOME/network/admin directory to the
$ORACLE_HOME/network/admin/ directory.
Note: If the context directory RDBMS_ORACLE_HOME
already exists and it already contains the listener.ora and the
tnsnames.ora files, then skip the above step. Also verify that
these files were correctly generated through autoconfig by
checking the timestamp from the last autoconfig run, ensuring
that they were properly instantiated. For example, for the
listener.ora, check that there are correct SID references that
came from the %s_db_listener% value in the $CONTEXT_FILE.
==>Set and export the following environment variables.
export ORACLE_HOME=/d01/oracle/uatdb/11.2.0
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
export ORACLE_SID=UAT
exportPATH=$ORACLE_HOME/bin:/usr/bin:/usr/sbin:$ORACLE_HOME/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:$PATH
exportTNS_ADMIN=$ORACLE_HOME/network/admin/UAT_testplan
==>Generate a new database context file as follows:
Note: This step applies only to customers using their existing RDBMS home during the upgrade.
UNIX: cd /appsutil/bin
perl adbldxml.pl
[oracle@testplan bin]$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /d01/oracle/uatdb/11.2.0/appsutil/jre/bin/java to execute java programs..
APPS Password:
The log file for this adbldxml session is located at:
/d01/oracle/uatdb/11.2.0/appsutil/log/adbldxml_10161430.log
Enter Database Service Name: UAT
Enter the value for Display Variable: testplan:0.0
Context File /d01/oracle/uatdb/11.2.0/appsutil/UAT_testplan.xml
already exists.
Overwriting Context File may cause loss of existing settings, hence
backing it up as: /d01/oracle/uatdb/11.2.0/appsutil/UAT_testplan.xml.bak
The context file has been created at:
/d01/oracle/uatdb/11.2.0/appsutil/UAT_testplan.xml
==>Clean up old node information.
-> Check for existence of old nodes:
selectnode_name from fnd_nodes;
->If there are additional nodes listed in FND_NODES, then clean-up the
nodes. Connect to sqlplus from the DB Tier as apps user and run the following statement:
execfnd_conc_clone.setup_clean ;
==>Run AutoConfig on the database tier nodes.
Run autconfig on db side
Apps tier :-
Source the Run filesystem environment file.
Prior to running AutoConfig check if table – ADX_PRE_AUTOCONFIG isexisting in APPS schema:
selectobject_name, object_type, owner, status from dba_objects whereupper(object_name)=’ADX_PRE_AUTOCONFIG’ and object_type=’TABLE’
and upper(owner)=’APPS’;
To drop table ADX_PRE_AUTOCONFIG from APPS schema and recreate in APPLSYS schema, execute the following commands:
cd/patch/115/sqlsqlplus APPS/
@txkDropAdxPreAutoConfig.sql
==> RunAutoConfig on all the Application Tier nodes using the following
commands:
UNIX:
$ADMIN_SCRIPTS_HOME/adautocfg.sh
==>Run Rapid Install to configure Release 12.2 E-Business Suite instance.
You must run Rapid Install a second time to complete the configuration using Run FileSystem context file.
/d01/oracle/uatapp/inst/fs1/inst/apps/UAT_testplan/appl/admin/UAT_testplan.xml
Enter weblogic
password welcome1
==>Reapply customizations (conditional).
If you customized application environment files (APPLSYS.env or devenv), thenreintegrate them in devenv.env, or in the adovars.env file ($APPL_TOP/admin for
UNIX or %APPL_TOP%\admin for Windows). Restart the application serverprocesses so changes take effect.
==>Online patching
Refer to Using the Online Patching Readiness Report in Oracle E-Business Suite Release
12.2 (Doc ID 1531121.1) for instructions on how to download these utilities.
1)Initialize the Run File System environment:
2)Create the online patching log file location and set it as the current directory:
mkdir $LOG_HOME/appl/op
Apply E-Business Suite:Online Patching Readiness and GSCC Report patch
18824534 applicable to your EBS instance’s release version (For example: apply 18824534:R12.AD.C on 12.2 or higher, 18824534:R12.AD.B on Release 12.1 based environment)
apply patch p18824534_R12.AD.C_R12_GENERIC.zip
cd $LOG_HOME/appl/op
[applmgr@testplan 18824534]$ adpatch options=hotpatch
Once it is applied, Auto-patch will copy SQL files from patch to
$AD_TOP/sql/ADZDPSUM.sql
$AD_TOP/sql/ADZDPAUT.sql
$AD_TOP/sql/ADZDPMAN.sql
$AD_TOP/sql/ADZDDBCC.sql
$AD_TOP/sql/ADZDPCUST.sql location.
STEP#1: Run $AD_TOP/sql/ADZDPSUM.sql
====================================
This script should be run by SYSTEM schema of ORACLE database.
For Example:
sqlplus system/@DB @$AD_TOP/sql/ADZDPSUM.sql
OR
sqlplussystem@DB @$AD_TOP/sql/ADZDPSUM.sql
sqlplus system/manager@UAT@$AD_TOP/sql/ADZDPSUM.sql
mv adzdpsum.txt adzdpsum_pre_dbprep.txt
STEP#2: and STEP#3:
==================
In the same way as STEP#1 has been performed for @$AD_TOP/sql/ADZDPSUM.sql,
it should be repeated for
@$AD_TOP/sql/ADZDPMAN.sql and
sqlplus system/manager@UAT@$AD_TOP/sql/ADZDPMAN.sql
mv adzdpman.txt adzdpman_pre_dbprep.txt
@$AD_TOP/sql/ADZDPAUT.sql also
sqlplus system/manager@UAT@$AD_TOP/sql/ADZDPAUT.sql
mv adzdpaut.txt adzdpaut_pre_dbprep.txt
STEP#4: Run ADZDDBCC.sql
========================
This script should be run by APPS schema of E-business Suite.
For Example:
sqlplus APPS/@DB @$AD_TOP/sql/ADZDDBCC.sql
NOTE: Currently these scripts share common objects names, hence should be
run sequentially.
We are not sure how to proceed with online patching, so raised an SR 3-8790550338 : Oracle E-Business Suite Online Patching issue..
SQL> exec fnd_oracle_user_pkg.load_row(‘EDWREP’, ‘CUSTOM’, ‘INVALID’, NULL, ‘N’, ‘B’);
PL/SQL procedure successfully completed.
SQL> exec fnd_oracle_user_pkg.load_row(‘ODM’, ‘CUSTOM’, ‘INVALID’, NULL, ‘N’, ‘B’);
ERROR:
ORA-01756: quoted string not properly terminated
SQL>
SQL>
SQL>
SQL> exec fnd_oracle_user_pkg.load_row(‘ODM’, ‘CUSTOM’, ‘INVALID’, NULL, ‘N’, ‘B’);
PL/SQL procedure successfully completed.
SQL>
SQL> execfnd_oracle_user_pkg.load_row(‘PORTAL30’, ‘CUSTOM’, ‘INVALID’, NULL, ‘N’, ‘B’);
PL/SQL procedure successfully completed.
SQL> execfnd_oracle_user_pkg.load_row(‘PORTAL30_SSO’, ‘CUSTOM’, ‘INVALID’, NULL, ‘N’, ‘B’);
PL/SQL procedure successfully completed.
SQL> execfnd_oracle_user_pkg.load_row(‘TACCUS’, ‘CUSTOM’, ‘INVALID’, NULL, ‘N’, ‘B’);
PL/SQL procedure successfully completed.SQL> commit;
Commit complete.
==>Run the following report to retrieve the current tablespace free space:
perl $AD_TOP/bin/adzdreport.pl apps
1. Select option 3 – ‘Other Generic Reports’
2. Select the next option – ‘Free Space in Important Tablespaces’
3. Enter the password when prompted.
. Ensure the following:
SYSTEM Tablespace: has a minimum of 25 GB of free space
APPS_TS_SEED Tablespace: has a minimum of 5 GB of free space
APPS_TS_SEED is used to host all tables that have been registered as seed tables and that require seed data storage infrastructure.
perl $AD_TOP/bin/adzdreport.pl apps
Enter the APPS Password:
Online Patching Diagnostic Reports Main Menu
——————————————–
1. Run edition reports
2. Patch edition reports
3. Other generic reports
4. Exit
Enter your choice [4]: 3
Other Generic Reports Sub Menu
——————————
1. Editions summary
2. Editioned objects summary
3. Free space in important tablespaces
4. Status of critical AD_ZD objects
5. Actual objects in current edition
6. Objects dependencies
7. Objects dependency tree
8. Editioning views column mappings
9. Index details for a table
10. Inherited objects in the current edition
11. All log messages
12. Materialized view details
13. Database sessions by edition
14. Table details (Synonyms, EV, etc.)
15. Count and status of DDL execution by phase
16. Back to main menu
Enter your choice [16]: 3
===============================================================================
=========================================================================
= Important Tablespace Status
=========================================================================
TABLESPACE_NAME TOTAL_SPACE(GB) USED_SPACE(GB) FREE_SPACE(GB) PCT_USED
—————————— ————— ————– ————– ——–
APPS_TS_SEED 3.91 2.60 1.31 66.48
APPS_TS_TX_DATA 86.99 73.91 13.08 84.96
APPS_TS_TX_IDX 67.38 55.05 12.33 81.70
SYSTEM 13.47 10.46 3.02 77.61
Space seems ok
==============================================================================
==>Ensure that all middle-tier E-Business Suite services are shut down
==>Download and apply the Online Patching Enablement patch(This patch will run around 4+ hours)
Download and apply the Online Patching Enablement patch: 13543062:R12.AD.C.
Use Autopatch in hotpatch mode to apply the patch.
Important: While applying the Online Enablement patch, you may receive the following error: ‘Attention: Adpatch should no longer
be used to apply patches. Please use fpreinstall tool for applying patches.’ If you receive this error, then you must use adop in hotpatch mode to apply the enablement patch.
Monitor the Online Patching Enablement patch application:-
sqlplus @$AD_TOP/sql/ADZDSHOWDDLS.sql
==>Compile Invalid objects
==>. Run the Online Patching Enablement Status Report after the Online Patching Enablement patch has been applied
1. Set the current directory to $LOG_HOME/appl/op:
cd $LOG_HOME/appl/op
2. Run the Status Report immediately after the enablement patch completes:
sqlplus @$AD_TOP/sql/ADZDEXRPT.sql
Note: You must provide the APPS schema password when
prompted.
The purpose of running this report at this stage is to identify and fix any errors that
occurred during the enablement process.
==>Re-run the Online Patching Enablement Readiness Report after the Online Patching Enablement patch has been applied
Patching Enablement patch has been applied
1. Set the current directory to $LOG_HOME/appl/op:
cd $LOG_HOME/appl/op
2. Run the Readiness Report after the enablement patch completes:
sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
Note: You must provide the SYSTEM schema password when
mv adzdpsum.txt adzdpsum_post_dbprep.txt
sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
mv adzdpman.txt adzdpman_post_dbprep.txt
sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
mv adzdpaut.txt adzdpaut_post_dbprep.txt
The purpose of running this report at this stage is to ensure that all EBR violations that could have appeared before enabling the online patching featureare fixed.
prompted.
==>Database Initialization Parameters
Oracle E-Business Suite Release 12.2 introduces a new database service called ebs_patch that supports online patching. The ‘service_names’ parameter specifies one or more
names by which users can connect to an environment. The environment registers its service names with the listener. When a user requests a service, the listener determines
which environments offer the requested service, and then routes the user to the most appropriate environment.
For example:
service_names=%s_dbSid%,ebs_patch
The ‘recyclebin’ parameter must be turned off to allow the cleanup phase of the online patching cycle to be performed without having to connect as SYS. This feature may still
be used at other times.
For example:
recyclebin=off
Note: The parameters described in this section apply to Oracle E-Business Suite Release 12.2 on Oracle Database 11g Release 2
(11.2.0.4). For details, refer to Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID: 396009.1).
Oracle E-Business Suite NLS Release 12.2.0 Latin American Spanish
Instructions:
Apply the following unified driver file located in 10124646_ESA directory, with AD Online Patching:
u10124646.drv
==>Post Upgrade Tasks
==>Apply latest AD and TXK for Release 12.2
Start up only the Weblogic Admin Server (required)
On Run File System, start up only the Weblogic Admin Server service using
adadminsrvctrl script as follows:
UNIX:
sh/adadminsrvctl.sh start
==>Apply latest AD and TXK patchsets
AD Delta 5 Patch 18283295; (Need to apply language patches)
TXK Delta 5 Patch 18288881.(Need to apply language patches)
Patch 18886213:R12.TXK.C
Patch 19259764:R12.FND.C(Need to apply language patches)
Download patches under $APPL_TOP_NE/../patch
–>Follow Document 1617461.1 and apply above patches, we have to follow PATH A:
Source the run edition environment file.
Run adgrants :-
Create $ORACLE_HOME/appsutil/admin
Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.
[applmgr@testplan admin]$ mkdir $ORACLE_HOME/appsutil/admin
[applmgr@testplan admin]$ cd $ORACLE_HOME/appsutil/admin
[applmgr@testplan admin]$ pwd
/d01/oracle/uatapp/fs1/EBSapps/10.1.2/appsutil/admin
[applmgr@testplan admin]$ cp /d01/oracle/uatapp/fs_ne/EBSapps/patch/18283295/admin/adgrants.sql .
[applmgr@testplan admin]$ ls -ltr
total 100
-rwxr-xr-x. 1 applmgrdba 99663 Oct 17 23:11 adgrants.sql
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
adop phase=apply patches=18283295 hotpatch=yes
adop phase=apply patches=18288881,18886213 hotpatch=yes merge=yes
adop phase=apply patches=19259764 hotpatch=yes – not required
Note: This step is not applicable for new installation and upgrade customers who are applying the Oracle E-Business Suite Release 12.2.4 Release Update Pack.
Source the run edition environment file.
UNIX:
$ . /EBSapps.env run
If you are ultimately going to apply the Oracle E-Business Suite 12.2.2 (or later) Release Update Pack, you must now synchronize the file systems by running the following command:
$ adop phase=fs_clone
.adop phase=abort
R12.2.4 Upgrade Pack.
Section 1: Preparation
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)
Section 2: Apply Required Database Patches – Already Done
Review My Oracle Support Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes, and apply all required patches for your database version.
Note: Refer to My Oracle Support Knowledge Document 1355068.1, Oracle E-Business Suite 12.2 Patching Technology Components Guide, for guidance with database patch application.
Section 3: Apply Consolidated Seed Table Upgrade Patch (Required)
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
Apply the consolidated seed table upgrade Patch 17204589:12.2.0 on the run file system using adophotpatch mode.
adop phase=apply patches=17204589 hotpatch=yes
Section 4: Apply the Latest AD and TXK Delta Release Update Packs – Already done
Section 5: Perform Pre-Update Steps (Conditional)
Package Name File Version
INL_CUSTOM_PUB INLPCUSB.pls
120.6.12020000.6
INLPCUSS.pls
120.5.12020000.5
Package NameFileVersionWMS_LABEL_CUSTOM_PKGWMSLACPB.pls
120.0.12020000.3
WMSLACPS.pls
120.1.12020000.5
Section 6: Apply Oracle E-Business Suite 12.2.4 Release Update Pack
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
Apply Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 on the run edition application environment, using downtime mode.
adop phase=apply apply_mode=downtime patches=17919161
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
adop phase=cleanup
adop phase=fs_clone
Login Page with responsibilities
WebLogic Console
Post Steps after the patching
Got Login page and Concurrent manager issue, Raised SR and worked with them to resolve the issue
Post upgrade validation and Post upgrade steps
10.2.0.4 32bit Conversion to 10.2.0.4 64bit after the upgrade to 11.2.0.4 and OATM Conversion Document above
Tried to provide the steps as simplified as possible. My intent is to show the basic steps for upgrade and to share some knowledge on particular topic.
oraclemakeeasy 