Category Archives: Technical Stuff

Here are the technical oriented thingies placed. There is a slight overlap in these categories, where I try to keep the main subject in the correct place, but when the category states database, there still may be a java coding gem hidden inside..

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 | 14 Comments

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

Oracle OEM 13c Metric Collection Error..Or..”Show Me The Graphs!”

When implementing the OEM 13C version, we have a server where we house about 16 databases. Adding the first bunch of the databases went like a breeze, but when all was said and done, we had 3 databases which didn’t … Continue reading

Posted in Databases, Technical Stuff | Tagged , , | 12 Comments

Integrate OEM 13c With MS Active Directory..Or..”One Account To Rule Them All…”

There are some instructions on the internet floating around in order to integrate the OEM 13c (or basically Weblogic 12c) and OEM 13c with Microsoft Active Directory/LDAP. However in our case things went not as smoothly as advertised (Duh!). We … Continue reading

Posted in Oracle Enterprise Manager, Technical Stuff | Tagged , | Leave a comment