Using DBCA in Silent Mode

One of my customers is a software company and they use Oracle database for their product. One of the things we need to do when they certify an Oracle version is to create silent installation scripts. These scripts are for Windows and used for demo and testing environments. I did that for 11.2 and for … Continue reading Using DBCA in Silent Mode

Bug When Patching Production

I had a bad night last Thursday. After patching two test RAC databases and one production RAC with PSU 180417 Bundle Patch (and some one-offs), I got to the point where it was time to update the most critical RAC system. We were really looking forward to this as we had hit a few bugs … Continue reading Bug When Patching Production

External HDD Performance

This is not a technical post and it’s not related to the database world. It’s just a short experience I had with external HDDs as a simple user so I wanted to share it. I have an Transcend external HDD for quit a while now. It’s a 2TB disk and it was very useful with … Continue reading External HDD Performance

One-off Patch Frustration

Lately I started patching a client’s database (12.1.0.2) to the latest PSU (180417). This is a RAC environment with streams and all kind of other features, so over the time we hit quite a lot of different bugs. When we planned this PSU (we installed the bundle patch version), we added about 7 one-off patches … Continue reading One-off Patch Frustration

Non-existent Objects (and possibly a bug)

This post is following a question I found on LinkedIn. A DBA pasted a strange test case in 11.2.0.4 and I managed to reproduce it in 12.1.0.2 (non-multitenant) and 12.2 (multitenant). But that’s not where the story ends, I wanted to understand what’s going on, so I did some research about it and the result … Continue reading Non-existent Objects (and possibly a bug)

Researching a Bug

A few months ago we hit an Oracle bug related to streams replication crash after creating an index (bug 21320182). There is a patch so we installed the patch in test and it seemed to solve the problem, but we never patched the production. Today we hit this issue in production after creating an index … Continue reading Researching a Bug

Datapach issues

This week I worked on a messy patch. I have a RAC environment with 12.1.0.2 and an old PSU and all kind of one-off patches and I wanted to install the latest PSU (180417). It sounds simple, but it’s not so simple. The thing is that I have 4 database running from the same ORACLE_HOME, … Continue reading Datapach issues

V$LOCK Missing Information

In our first BCOUG Tech Day conference, I presented my session “Look Inside the Locking Mechanism”. I presented this topics before a few times and prepared a few demos to show different locking scenarios. During the BCOUG Tech Day I did the same, while the only difference was that for the demo I used Oracle … Continue reading V$LOCK Missing Information

BCOUG Tech Day 18 Summary

On April 27th (2018) we had our first BCOUG Tech Day conference! If you are reading this and you’re part of an OUG board, you know how stressful and how much work it is to organize such an event. But the bottom line: it was very successful! I decided to write this post for a … Continue reading BCOUG Tech Day 18 Summary

Did You Know #26 – Restoring Standby Control File

If you read my post Restoring Standby Database, you know that one of the problems I had was that the new control file refused to open the database with resetlogs even though the database was consistent. Apparently, there is a  restore option that I wasn’t aware of in RMAN. When I restored the control file … Continue reading Did You Know #26 – Restoring Standby Control File