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.

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

Clone Database From NetBackup…Or..”Where Is The Tape, Watson?”

When cloning a live database, this has it’s impact on the live database..open door, I know, but still, it’s a fact. This is not always what we want, since the users can have a lot of issues and even on … Continue reading

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

Alerting on Illegal Login..Or..”Catch Me If You Can”..

We had the requirement to generate an alert whenever a user was logging into the database while bypassing the application server. Although a lot of discussion is out there of using triggers or not, I opted for a trigger due … Continue reading

Posted in Databases | Tagged , , | Leave a comment