This is a step by step upgrade of EBS 12.1.1 to EBS
12.2.7. EBS 12.2.7 was released on September,
8th 2017 and more details can be found under https://blogs.oracle.com/stevenchan/oracle-e-business-suite-1227-now-available.
There is no direct upgrade path from EBS 12.1.1 to EBS
12.2.7. Release 12.1.1 customers must first upgrade to EBS 12.2 before applying
12.2.7.
The following is a summary of the steps for each category:
1.Prepare the Database
2.Upgrade the database to the minimum version or latest certified version
3.Migrate to a new platform (optional)
4.Apply the latest database patches
5.Lay Down the Oracle E-Business Suite Release 12.2 File System
6.Use Rapid Install to lay down the file system and technology stack
7.Apply the latest application tier technology stack patches
8.Upgrade to Release 12.2.0
9.Apply the latest AD upgrade patch and Oracle E-Business Suite Consolidated Upgrade Patch (CUP)
10.Apply the latest Oracle E-Business Suite pre-install patches
11.Apply the 12.2 merged upgrade driver
12.Run Rapid Install in 'configure' mode
13.Enable Online Patching
14.Apply the latest Online Patching Readiness Report Patch
15.Apply required updates to custom code according to the readiness reports
16.Apply the enablement patch
17.Upgrade to the latest code
18.Apply the latest AD-TXK RUP
19.Apply the latest Oracle E-Business Suite Release 12.2 Release Update Pack (RUP)
Note: You must apply the 12.2.3 or later Release Update Pack (RUP) to your existing Release 12.2 system for production use.
RUPs are released periodically. Each one is cumulative and delivers error corrections and system updates, not only for the most current release update pack, but also for all the RUPs that precede it. Oracle highly recommends that when planning your upgrade you plan to upgrade to the latest RUP available.
You can keep current on the latest release information, as well as new RUP announcements and other updates that may affect your upgrade by reviewing the latest version of Oracle Applications Release Notes Release 12.2.0.
20.Complete post-upgrade steps
21.Apply the latest security patches
22.Apply all recommended patches
23.Apply NLS patches (conditional)
24.Deploy custom code, external integrations and third-party integrations
25.Perform advanced configurations
26.Scale up and/or scale out (add additional managed servers, add application tier nodes, add RAC nodes, and so on)
Note: The upgrade process is performed with one application tier and one database tier. If you are using an Oracle RAC environment, then you should run the Release 12.2 upgrade on a single Oracle RAC node. The reason for upgrading with a single Oracle RAC node is that most of the elapsed time in the upgrade will be taken by jobs running DML (INSERT, UPDATE, DELETE). These jobs use multiple workers and parallel servers, which typically attempt to access the same objects and blocks concurrently. The consequent additional communication between cluster nodes (and associated cluster waits) significantly outweigh any gains from using the additional CPU's to increase throughput. Scaling out is a post-upgrade step.
27.Secure configurations
28.DMZ configuration
29.Disaster recovery setup
30.Reporting environment setup
31.Perform product specific tasks
Some products include tasks that must be performed after the upgrade is complete. The main project steps can be segregated as below:
Phase 1
- Upgrade the database on the existing EBS 12.1: apps DBA team
- Execute a functional test: EBS functional team
Phase 2
- Install all application pre-upgrade patches: apps DBA team
- Verify the instance: EBS functional team
Phase 3
- Execute all functional pre-upgrade tasks including customizations: functional team
- Perform a full system backup: System and apps DBA team
Phase 4
- Apply localization and 12.2 pre-upgrade patches: apps DBA team
- Upgrade to 12.2.0: apps DBA team
- Enable online patching: apps DBA team
- Apply tech stack patches: apps DBA team
- Upgrade to 12.2.6/12.2.7: apps DBA team
- Perform all post-upgrade tasks: apps DBA and functional teams
- Application function test cases: core business users.
So without further delay, let’s jump to the steps.
I had an EBS 12.1.1 running with Database 11.1.0.7. As part
of the process, the database has to be first upgraded to minimum version(11.2.0.4) or
latest certified version.
I have upgraded the database first to 12.1.0.2.
You can refer to my blog on how to upgrade http://samappsdba.blogspot.in/2017/01/ebs-db-11107-upgrade-to-12c-12102.html
Now my current environment is
EBS -12.1.1 running with Database-12.1.0.2
Now the upgrade process:-
1. Back up database, Oracle E-Business Suite, and
customizations (recommended): Note: Shut down the database with the NORMAL
option. You may not be able to restore it from the backup if you use the
IMMEDIATE or ABORT option.
2. If there any customizations, take a backup of those and
customized help files(HTML)
3. If you have customized forms with Oracle Forms 6i, then
upgrade them to Oracle Forms 10i after the upgrade
4. Drop event alert triggers in custom schemas
(conditional):
To drop all event alert database triggers in custom schemas,
run the alrdtrig.sql script,
located in $ALR_TOP/patch/115/sql. Re-create the triggers
after the upgrade is
complete.
5. Review sizes of old and new tablespaces (required): Make
sure you allocate sufficient tablespace. For guidelines, see Oracle E-Business
Suite Release 12.2: Upgrade Sizing and Best Practices (Doc ID: 1597531.1).
6. Migrate Existing Objects to New Tablespace Model
(recommended): Oracle E-Business Suite Release 12 environments contain the new
Oracle Applications Tablespace Model (OATM). This model is based on database
object type rather than product affiliation, making it simpler to manage and
requiring far fewer tablespaces and operating system files. If you previously
upgraded your environment from Release 11i to Release 12, then the upgrade
process created tablespaces for all new products, configured the database for
the new tablespace model, and created new objects. However, it did not
automatically migrate your existing objects. If you have not already done so,
Oracle strongly recommends that you use the Tablespace Migration Utility to
perform this migration now. Note that this utility is not supported for use
after you enable Online Patching, so you cannot perform the migration after
your environment is upgraded to Release 12.2. If you choose not to migrate to
OATM now, then you must continue to manage your tablespaces separately. For
more information, see the Oracle E-Business Suite Setup Guide, Release 12.2.
7. Gather SYS, Fixed Object and Dictionary Statistics
(required)
login 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; /
2. Fixed Object and Dictionary Statistics
8. Gather schema statistics (required)
9. Install JRE on the database tier (conditional)
10. Reset init.ora parameters (required)
Database Initialization
Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
Additional Database Initialization Parameters
For Oracle E-Business Suite Release 12.2
SQL> ALTER SYSTEM SET recyclebin = OFF scope=spfile;
System altered.
SQL> show
parameter service
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
service_names string PROD
SQL> alter system set service_names=PROD,ebs_patch
scope=spfile;
System altered.
SQL> alter system
set local_listener='PROD_LOCAL' scope=spfile;
System altered.
SQL> alter system
set local_listener='PROD_LOCAL' scope=spfile;
System altered.
Set SQLNET.ALLOWED_LOGON_VERSION=8 in the
oracle_home/network/admin/sqlnet.ora file.
Restart your database
Restart your database
Human Resource
Management (HRMS)
SQL> SELECT
package_name,object_name,argument_name,data_type FROM all_arguments WHERE
(package_name,object_name) IN (SELECT call_package,call_procedure FROM
hr_api_hook_calls) AND data_type = 'LONG';
PACKAGE_NAME
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
ARGUMENT_NAME
--------------------------------------------------------------------------------
DATA_TYPE
------------------------------
PSB_HR_POPULATE_DATA_PVT
INSERT_POSITION_TXN_INFO
P_COMMENTS
LONG
Changed long to CLOB
Ref : https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T580873.htm#T609999
Stage Creation (Root
user)
R12.2: How to Create the Stage in Preparation for
Installation (Doc ID 1596433.1)
This should be done using the latest startCD. At the time of
writing this blog, the latest one is startCD51.
Build the stage
[root@ebs1 bin]# sh
buildStage.sh
Copyright (c) 2002, 2013 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Install
Version
12.2.0
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]: 1
Rapid Install Platform Menu
------------------------------------------------------
1. Oracle Solaris SPARC (64-bit)
2. Linux x86 (64-bit)
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu
Enter
your choice [5]: 2
Running command:
/u01/stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java
-classpath
/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/java
oracle.apps.ad.rapidwiz.util.StageBuilder /u01/stage/startCD/Disk1/rapidwiz/bin
Linux_x64 Linux_x64
Specify the directory
containing the zipped installation media:
/u01/stage
File list:
/u01/stage/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The set of zip files
is complete.
Unzip command is:
/u01/stage/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Press Enter to
continue...
Archive:
/u01/stage/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14272383/p14272383_1036_Generic.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/20484781/p20484781_111190_Generic.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip
extracting:
/u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/16241466/p16241466_10123_LINUX.zip
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]: 2
Rapid Install Platform Menu
------------------------------------------------------
1. Oracle Solaris SPARC (64-bit)
2. Linux x86 (64-bit)
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu
Enter
your choice [5]: 2
Directory
/u01/stage/TechPatches
Stage Builder will now
stage the one-off patches for Linux_x64...
Press Enter to
continue...
Press Enter to
continue...
Archive:
/u01/stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
Finished copying
additional patches.
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]:4
Now, start the
rapidwiz process.
Now layout EBS 12.2
file system using existing Oracle Home
I will be updating the full steps here once i get time. Meanwhile, please contact me over my email samratsinha05@gmail.com if you want the complete step by step document.
:
References:-
Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)
https://docs.oracle.com/cd/E26401_01/doc.122/e48839.pdf-upgrade guide
Best Practices for Minimizing Oracle E-Business Suite Release 12.1.3 and 12.2.n Upgrade Downtime (Doc ID 1581549.1)
R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)
Upgrade Advisor: E-Business Suite (EBS) Upgrade from 12.0/12.1 to 12.2.x (Doc ID 1593640.1)
Oracle E-Business Suite Reducing Downtime Upgrading to 12.1/12.2 (Doc ID 1578187.1)
Upgrade Advisor: E-Business Suite (EBS) Upgrade from 12.0/12.1 to 12.2.x (Doc ID 1593640.1)
Oracle E-Business Suite Reducing Downtime Upgrading to 12.1/12.2 (Doc ID 1578187.1)
