Re: ORA-06xxx errors on Solaris

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:<3bdd0f96$0$8348$afc38c87_at_news.optusnet.com.au>...
> 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
Hi,

Thanks. I thought I needed to do something similar, so I tried using DBAssist on another machine, and saved the database creation scripts (unf. my machine had a broken dbassist :( ), and then followed EXACTLY the same steps (albeit with smaller values as my db is going to be smaller). Looks like a lot of other things (like an ALTER USER SYS with current tablespace) need to be done, (as this was a SECOND database on the same machine, and I was trying to automate the process). Anyway, I was able to create the database sucessfully, and also a (perl) script to handle db creation and related stuff (including changing TNSNAMES.ORA and LISTENER.ORA).

Thanks for your help.
Hrishikesh Received on Mon Oct 29 2001 - 08:09:04 CST