On the surface concurrent processing (CP) looks simple; a new request is pending for a while, then it runs and is completed. However in the background it’s extremely complicated with all the statuses, schedules, permissions, incompatibilities, etc. If you’d like…

Episode 48: Show Notes Spring Microsoft Ignite 2021 Conference Recap Today we are joined by Warner Chavez to hear about all the new updates in the Microsoft ecosystem that were discussed at the 2021 Microsoft Ignite Conference. We kick the…

I recently had the need to quickly set up an Oracle 19c database lab environment on Linux to run some tests. My laptop was already running a VirtualBox VM with Oracle 12.2 release and I wanted to have a different…

Are you relying on guaranteed restore points (GRP) as a fallback plan for your migration or upgrade strategy? If you’re using RAC, especially before 12.2, be careful! When performing a non-prod upgrade with the AutoUpgrade tool, after completing the upgrade,…

Very recently, when applying the 2021 January CPU in a client environment, the following happened: [root@dbserver01 32226239]# $ORACLE_HOME/OPatch/opatchauto apply OPatchauto session is initiated at Sun Mar 14 03:00:06 2021 System initialization log file is /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchautodb/systemconfig2021-03-14_03-00-08AM.log. Session log file is /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/opatchauto2021-03-14_03-00-13AM.log…

Recently I received a request to change the port number used by an Oracle reports naming server. I looked into MOS and found no direct notes to address this change. Here are the details: Our Environment: Oracle Weblogic Application running…

What can you do if you’ve completed maintenance in a component (a memory component, as per the example below) but keep receiving failure messages? First, try clearing all the error messages after completing the maintenance. Now, check if the threshold…

Today’s post is another dealing with AWS services. Let’s say you need to read trace files from RDS — how would you do it? Here’s an example of how to list and read those files based on the directories from…

Controlling Cloud Composer Costs and Performance Managing, optimizing and balancing cloud cost vs. performance is an ongoing challenge for all cloud architects and administrators. The variety and complexity of tools available can sometimes be daunting, so much so that many…

Did you know PL/SQL generalized invocation has been available since 11g? The generalized invocation allows a subtype to invoke a method of a parent type (a supertype) using the following syntax: (SELF AS supertype_name).method_name Yes, this is the concept of…