Re: ORA-06xxx errors on Solaris

40M is far too small for an 8i system tablespace. Is autoextend on? It should be. You should probably also start with something much more reasonable, like 80M.

Connect Internal is the same as connect / as sysdba -both get you connected as user SYS, so that's fine.

Both catalog and catproc are supposed to give errors the first time they run. Both contain statements along the lines of 'drop something...create something'. The first time you run either script, the drop command produces an error, then the create command works.

What should you do now? I'd start from scratch, with an 80M system tablespace, autoextend on, and make sure you run catalog first, followed by catproc, immediately after database creation (and hence still connected as SYS). Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Hrishikesh" <hashinclude_at_yahoo.com> wrote in message
news:b2b4b9ed.0110282135.718057d1_at_posting.google.com...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:<ttkun08edo6g7d_at_corp.supernews.com>...


> > ... [snip]

> > Looks like you have

> > - a too small system tablespace

> > - ran catalog.sql and catproc.sql using the wrong user (should be / as

> > sysdba)

> > - didn't look at any error and warning messages, as it pointed you to

run


> > pupbld connected as system, where you ran it connected as internal

> >

> > Regards

> >

> > Sybrand Bakker

> > Senior Oracle DBA

>
> Hi
>
> I have the following settings:
> Tablespace - 40M REUSE
> Database File - 10M REUSE
> Database SID - h2
> 4 separate rollback segments
>
> CATALOG.SQL and CATPROC.SQL were run with "CONNECT / AS SYSDBA"
> PUPBLD.SQL was run WITH "CONNECT SYSTEM/MANAGER"
>
> ( With the eariler test install I had run all these scripts as
> INTERNAL )
>
> Also, CATPROC.SQL gives a lot of errors, and few statements are
> executed. Most of these errors are of the form "table or view does not
> exist".
>
> What do I do now?
>
> Thanks.
> Hrishikesh