Re: sqlplus scott/tiger@tnsname hangs
Date: Thu, 17 Apr 2008 15:54:12 +1000
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 <p4cldba_at_gmail.com> wrote:
> 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 18.104.22.168 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
> 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.
-- J.A. van Zanen -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 17 2008 - 00:54:12 CDT