Re: 9.0.1 linux startup problem

As Art Carney said in 'Roadie', "Everything'll work if you let it."

Thanks. Worked as you said it would.

Best regards,
jh

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a9rame$1gj$2_at_lust.ihug.co.nz>...
> Jared wrote:
>
> > I had just completed installing an eval of 9.0.1 on Mandrake 8.2.
> > Everything appeared to be in, no problems in the logs that I could
> > see. I shutdown normally, then went to start up, when, wham! -
> >
> > ALTER DATABASE OPEN
> > Fri Apr 19 14:16:11 2002
> > Thread 1 opened at log sequence 13
> > Current log# 1 seq# 13 mem# 0: /var/oradata/log/lab1_redo01a.log
> > Current log# 1 seq# 13 mem# 1: /usr/oradata/log/lab1_redo1b.log
> > Successful open of redo thread 1.
> > Fri Apr 19 14:16:11 2002
> > SMON: enabling cache recovery
> > Fri Apr 19 14:16:12 2002
> > Errors in file /home/oracle/admin/lab1/udump/ora_14222.trc:
> > ORA-30012: undo tablespace 'RBS' does not exist or of wrong type
> > Fri Apr 19 14:16:12 2002
> > ****NOTE *************
> > Error 30012 happened during db open, shutting down database
> > USER: terminating instance due to error 30012
> > Instance terminated by USER, pid = 14222
> > ORA-1092 signalled during: ALTER DATABASE OPEN...
> > *****************************
> >
> > Now during the install the undo tablespace took the name of my data
> > tablespace (my own fault for playing with dbca instead of writing my
> > own scripts), but I can't see why the datra dictionary shouldn't know
> > about that.
> >
> > Anyone know how to fix this?
> >
> > TIA -
> >
> > Regards,
> > jh
>
>
> Yeah. Edit your init.ora so it says UNDO_MANAGEMENT=MANUAL. Force a startup
> using the pfile (i.e., you have to explivitly reference the pfile). Create
> a proper undo tablespace. Edit the init.ora so it references the undo
> tablespace you've just created. Startup again using the pfile. The create
> spfile from pfile. Then you're in business.
>
> Regards
> HJR
Received on Mon Apr 22 2002 - 15:19:54 CDT