Re: Problem opening database

qIroS wrote:

> 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

If you built the instance from scratch did you run catalog.sql, catproc.sql and pupbld.sql? If not ... do so.

If you had Oracle build a starter database then in server manager, connect as internal, and run the script pupbld.sql. The command is likely:

@$ORACLE_HOME/sqlplus/admin/pupbld.sql

That should solve the problem.

Daniel A. Morgan Received on Thu May 10 2001 - 23:36:54 CDT