I can connect to my database fine with no error. However, one of our applications keep giving this ORA-12542 TNS: Address already in use error once in a while. The application can return data with no problem sometimes but this error message comes up quite often. I have checked the Listener Log and the Listener Trace file, and i don't see any error in either. Is there any way I can further diagnose this problem? Thanks!!
Below is the last entries from the Listener.log:
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Test1.TestC1)(CID=(PROGRAM=c:\windows\system32\inetsrv \w3wp.exe)(HOST=TestC1)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=12.59.245.18)(PORT=3679)) * establish * Test1.TestC1 * 0
06-JUL-2005 12:59:06 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Test1.TestC1)(CID=(PROGRAM=c:\windows\system32\inetsrv \w3wp.exe)(HOST=TestC1)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=12.59.245.18)(PORT=3682)) * establish * ATR1.ATRC1 * 0
06-JUL-2005 12:59:06 * service_update * ATR1 * 0
06-JUL-2005 12:59:45 * service_update * ATR1 * 0
Below is the last few line from the listener.trc:
[06-JUL-2005 12:59:06:468] nsbeqaddr: handshake is complete; redirecting
[06-JUL-2005 12:59:06:468] nscon: sending NSPTRD packet
[06-JUL-2005 12:59:06:468] ntt2err: soc 276 error - operation=5, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0
[06-JUL-2005 12:59:06:468] nstimarmed: no timer allocated
[06-JUL-2005 12:59:06:484] ntt2err: soc 276 error - operation=5, ntresnt[0]=530, ntresnt[1]=995, ntresnt[2]=0
[06-JUL-2005 12:59:06:484] nsclose: closing transport
[06-JUL-2005 12:59:06:484] nsclose: global context check-out (from slot 5) complete
