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 >

Configuring MySQL in a Docker Container

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 May 23, 2018. In recent weeks I’ve been focusing…

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 >

Best Practice Recommendations for Windows Hosting SQL Server on VMware

Did you know it’s very important to ensure that your VMware environment is properly set when hosting SQL Server instances? Imagine you have a host server with specific specs. Now you need to create virtual machines on it and ensure…

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 >

Where in a Modern Data Platform Should You Process Your Data?

Data warehouse or data lake? We break down the pros and cons of each In the book Designing Cloud Data Platforms, separating storage from compute is a key tenet of a layered cloud data platform design. It brings scalability, cost…

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 >

Reducing Contention on Hot Cursor Objects (Cursor: Pin S)

First, let me offer a little explanation about the wait event “cursor: pin S.” Oracle states: “A session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of…

Read More >
Page 2 of 36512345...10...Last Page »