How I Finished a Recovery From an Active Duplicate After Facing Errors ORA-19909 and ORA-01110
The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, and got the following error: ORA-19909: datafile 1 belongs to an orphan incarnation and ORA-01110: data file 1. This post explains how I solved these...
Read More >
TNS-12564 Errors and the Importance of the Parameter LOCAL_LISTENER During a Data Guard Switchover
From the above post, you can see the importance of having the database parameter LOCAL_LISTENER set properly. Otherwise you’ll experience a set of headaches during a switchover, even if everything else seems set to work out. Note: This was originally posted…
Read More >
Automatic Flashback Of Standby Database in Oracle 19c
Oracle 19c Data Guard introduced a very cool feature — you can now automatically flashback your standby if you flashback your primary. I'll demonstrate this in the following test scenario by creating a table called rene.test. ############################################################################################################## ## Primary Database...
Read More >
How to Fix the Status of the Oracle GI CRS After a Failed Upgrade
Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on April 29, 2019. Blogger’s Note: The information in this…
Read More >
Silent Rollback From an Out-of-Place Patching For Oracle 19c GI
My last post dealt with how to do an out-of-place patching for Oracle GI (Grid Infrastructure). The next thing I wanted to try was the rollback procedure for this methodology. I searched in MOS (My Oracle Support) and the Oracle...
Read More >
Silent Out-of-Place Patching For Oracle 19c GI
I am going through a process of patching an Oracle Grid Infrastructure (GI) from 19.6 to 19.8 (Patch 31305339) and I wanted to try out-of-place patching (OOP). Since I didn't have access to the GUI (graphical user interface) environment, I...
Read More >
OPatchAuto Bug on 19.3 GI/RDBMS When Patching to 19.6
The other day I was doing a fresh install of Oracle 19.3. I was using the binaries from edelivery, doing some testing in that version, then patching to 19.6. The installation and the tests went fine. Next, I proceeded to...
Read More >
EM 13c: Patching Oracle Enterprise Manager With Release 4 Update 6 (13.4.0.6)
Once I had done this, I created a property file to be used during the patching activities so I wouldn’t have to input the Weblogic information over and over. The next step was to analyze whether this patch was applicable…
Read More >
Official Pythian® Blog
