Author: Matheus Boesing

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Hanganalyze Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto today’s…

Most likely you’ve landed here because you need to migrate APEX applications/workspaces from one database to another. If so, you’re in the right place! We’ll use APEXExport to accomplish this. I’m providing a quick summary of the steps for using…

I have an interesting case to share in this post. The story started when a client asked for a read-only account (let’s call it RO_USER) with access to objects under another schema (let’s call it SCHEMA_OWNER). Easy going, right? Create…

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: [[email protected] 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…

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…

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…

When you’re sure all the TNS listener (SID_LIST_LISTENER in this case) services and db_domain are fine, but you still face the ORA-12537: TNS:connection closed error when trying to remotely access an open database, what can you do next? [[email protected] admin]$…

In this post I’d like to present five best practices/tips for setting dispatchers for database shared connections: 1. Set local_listener on both instances of the database alter system set LOCAL_LISTENER=”(address=(protocol=tcp)(port=1521)(host=yourhost))” scope=both sid=’instance_name’; Ref: Shared Server: Dispatchers Are Not Registered With…