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.
Category: english, Linux, Oracle | 2 Comments »