Hi All,


I have a server which has 2 oracle9i instances and running .

In one instance when i give the userid/pwd@connection it is not logging in.




$ sqlplus userid/pwd@hostdtring

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 5 07:16:26 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


it is in hang state and not proceeding after the above message.

have anyone faced this time of errors.