Oracle has announced on October 18, 2019, they were moving to a Continuous Innovation support model for Oracle E-Business Suite 12.2 and that there will be no 12.3 release.
This post covers a high-level overview of :
- Why Upgrade to EBS R12.2
- Why Upgrade to Database 19c
- Thing You Must Learn Before the EBS Upgrade
- EBS Upgrade Paths
- Upgrade High-level Steps
Why Upgrade To EBS R12.2?
- Oracle Apps DBA is in great demand and with 12.2 experience
- Good Salary if you know 12.2 as 11i & 12.0 out of support
- Customers on R12.1 are also looking to upgrade to R12.2 to take advantage of Online Patching feature
Why Upgrade To Database 19c?
- Oracle Database 18.104.22.168/22.214.171.124 Extended Support Waived Only Till Dec 2020 (To know more about this, check Extended Support Fee Waived for Oracle Database 12.1 and 11.2 for Oracle E-Business Suite)
- All Customers Should Upgrade Their Database By Then To Avoid Extra Cost
- At The Moment Only EBS R12.1.3 & R12.2.3+ Is Supported
- Support For R12.0 And 11i Is Expected On A Later Date
To know more about the Database upgrade 19c, check our post Here
Thing You Must Learn Before The EBS R12.2 Upgrade
EBS Architecture Concepts:
It is a three-tier architecture:
- Client Tier
- Application Tier
- Database Tier
To know more about the EBS Architecture, click HERE
Fusion Middleware: WLS & OHS:
- Software layer that lies between business application and database
- Infrastructure which facilitates the creation of business applications
- Includes Web Servers, Application Servers, Content Management, Identity Management, SOA, Business Intelligence
- Oracle EBS R12.2 uses WebLogic & OHS from FMW
R12.2 File System:
- R12.2 has a dual File system.
- Run File system and Patch File system and are identical.
To learn more about the EBS File System, check our post HERE
Patching In EBS R12.2:
- In 12.2 all patching operations are online
- EBS will remain available to users during patching operations
To know more about patching, check our post HERE
EBR (Edition Based Redefinition):
- Edition-based redefinition allows multiple versions of PL/SQL objects, views, and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero downtime.
- Edition-based redefinition is a single technology that provides high availability during upgrades.
- 12.2 Uses Edition Based Redefinition to Support Online Patching (ADOP)
- Check Customizations Support 12.2 Development
- During Online Patching conversion make existing code compatible for EBR
EBS Upgrade Paths
You can upgrade directly to EBS R12.2 from the following base versions:
- EBS 11i
- EBS 12.0
- EBS 12.1
Upgrade High-level Steps
1. Preparation (Lay Down 12c & R12.2) no downtime
- Plan & Prepare for Upgrade – We need to plan and also document all the issues reported so that during the Final-Production upgrade downtime can be minimal. We need to plan and check all the intermediate version are supported if not operational. That is the key point during planning.
- Prepare for Upgrade– This phase starts after the planning phase and includes Database and Application preparation for upgrade activity. This is the main upgrade phase where we perform all the upgrade activities
2. Apply Latest CUP+other performance patches – no downtime
3. Online Clone Database + Upgrade to 12c
- Database Upgrade – Select the latest version for the database. If 11g database, consider for 126.96.36.199 version or you can plan for 12c versions too. Also, apply the latest Consolidate patches as per the database versions. On the application side, we need to be on the Minimum baseline patches as per the Oracle recommendations.
- File System Lay down- As we know R12.2 comes with the latest technology and file-system, so we need to lay down the R12.2 file-system using the latest startCD. Currently, StartCD 51 is available.
4. Upgrade to 12.2.0- We need to first upgrade to 12.2.0 and need to apply AD and TXK patches on the 12.2 filesystems. As this is the intermediate stage we need to perform it as a pre-install activity. At this stage, the Application will not be operational.
5. Upgrade further to 12.2.X- We are at 12.2 with the latest database now. Now on the application side, we can come to the latest version (12.2.5 Currently). We need to apply the latest technology patches (Delta 7 till now) and EBS RUP patches after that.
- Middle Tier patches -> 1594274.
- AD-TXK RUP patches -> 1617461.1
- EBS R12.2.X Document -> 12.2.4 or 12.2.5
- All the post-upgrade patches and steps
6. Apply Post – Upgrade Patch –
Enable Online Patching – As you know new feature of R12.2 is online patching so we need to enable our old instance for the same. (MOS ID: 1531121)
7. Deploy Customization & External Integration
- Translations – In the case of multiple languages are there then we need to take care of Translation patches as well. 12.2 and then 12.2.X translated patches and also we need to apply TSP (Translation Sync Patches).
- Customization – Once standard/seeded code is at R12.2.X level we need to take care of the customizations in our old versions. For R12.2 we have new development standards and need to follow the same to get the custom code compliant with our applications.
- Check the Sizing’s
- Add Nodes for Horizontal Scale-up
- Add Managed Servers for Vertical Scale-up
Post – Upgrade Tasks
After the successful upgrade of your base version R12.1 to the version R12.2 or R12.2.x, you need to perform post-upgrade tasks which ensures the stability of the system and it includes:
- Minimize Downtime: MOS ID 1581549.1 Best Practices for Minimizing Oracle E-Business Suite Release 12 Upgrade Downtime
- Best Practices & Performance: MOS ID 1581549.1 Best Practices for Minimizing Oracle E-Business Suite Release 12 Upgrade Downtime
- Troubleshooting & Logs
Related Further Readings
- [1Z0-238] Oracle EBS R12 Certified Specialist Everything You Must Know About
- 19c Database In Oracle EBS R12: Everything You Must Know
- Steps to Download Oracle EBS R12 Software from edelivery site
- Oracle E-Business Suite (EBS) 12.2.9 Now Available & Its Upgrade Steps
- MOS ID 1581549.1 Best Practices for Minimizing Oracle E-Business Suite Release 12 Upgrade Downtime
Next Task for You
Begin your journey towards becoming an Oracle EBS Upgrade R12.2 AppsDBA by joining our Training on Upgrade EBS R12/11i To R12.2