hanj_at_mailcity.com (Jining Han) wrote in message news:<1ba3bb20.0110220343.5f60549d_at_posting.google.com>...
> 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
Finally Oracle support sent me a fix for bug 1398601, which removes
SRO (Symmetric Replication Option?) and re-create the java system.
Received on Mon Oct 22 2001 - 13:37:02 CDT
