Archive for the 'english' Category

A UNIX pathname is a UNIX pathname…or not? ORACLE fooled me again!

May 5th, 2009 by TheBonsai

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 »

Category: Oracle, english | 1 Comment »

Five hours, ORACLE, dbca, ASM and a customized SQL*Plus prompt…

January 31st, 2009 by TheBonsai

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 »

Category: Linux, Oracle, english | 2 Comments »