Re: Oracle9i/Solaris: sqlplus client stalls

Thanks for bothering.

That was exactly what it was happening

"Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns92A3B7163DBAESunnySD_at_68.6.19.6...
> "A. Fuentes" <alvarof2_at_hotmail.com> wrote in
> news:z8Lo9.124642$121.2902187_at_twister.austin.rr.com:
>
> >
> >
> > Fellow Oracle Netters,
> >
> >
> > I am running Solaris 8 on a Ultra60, with a recent installation
> > of Oracle 9.2.0.1 Enterprise.
> >
> > The installer reported NO errors and as "successful".
> >
> > I configured and ran the listener, dbsnmp (intelligent agent) and
> > started the Enterprise Manager GUI ./oemctl start oms
> > with no problems.
> >
> > I created other instances without a problem.
> >
> > The problem is: After a while (more than 24 hours or so)
> > the original instance (created with the installer) won't let users to
> > log in using sqlplus, except sys. (The logged in users can continue
> > with their session)
> >
> > I checked the parameters for this "faulty" instance and appear to be
with
> > the original
> > values as when it started.
> >
> > Any clue idea/suggestion/thoughts about where to start tackling
> > this problem will be greatly appreciated.
> >
> > Is there a sql script that I should run?
> >
> > Regards,
> >
> > A. Fuentes
> > 512-297-9937
>
> What's in the alert_SID.log file?
>
> This could be happeneing because the DB is in archive mode
> WITHOUT archive logging enabled. Once the instance runs out
> of free space for the redo logfiles, it will quietly stop
> doing ANY & ALL processing, until more space is made available.
>
>
> HTH & YMMV!
>
>
>
>
>
> HAND!
>
>
Received on Sun Oct 13 2002 - 20:28:48 CDT