Re: Problem opening database

Try doing a shutdown abort from svrmgrl . Then do a startup.
If it does not work do a shutdown and then exit from svrmgrl. do ps-ef | grep "oracle_sid" and kill any processes running . Then go back to svrmgrl and connect internal. Try startup... Also Look for problems in your initoracle_sid.ora file and make sure that parameters are set right.

"qIroS" <qIroS_at_tlhIngan.co.uk> wrote in message news:9ddi1d$46t$1_at_triton.qsp.co.uk...
> 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 17 2001 - 13:55:23 CDT