Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Month: December 2021

December 5, 2021 Oracle EBS with Oracle Database 19c FAQs
Installations/Configurations-Applications

Oracle E-Business Suite with Oracle Database 19c FAQs

Oracle EBS is now certified to use with Oracle database 19c(19.13) 

A Container Database(CDB) with one Pluggable Database(PDB) (single-tenant) is currently the only certified deployment for Oracle E-Business Suite with Database 19c. So oracle database has to be multitenant on Oracle 19c.

  • How does E-Business Suite support the Oracle Database multitenant architecture?

    Oracle E-Business Suite supports the multitenant architecture with a single CDB containing a single pluggable Oracle E-Business Suite database (PDB) in the following combinations:

    For R12.2
    Oracle E-Business Suite 12.2.3 and later with Oracle Database 19c on-premises
    Oracle E-Business Suite 12.2.3 and later with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System
    For R12.1
    Oracle E-Business Suite 12.1.3 with Oracle Database 19c on-premises
    Oracle E-Business Suite 12.1.3 with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System

  • Are there additional licensing requirements?

Oracle E-Business Suite currently supports a single pluggable database (single-tenant) with a CDB architecture (see the previous question). A single PDB in a CDB does not require licensing the Oracle Multitenant database option.

  • How to connect to the Oracle E-Business Suite CDB as SYSDBA?

Source the CDB environment file in the ORACLE_HOME and then use SQL*Plus to connect to the CDB as SYSDBA:

$ cd $ORACLE_HOME

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

 

  • How to connect to the Oracle E-Business Suite PDB as SYSDBA?

Source the CDB environment file,  then export the Oracle EBS PDB name, then use SQL*Plus to connect to the PDB as SYSDBA

$ source <CDB_NAME>_<NODE_NAME>.env

$ export ORACLE_PDB_SID=<PDB NAME>;

$ sqlplus "/ as sysdba"

 

  • How to Start and Shutdown the CDB that hosts the Oracle E-Business suite PDB?

Depending on the Database Instance Environment you are using for either Single Node or RAC

Starting Single Node:

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

SQL> startup;

 Stopping Single Node:

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

SQL> shutdown normal;

Starting RAC Environment:

$ source <CDB_NAME>_<NODE_NAME>.env

$ srvctl start database -d

Stopping RAC Environment:

$ source <CDB_NAME>_<NODE_NAME>.env

$ srvctl stop database -d

 

  • How to open the Oracle E-Business Suite PDB?

Source the CDB environment file, then connect to the CDB as SYSDBA, and after that execute the SQL shown in the example to start the PDB

$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database open read write services=all;

  • How to close the Oracle E-Business Suite PDB?

Source the CDB environment, then connect to the CDB as SYSDBA, and after that execute the SQL shown in the example to close the PDB:

$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database close immediate;

 

  • How to find Oracle EBS PDB information and status?

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

SQL> show pdbs;

 

  • How to list the OPatch inventory for a multitenant database?

$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ opatch lsinventory -detail

 

  • How to set up the environment to install a database patch in an Oracle E-Business Suite multitenant database?

$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch

 

  • How to set up the environment to run an Oracle E-Business Suite Script or SQL session?

$ source <CDB_NAME>_<NODE_NAME>.env
$ export ORACLE_PDB_SID=<PDB NAME>
$ sqlplus "/ as sysdba"

 

 

December 4, 2021 Oracle Database Appliance Software
ODA

Oracle Database Appliance (ODA) Software

 

ODA 19.12 Release

ODA 19.12 Release is now available for bare metal deployments of all supported models (ODA X8, X7, X6, and X5).  See the ODA 19.12 Release Notes for a complete list of New Features, Patch Reference, and Known Issues. 

Summary: 

 

ODA 19.11 Release

ODA 19.11 Release for bare metal deployments of all supported models (ODA X8, X7, X6, and X5).  See the ODA 19.11 Release Notes for a complete list of New Features, Patch Reference, and Known Issues. 

Here is a summary: 

  • Out-of-place patching model. When patching an Oracle Database, instead of changing the existing database home, a new database home is created to enhance the reliability and stability of the patching process.
  • Oracle Database Homes on Oracle ACFS (on data disks). Starting with ODA 19.11, Oracle Database homes are no longer created on the local system disk. New Oracle Database homes are created on an Oracle ACFS-managed file system residing on data disks. This will help free up space in the local system disk and provide a larger storage capacity for additional database homes.
  • Enhancements for KVM-based Database System (“DB System”). The following DB Systems operations are now supported with ODA 19.11: Backup and restore; setting up Oracle Data Guard; scale-up DB system shapes; a new type of CPU pool for DB Systems; separate virtual network for DB system; flex disk group.
  • FIPS 140-2 Compliance on Oracle Database Appliance. Starting with ODA 19.11, the Linux kernel used by Oracle Database Appliance running on bare metal and KVM Database Systems is compliant with the United States Federal Information Processing Standard 140-2 (FIPS 140-2) level one. 
  • Support for Adaptive Classification and Redaction (ACR). ACR sanitizes sensitive information such as IP address, MAC address, hostname, database name, etc., from the diagnostic collections collected using Oracle Trace File Analyzer (Oracle TFA). Oracle Database Appliance supports enabling and disabling ACR across all nodes, using ODACLI commands and Browser User Interface.
  • ODA 19.11 includes April 2021 Database Release Update and Clone Files for 19c, 18c, 12.2.0.1, and 12.1.0.2.
  • For bare-metal deployments: supports both fresh provisioning and patching from the ODA 19.10, 19.9, 19.8, and 19.7 Releases. 

For more information, review the Oracle Database Appliance 19.11 Release documentation

 

ODA 19.10 Release

ODA 19.10 Release for bare metal deployments of all supported models (ODA X8, X7, X6, and X5). See the ODA 19.10 Release Notes for a complete list of New Features, Patch Reference, and Known Issues. 

Here is a summary: 

For more information, review the Oracle Database Appliance 19.10 Release documentation

 

ODA 19.9 Release

The ODA 19.9 Release supports Oracle Database 19.x, 18.x, 12.2.0.1, 12.1.0.2, 11.2.0.4 database versions for all supported ODA models. For bare-metal deployments, the ODA 19.9 Release supports both fresh provisioning and patching from the ODA 19.5, 19.6, 19.7, and 19.8 Releases.  For virtualized platform deployments, the ODA 19.9 Release is coming in the second half of November 2020 and it will support both fresh provisioning and patching from the ODA 19.8 Release.

For more information, review the Oracle Database Appliance 19.9 Release documentation

 

ODA 19.8 Release

The ODA 19.8 Release supports Oracle Database 19.x, 18.x, 12.2.0.1, 12.1.0.2, 11.2.0.4 database versions for both bare metal and virtualized platform deployments on all supported ODA models. For bare-metal deployments, the ODA 19.8 Release supports patching from the ODA 19.5, 19.6, and 19.7 Releases. For Virtualized Platform deployments, the ODA 19.8 Release supports upgrading from ODA 18.8 Release only.

For more information, review the Oracle Database Appliance 19.8 Release documentation

 

ODA 19.7 Release

The ODA 19.7 Release supports Oracle Database 19.x along with 18.x, 12.2.0.1, 12.1.0.2, and 11.2.0.4 database versions on all supported ODA models. The ODA 19.7 Release supports both fresh provisionings and patching from the ODA 19.5 and 19.6 Release of bare-metal deployments.

For more information, review the Oracle Database Appliance 19.7 Release documentation

 

ODA 19.6 Release

The ODA 19.6 Release supports Oracle Database 19.6 along with 18.x, 12.2.0.1, 12.1.0.2, and 11.2.0.4 database versions on all supported ODA models. The ODA 19.6 Release supports both fresh provisioning and upgrading from the ODA 18.8 Release of bare-metal deployments. The operating system will be upgraded to Oracle Linux 7 and the Grid Infrastructure will be upgraded to 19.6 when upgrading to this release. 

Note: as of Aug 2020, a new ODA DCS-agent 19.6.0.1.0 patch number 31723973 (approx. size is 600MB) is available. Refer to the ODA 19.6 Release Notes section “Availability of New DCS Agent Patch for this Release” for details.

For more information, review the Oracle Database Appliance 19.6 Release documentation.

 

ODA 19.5 Release

The ODA 19.5 Release supports fresh provisioning of Oracle Database 19.5 bare-metal deployments on all supported ODA models (X5, X6, X7, and X8). Upgrading to the ODA 19.5 Release from an ODA 18.x Release is not supported. This release also cannot be patched to the ODA 19.6 Release. It is possible to patch the ODA 19.5 Release to the ODA 19.7 Release.  

For more information, review the Oracle Database Appliance 19.5 Release documentation.

 

ODA Release Matrix (patching from previous releases)

 

source: https://blogs.oracle.com/oda/post/oracle-database-19c-support-for-oracle-database-appliance

December 4, 2021 Oracle Database Appliance X8
ODA

Oracle Database Appliance X8

 

Oracle Database Appliance (ODA) has experienced broad adoption around the world in all industries across a wide range of customers, from SMBs to Fortune 100 corporations. As a result, we continue to invest in Oracle Database Appliance by offering the latest generation hardware along with ongoing software enhancements for all supported models.  We are committed to maintaining Oracle Database Appliance as the database platform of choice for customers looking to realize the benefits of:

  • Simple, Optimized, Affordable Database System with Built-in Automation
  • Integrated full-stack patching
  • Pay As You Grow, Capacity-On-Demand Oracle Database Licensing 
  • Cost-effective Consolidation Platform for Databases and Applications
  • On-premises Database Platform Offering a Path to the Cloud 

  

X8 Family

Key Enhancements:

  • More Powerful
    • New Intel Xeon Gold 5218, 16-core, 2.3GHz processors with fixes for Spectre and Meltdown vulnerabilities, provide CPU performance improvements. 
  • Higher Storage Capacity
    • ODA X8-2M supports up to 76.8TB NVMe storage, 50% more than X7
    • ODA X8-2-HA base configuration includes 46TB SSD storage (140% more than X7), expandable to 369TB SSD (174%+ more than X7) or 596TB SSD+HDD (76%+ more than X7)
  • Improved Network Connectivity
    • Support for up to 3 network cards per server: 25GbE SFP28 (Fiber) or 10GBase-T (copper) options
    • Flexibility to separate customer database client network traffic from backup, management, or other traffic.
  • Oracle Database 19c Support
    • Run Oracle Database 19c Enterprise Edition and Standard Edition 2, the latest long-term support releases, in addition to 18c, 12g, and 11g.

 

Recent ODA Software Enhancement for All Supported Models:

  • Simplified backup and restore
    • The Brower User Interface enables backup and restore for both on-premise and Oracle cloud. Supports backup to local storage, NFS storage, or Object Store in Oracle Cloud.
  • Backup and restore system configuration
  • Patching enhancements to improve security and availability
    • Out of Cycle Database and OS Patching uncouples Critical Database Patches from the ODA Bundle Patch so that critical database updates and kernel RPMs can be installed independently of the current bundle patch. This allows users to implement the most current critical patches to meet security and compliance requirements as soon as they become available.
    • Rolling patching has been enhanced to include shared storage and eliminate the need for planned outages for storage updates. Individual drives are patched without disruption, allowing the system to continue to run during firmware updates.
  • Monitoring enhancements to improve operability
    • The ODA Brower User Interface (BUI) allows users to display per node metrics for data collection, detailed diskgroup storage utilization, feature usage and high-water marks, and software bill of materials tracking for richer system management.

Reference: https://blogs.oracle.com/oda/post/oracle-database-appliance-x8-more-powerful-higher-capacity-improved-connectivity