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 >
Page 1 of 2512345...10...Last Page »