Author Archives: GemsOfProgramming

About GemsOfProgramming

Beeing a previously enthusiastic Java programmer, I rolled into the Oracle Database Administration world. It turned out I got a knack for this, and since approx. 2000 I'm a full time DBA. My experiences touches lot of Oracle products like Forms and Reports 9/10, JDAPI, Application Server, Weblogic Fusion and of course: Oracle Enterprise Databases, JavaFX, Swing and other Java components.

ORA-10458 Standby Database Requires Recovery..Or..ADG Is Out Of Whack.

One day…yes, we had one of “those days” when an power maintenance in the datacenter proved the divide and conquer strategy of power supply cabling was not applied as planned…The ADG crashed..and not in a good way. The storage just … Continue reading

Posted in Personal Ramblings | Leave a comment

SQL Developer..Or..”Let’s Be Friends Again..

Every so often, when running SQL Developer on Linux (Ubuntu), the cursor just decided to have a day off, and would just disappear. When just doing some edits, this was cumbersome, annoying as **** , but doable..However, I never really … Continue reading

Posted in Personal Ramblings | Leave a comment

Installing Oracle 12.2.01 On Oracle Linux 7.4..Or..”The Story Of The Tainted Kernel”

When moving from Oracle to a new Oracle 12c environment, we wanted to build everything on the latest and greatest levels…Little did we know we would run into quite a snag.. We installed Oracle Release 7.4, with all the … Continue reading

Posted in 12c, ASM, Databases, upgrade | Tagged | 13 Comments

Quick Setup To Monitor/Detect percieved Slowness…Or…”Put Some MDMA In The Database..”

At some time every DBA has to deal with the dreaded “The database is slow, FIX IT!” issue. To be honest? I’m not the master of tuners, and surely I’m not dealing with these things on a day-to-day basis. Oracle … Continue reading

Posted in Performance | Tagged , | Leave a comment

DBUA 12c Reports Database Down While It’s Up..Or..”The only way is up! – Yazz- “

After doing meticulously doing the pre-upgrade  steps on a RAC converted to single instance node, we finally could get started on the actual upgrade. The initial idea is to use the DBUA, since it automates a lot of steps, and … Continue reading

Posted in 12c, Databases, Technical Stuff, upgrade | 2 Comments

Oracle 12c DBUA ORA-01031: Insufficient privileges..Or..”Oracle Really Knows How To Test One’s Nerves..”

During a test run of an upgrade with the DBUA, everything was peachy..did some tests, and some other thingies..Multiple terminals open like anyone not working on Windows does..Started the DBUA 12c just fine…found out: hey, you need to have extra … Continue reading

Posted in 12c, ASM, Databases, upgrade | Leave a comment

OHASD Fails To Start RAC Components…Or..”Please Continue,Sir”!

On Oracle, when a node crashes, and the storage disks are a bit late to the party (as being the cause of the crash!), when starting OHASD the manual way, it can happen it says it’s starting, kicks in … Continue reading

Posted in Databases, RAC | Leave a comment