network error encountered setting up listening port
listening address for dispatcher is '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'
NS Primary Error: TNS-12560: TNS:protocol adapter error
NT Generic Error: TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
OPIRIP: Uncaught error 108. Error stack:
ORA-00108: failed to set up dispatcher to accept connection asynchronously.
can anyone tell where the problem lies?
thanks in advance for any help.
Info from oerr command on UNIX - Hope it helps:
00108, 00000, "failed to set up dispatcher to accept connection asynchronously"
// *Cause: Most likely due to the fact that the network protocol used by the
// the dispatcher doesn't support aynchronous operations.
// *Action: contact your ORACLE representative.
For more complex address options you can set MTS_DISPATCHERS to:
Hope this helps (but I'm still not sure what you did maybe you made a mistake somewhere else).
you see -the database was running fine before.this error is coming frequently few days before,some users are getting connection ,others gettibg ora-12500.at server I see ora-12560.
if this is due to network collision or what?
Check the memory usage. This error "12500" comes when your system can't open a new process, in this case a dedicated process. This mean also that your mts is not working fine, because if it try to open a dedicated proces means that the dispatcher don't work. Check also the max number of dispatcher (if to small).
this is set like this
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
memory usage is less than 60%
do you think i should change mts_max_dispatchers is to increase.
try to use 15 max disp and see if the error persist.
To see the functionality of mts type "services " from "lsnrctl".
Will show you informations about mts.
If your problem is not already resolved, it may be worth looking at a utility called oradim to delete and recreate the tns service.
yesterday I gone thru mts architecture,and increased the no.of shared server processes to 5 and no.of dispatcher proceses to 5,I am thinking of increasing max_mts_dispatchers to 10,as in the book its saying not to increase it beyond 10.do u fellows think putting no.of shared server proceses and dispatchers same would cause any problem,pl answer back.
the error was coming in every one hr, now for last one day I can see its silent.