Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
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.
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
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.
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"
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"
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
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;
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;
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> show pdbs;
$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ opatch lsinventory -detail
$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ source <CDB_NAME>_<NODE_NAME>.env
$ export ORACLE_PDB_SID=<PDB NAME>
$ sqlplus "/ as sysdba"
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 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:
For more information, review the Oracle Database Appliance 19.11 Release documentation
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
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
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
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
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.
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.
source: https://blogs.oracle.com/oda/post/oracle-database-19c-support-for-oracle-database-appliance
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:
Key Enhancements:
Recent ODA Software Enhancement for All Supported Models:
Reference: https://blogs.oracle.com/oda/post/oracle-database-appliance-x8-more-powerful-higher-capacity-improved-connectivity
All Rights Reserved