Data Center Consolidation

Data center consolidation is the process of reducing the volume of physical IT assets through highly efficient and scalable technologies. Organizations leverage data center consolidation to reduce operating costs.

Analyse and Solve Serious Hardware and Sofware Problems

Listing several basic hardware and software troubleshooting steps with respect to operating systems, software programs, and computer hardware.

Mission Critical Systems

A mission critical system is a system that is essential to the survival of a business or organization. When a mission critical system fails or is interrupted, business operations are significantly impacted.

The best server hardware to maximize IT performance

Data center hardware advances target new workloads such as big data processing, as well as higher efficiency for existing apps and services. The best server hardware for your data center depends on existing and planned application architectures, data center operations staff skills and of course the IT budget.

Thursday, August 13, 2020

Oracle EBS R12 on 19c Database

, , No comments

Oracle has recently announced the release of Oracle E-Business Suite 19c Database. With the Database 19c certification, EBS 12.2 On-Premises databases are now certified with the CDB architecture (multitenant architecture).

 

Background

With the launch of database 12c in 2013, Oracle introduced a new architectural concept, called “Multitenant Databases”, where you have one super database (=container; CDB) and one or more sub-databases (= pluggable; PDB).


EBS (R12.2) Architecture Overview

Architecture mainly consists of:

·         Application Tier

·         Database Tier

·         Client Tier


Overview of Oracle Database 19c

Oracle Database 19c, is the long term support release of the Oracle Database 12c and 18c family of products, offering customers Premier and Extended Support through to March 2023 and March 2026 respectively. It is available on Linux, Windows, Solaris, HP/UX and AIX platforms as well as the Oracle Cloud.

Oracle Database 19c offers customers the best performance, scalability, reliability, and security for all their operational and analytical workloads.

 

What’s new for EBS with Oracle Database 19c

There are several mandatory architecture updates when you upgrade your Oracle E-Business Suite database to Oracle Database 19c.  The following is a summary of the key required architectural changes:

·         Container Database (CDB) Architecture: With the Database 19c certification, EBS 12.2 on-premises databases are now certified with the CDB architecture (multitenant architecture). As part of the upgrade to Database 19c, you will convert your EBS database to the CDB architecture with a single pluggable database (PDB).

·         PL/SQL File Input/Output Directories: With Database 19c, the UTL_FILE_DIR database initialization parameter has been desupported. As part of the upgrade to Database 19c, you must migrate all UTL_FILE_DIR database initialization parameters to database directory objects.  EBS development has created a utility to migrate and manage your defined PL/SQL file input/output directories.

·         ADG DML Redirection:  Previously, you could only update the Global Temp Tables on Active Data Guard standby database. From Oracle 19c, you can also update regular tables.
ADG_REDIRECT_DML enables DML redirection from Oracle Active Data Guard.

 

 Oracle Database 19c Support for EBS R12.x

·         Oracle Database 19c(19.3) has been recently supported for E-business R12.1.3 and R12.2.3 +

·         Only Multitenant Architecture is supported

·         Only One PDB in a CDB is supported for E-business

·         De-Support of UTL_FILE_DIR initialization parameter

·         Pluggable Database support

·         Oracle Linux 7.5 & above



Why Upgrade To Database 19c?

·         Oracle Database 11.2.0.4/12.1.0.2 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

Some of the High-Level Steps about Upgrade.

·         Configure DB Home for EBS

·         If R12.2.x, ensure that no ADOP cycle is active, Upgrade Database to 19c

·         Prepare for PDB Conversion & Convert to PDB

·         Execute Post PDB Conversion script txkPostPDBCreationTasks.pl

·         MOS Doc Id. 396009.1 Modify Database Initialization parameters following

·         Run autoconfig on the Application tier

·         Rewrite customizations depending on UTL_FILE_DIR

·         Rewrite customizations if impacted due to CDB/PDB model

·         Start  Application services and carry out complete Health Check

I hope you find this blog useful in understanding the 19c Database upgrade process in Oracle EBS R12 if you have any doubts regarding the 19c database upgrade post in the comment section.

References

·         Doc Id. 1594274.1 Install Oracle Database binaries 19c and apply EBS overlay patches as per

·         Doc Id. 2552181.1 Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c

·         Doc ID 396009.1 Database Initialization Parameters for Oracle E-Business Suite Release 12

·         Doc ID 2530665.1 Using Oracle Database 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2

·         Doc ID 2554156.1 Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c

 

Read More