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.

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

When moving from Oracle 11.2.0.4 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 | Leave a comment

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 | Leave a comment

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 11.2.0.4, 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

The ASM ora-04031 error, better known as: Adding more disks to an ASM Instance than there is memory..

To accommodate a change of strategy  I needed to add an additional 20 disks to the current ASM instance I had running..This needed to be done in the shortest time possible, and when the Storage and Linux Admin where done, … Continue reading

Posted in ASM, Databases, Technical Stuff | Tagged , , | Leave a comment

When Adding A Node To RAC fails..Or.. “Try It Again, Sammy!”

Normally when adding a new node to a RAC Cluster is fairly simple, provided one keeps the OS the same, and specifically the Linux kernel EXACTLY the same..But as always, it’s different in the real world where reality is creating … Continue reading

Posted in ASM, Databases, RAC | Tagged , | Leave a comment