Hi,

It is Oracle 8.1.7.3 on Windows 2000 with SP2. Listener trace level is 0. The listener log file is about 36MB. When I made a connection to the hung DB, it produced this line in listener.log file:

10-DEC-2002 09:35:10 * (CONNECT_DATA=(SERVICE_NAME=sil.gs.com)(CID=(PROGRAM=C:\oracle\ora81\bin\SQLPLUS.EXE)(HOST=ADY)(USER =ady))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.222)(PORT=1057)) * establish * silicon1.getsilicon.net * 0

So it looks like the connection is made. However, the SQLPLUS never returns with SQL> prompt. It stopped at:

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 10 14:41:12 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

And that's it. There are no errors I can find.

The only thing special is that because it's behind the firewall, I had to turn on USE_SHARED_SOCKET for it to accept outside connections. This was done about a month ago. I also notice when listener redirect ports upon incoming connections, it only uses port 1026-5000. I have programs that connect to this database from another server every 30 seconds. So in the listener log, there are at least 5 connection entries for every minute.

Also, I turned on ARCHIVELOG mode last weekend because I have a standby server setup for this server. It is MANUAL STANDBY and it should not affect this problem at all.

The thing that bothers me the most is that it did not give out error messages.

Thanks,