Re: Listener connection in TIME_WAIT status

I am not sure if you are facing the same problem that i had faced. We had similar problem with one our client program using ODBC. it used to hang in OCIServerAttach call.
and netstat used to show TIME_WAIT.

finally it was traced to a bug in Oracle 9i. The documentation says that the default SDU size is 2k but in 9i actually it is 32K.

it was solved by giving

     (ADDRESS = (PROTOCOL = TCP)(HOST = SRV1CED18)(PORT = 1521)(SDU=2048)) in the listener and also
In your tnsnames.ora give

     (CONNECT_DATA = (SERVICE_NAME=<service_name>)(SID = <sid>)(SDU = 2048))

if you are using MTS, give the following for the dispatcher dispatchers = "(description=(address=(protocol=TCP))(dispatchers=1)(SDU = 2048))"

Note: if you are using multiple dispatchers, say 2, then don't give dispatchers = "(description=(address=(protocol=TCP))(dispatchers=2)(SDU = 2048))"
this does not spwan 2 dispatchers, for some reason, once the SDU parameter is added, its not spawning the required no. of dispatchers correctly. to aviod this give dispatchers in 2 separate lines dispatchers = "(description=(address=(protocol=TCP))(dispatchers=1)(SDU = 2048))"
dispatchers = "(description=(address=(protocol=TCP))(dispatchers=1)(SDU = 2048))"

Regards,
Pinto.

"test" <test_at_nomail.it> wrote in message news:0LjGa.22728$Fr5.480251_at_tornado.fastwebnet.it...
> sybrandb_at_yahoo.com :
> >How can we tell something is wrong in the listener configuration when
> >you don't post any details? No one is really clairvoyant here
> >
> Here it is my listener.ora
>
> # LISTENER.ORA Network Configuration File:
> # D:\oracle\ora90\NETWORK\ADMIN\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = SRV1CED18)(PORT = 1521))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora90)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = ORCL)
> (ORACLE_HOME = D:\oracle\ora90)
> (SID_NAME = ORCL)
> )
> )
>
> Now I'm thinking it may be not a problem with the listener, but I can't
> figure what's going wrong.
> The problem is that the connetction hangs for some time (this time
> is variable for each attempt from one minute up to ten or more),
> then it start working properly.
>
> Thanks for your answer.
>
> Alessandro.
>
Received on Fri Jun 13 2003 - 09:29:46 CDT