Re: sqlplus scott/tiger@tnsname hangs

From: Jack van Zanen <>
Date: Thu, 17 Apr 2008 15:54:12 +1000
Message-ID: <>

maybe check the size of your listener.log file

I have seen occasions where a large log file saw this behaviour


On 17/04/2008, Prasad <> wrote:
> Greetings.
> This was something that happened today in one of the database and I am
> looking for list's
> response on this. This is a Oracle database running solaris 9.
> Around 10am the Unix group called me and told me that one of the osprocess
> is taking more cputime
> then what it normally takes. and upon investigation I found that this
> database was running on
> shared server mode with the osprocess being the only dispatcher at that
> time . So I created another
> 3 dispatcher and stopped the existing dispatcher d000.
> and everything was going fine until 2.30pm when the user called me and
> told me that he is not able to
> make connection using servicename. so I did a test
> test1- sqlplus '/as sysdba'
> test2- sqlplus scott/tiger
> test3- sqlplus scott/tiger_at_tnsname
> I was able to logon to database successfully with test1 and test2 .
> However when I did test3
> it just hangs and it didnt allow me to interrupt it also.
> I checked if the dispatchers were busy or not and didnt found anything
> significant.
> The listener logging was not enabled so the initial reaction was to
> shutdown and start the
> listener which I did and at this time the test3 worked fine . However the
> user was still not able to
> access its application and I observed a large number of session in
> dba_blocker and dba_waiter
> and also few deadlock error in alert log file . So I killed the session on
> the beginning of the queue
> and it immediately releases all the sessions in dba_blockers and
> dba_waiters and the user was
> able to access the application.
> Here comes the hard part what is the root cause of this issue?
> Please advise.
> Thanks
> -Prasad

J.A. van Zanen

Received on Thu Apr 17 2008 - 00:54:12 CDT

Original text of this message