Can Concurrent Processing Abort Help Automation and Predictable Maintenance?

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…

Read More >

Datascape Podcast Episode 48: Recapping the Spring 2021 Microsoft Ignite Virtual Conference

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…

Read More >

Connect to Vagrant Virtual Machine over Wi-Fi Network

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…

Read More >

Relying on Guaranteed Restore Points? Be careful!

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,…

Read More >

Opatchauto Failing On “CheckActiveFilesAndExecutables” during Prerequisite Check

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…

Read More >

Change Port Number in Common Object Service (COS) Naming Service for Reports Server Discovery

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…

Read More >

Clear Exadata Component Messages after Maintenance

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…

Read More >

AWS RDS: Read Oracle Traces from SQL*Plus

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…

Read More >

Google Cloud Composer Costs and Performance

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…

Read More >

PL/SQL Generalized Invocation

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…

Read More >
Page 1 of 36912345...10...Last Page »