TheBonsai's Blog

This morning I had a really good start. Get the first cup of coffee, activate the NX session, open the IRC client, go to Freenode’s #oracle channel, and saw a question:

super noob question , how do i query my oracle database online, do i need to setup bind9 and allow incoming connections so it can be accessed

I just wanted to share that

Have a good day!

Yesterday was a bad day. I wanted to completely rebuild a database with a corrupt data dictionary. My plan:

• Backup/exports
• Shutdown DB, remove userspace files
• Cleanup files inside ASM
• DBCA to make new one (no scripts available)

You see, nothing unusual. So far so good, everything fine except the last step. The scripts I had from the first installation didn’t run through, so I just wanted to click something together. But DBCA spit out:

DBCA could not startup the ASM instance configured on this node. To proceed with database creation using ASM you need the aSM instance to be up and running. Do you want to recreate the ASM instance on this node?

Er.. what? ASM instance is up and running and some minutes before the old database ran fine with it! So what? Metalink, Google: Environment variables, Listener configuration etc etc etc. Nothing applied. The only thing I really knew 100% was that the ASM setup was rocksolid.

Read the rest of this entry »

At work, we have Oracle and -related systems on top of SLES10. When you need them to work in a shared environment (e.g. shared NFS disk), the user oracle and the group oinstall need the same user ID on all systems (naturally).

Unfortunately, the IDs of these entities depend on the point in the installation process where you install the SUSE orarun packet, since the UID is generated on the fly. This leads to trouble here and then (nothing serious, but it’s a bit of work to fix such an issue afterwards). Of course I think the installation procedure of the SLES orarun package should use a fixed ID here, but that’s something SUSE decides, not me (it tastes like a bug).
Read the rest of this entry »