TheBonsai's Blog

For a new system on SLES10SP2 I wanted to operate 3 separate instances (ASM, 2 databases) from 3 separate ORACLE_HOMEs. The theory isn’t that complex, so I simply installed and patched up the 3 different ORACLE_HOMEs.

After configuring the ASM instance with the creation assistant and enabling the instance in /etc/oratab, I did a reboot. Finally I wrote a small shell function db_change() to change ORACLE_HOME, ORACLE_SID and PATH on the fly to operate on the different instances.

Nothing. I wasn’t able to connect with sqlplus. Read the rest of this entry »

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 »