Problem opening database

Hi

I have an installation of Oracle 8.1.7 on Linux (Suse 7.1).

I ran the database creation scripts that came out of dbassist.

If I use svrmgrl, I can connect internal and issue startup mount, Oracle then reports the sga parameters and these look fine.

If I do 'alter database open' (or in fact, if I just do 'startup' from scratch) then Oralce just reports ORA-01403 no data found and the open never completes. At this point I can do things like 'select * from all_objects' and look at other dba views.

sqlplus won't connect as the database is still 'starting up'. Svrmgrl can shutdown the database from this state but I just can't get it to fully open.

Anyone have any ideas what data oracle thinks it can't find for the open database phase? A single 1403 is not very helpful (is there somewhere else I can look that might have log information?).

This installation has sure been more trouble than my trusty old GNU/Linux Oracle 8.0.5 :-(

Thanks for any help Received on Thu May 10 2001 - 03:05:19 CDT