Re: Oracle9i/Solaris: sqlplus client stalls

"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 Thu Oct 10 2002 - 19:59:52 CDT