Re: SQLPlus hangs

>Subject: SQLPlus hangs
>From: aharbick_at_opentext.com (Andrew Harbick)
>Date: 1/19/98 7:36PM GMT
>Message-id: <6a0a5i$gtl$1_at_news2.cais.com>
>
>Bu only when I enter the correct username/password?
>
>I changed ISP's about a month ago, and consequently some of my Oracle
>configuration needed to change also. I use it almost exclusively for local
>development. My TNS listener wasn't working so I made changes to
>listener.ora, and it appears to function correctly. I can get into and of
>the
>Enterprise Mangement tools using the "system" account just fine. I can also
>SQLPlus into the DB with system/password.
>
>However, sqlplus hangs when I use a legitimate user/pass. If however, when I
>
>enter an invalid user/pass, it reports:
> ORA-01017: invalid username/password; login denied
>
>Any thoughts?
>Andrew Harbick
>aharbick_at_be.opentext.com
>
>
>
>
>
>
>

This sounds similar to a problem we are experiencing at our site sporadically. Check the alert log for the database to see if there is an entry along the lines of
COULD NOT ALLOCATE ROW CACHE ENQUEUE LOCK when we get this error only users with DBA privileges can log in. It is usually caused by a runaway process and killing the process clears the problem. Hope this helps

   Rob Received on Wed Jan 21 1998 - 00:00:00 CST