Re: Server Startup Never Finishes!

Ban Spam <ban-spam_at_operamail.com> wrote in message news:<Xns91414930FE81CSunnySD_at_24.0.3.73>...
> hanj_at_mailcity.com (Jining Han) wrote in news:1ba3bb20.0110210532.7fda4391
> @posting.google.com:
>
> > Oracle tech support has not been able to help me with this for 3
> > days... and this happens to two 8.1.6.3 databases, and one 8.1.7.2
> > database, all running on the same HP-UX 11 box.
> >
> > After shutting down these databases with abort option, startup never
> > finishes, and alert.log shows
> >
> > Any help would be greatly appreciate.
> >
> > Thanks
> > Jining
> >
>
> While this may sound like an off the wall suggestion
> and I'm not sure it will work in any case and I don't
> have access to a system upon which to test, add an
> additional LARGE data file to your "TEMP" tablespace
> before opening the database. In other words
> STARTUP MOUNT
> ALTER TABLESPACE TEMP ADD DATAFILE '-------------' 2000M;
> ALTER DATABASE OPEN;
>
> It just might give SMON more room in which to work.
>
>
> HTH & YMMV!
Thanks for the suggestion. It's been a whole night since I added the data file, but things remain the same. I have manually coalesced all the tablespaces, too, but that doesn't help, since select count(*) from dba_free_space never shows any difference.

Any other suggestions? I am willing to follow any at this point;)

Thanks
Jining Received on Mon Oct 22 2001 - 06:43:55 CDT