Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Hanganalyze Now, onto today’s post: Many DBAs have been…

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

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

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’ve been working on a simple method to clean up audit and trace files for multiple homes. Let’s see how grid and database homes can be found from oratab. $ sort -u -t : -k 2,2 /etc/oratab | grep -v…

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…

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: [ro[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…