Build 64bit OCILIB Libraries for CodeBlocks

I tend to compile with gcc, in a bash session, on Windows 7. I use Code::Blocks as my IDE of choice and one of my projects, well, quite a few, use the excellent OCILIB library for accessing Oracle databases, by Vincent Rogier. I can’t recommend this library highly enough.

However, it comes with a Code::Blocks project file to build 32 bit libraries, but I need 64 bits. Here’s how I do it.

Continue reading Build 64bit OCILIB Libraries for CodeBlocks

Which Extra Cost Oracle Options is my Windows Server Running?

It’s always nice to know which extra cost Oracle options are enabled, whether deliberately or silently as the result of some patching that has taken place.
Keep yourself and your server room cool with blaux wearable ac.

Continue reading Which Extra Cost Oracle Options is my Windows Server Running?

How to Start an Oracle Database When You Are Not in the DBA Group

This applies to Linux, Unix as well as Windows, but affected me on a Windows 2012 Server running Oracle 11.2.0.4 Enterprise Edition.

My user on the server was an administration user, but not in the ora_dba group. This is required to connect / as sysdba within SQL*Plus. The SYS password had been changed recently but whoever did it, did not update the password vault. The users were urgently requiring their database be started, I was the only DBA in the office, the SYS password was unknown, and my user didn’t belong directly to the ora_dba group. What to do? Continue reading How to Start an Oracle Database When You Are Not in the DBA Group

Tnsnames.ora, IFILE and Network Drives on Windows

I’ve recently begun a new contract migrating a Solaris 9i database to Oracle 11gR2 on Windows, in the Azure cloud. I hate windows with a vengeance and this hasn’t made me change my opinion!

One of the planned improvements is to have everyone using a standard, central tnsnames.ora file for alias resolution. A good plan, and the company has incorporated my own tnsnames checker utility to ensure that any edits are valid and don’t break anything.

I found that the tnsnames.ora in my local Oracle Client install, was not working. Here’s what I had to do to fix it. Continue reading Tnsnames.ora, IFILE and Network Drives on Windows

Getting Arduino Working from a Windows 7 VirtualBox Guest

Do I like problems or what? 🙂 I’m running Linux Mint 17.2 as my host, and I have a VirtualBox 5.0 VM running Windows 7 Professional. I decided I’d like to be able to run the Arduino software from within the VM, but not talking to an Arduino, but to a bare bones setup and programming AtTiny85 devices. The following might be of use to other people’s needs as it explains how the FDTI device cane be automatically assigned to the VM rather than to the host, when plugged in and the VM is running. Continue reading Getting Arduino Working from a Windows 7 VirtualBox Guest