Re: Oracle9i/Solaris: sqlplus client stalls

There is no error message.

sqlplus prompts for authentication and after you enter the name and password just hangs.
It does this for all users except SYS.

Thanks

1. Fuentes

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:92eeeff0.0210090720.2e772643_at_posting.google.com...
> "A. Fuentes" <alvarof2_at_hotmail.com> wrote in message
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 is the Oracle error message that you get on failed login?
>
> /Rauf Sarwar
Received on Wed Oct 09 2002 - 22:18:31 CDT