-
North America: +1-866-798-4426
-
APAC: +61 (0) 2 9191 7427
-
Europe: +44 (0) 20 3411 8378
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 >Converting Oracle Enterprise Manager Management Service (OMS) Repository from Legacy Non-CDB to CDB Architecture
Note: This was originally posted on rene-ace.com.
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 >Issues With Database Service Names Starting With Pluggable Database (PDB) Name
In this post I’ll describe a problem which occurs when creating and using a database service name which starts with the pluggable database’s (PDB) name, and has a dot (“.”) after it: “<pdb_name>.<optional_suffix>.” I noticed this issue when I was…
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 >dba-cloud-services
