I recently applied the January 2023 released E-Business Suite Release 12.2 CPU patches following the release document 2916871.1. Below are a few high-level notes that might be helpful for a quick reference for anyone taking up these patches. E-Business Suite…

Organizations usually maintain Oracle licences for Oracle RDBMS Enterprise Edition on a per-core basis. It is possible to use Virtualization Managers to limit the resources assigned to virtual machine “guests”—and, subsequently, the databases within those guests. According to the Oracle Partitioning…

Not so long ago, I was faced with a request to collect information from several schemas located in multiple CDB databases. This can be done by connecting to each CDB, switching to a particular PDB, and retrieving the required information…

Oracle e-Business Suite administrators have access to pretty extensive documentation regarding Patching procedures. In Oracle EBS 12.2 Oracle introduced ADOP patching method along with Oracle Database EBR (edition-based redefinition) feature that allows minimizing downtimes for patching activities. As with everything…

The package DBMS_CLOUD was first introduced in the Autonomous Database to provide a simple way to interact with an object store from the database. It is now available for on-premise databases starting with 19.9c and 21c. It works with OCI,…

Recently I was working on a client request where a CDB along with a subset of its PDBs had to be cloned to a new server for testing purposes. This post illustrates that in certain circumstances the outcome of this…

Our mission at Pythian is to help you Love Your Data. Because security is a crucial part of managing your data, we are pleased to tell you about the identity management (IDM) solution Pythian has developed to make it easier…

As a managed service company, we see our customers and partners shifting their workloads to the cloud. There are various reasons for this decision, but the most important ones are cost and agility. Once on a cloud, the infrastructure team…

This blog post is about a scenario where a combination of a logon trigger performing DML operations at user login time (writing to a custom audit table), and a Fast recovery area (FRA) full situation brings the database to a…

Cloning an Oracle E-Business Suite system is a complicated process, and depending on the environment topology, it can involve various steps to accomplish the task.     Partial automation of the E-Business Suite cloning procedure is often done with local…