-
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.
-
Hi drishti,
For more complex address options you can set MTS_DISPATCHERS to:
"(ADDRESS=
(PARTIAL=TRUE)(PROTOCOL=TCP)(HOST=name)(PORT=port#)(DISPATCHERS=1)".
Hope this helps (but I'm still not sure what you did maybe you made a mistake somewhere else).
tycho
-
hello
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).
-
in init.oa
this is set like this
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
memory usage is less than 60%
mts_servers
1
mts_max_servers
20
mts_max_dispatchers
5
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.
-
Drishti,
If your problem is not already resolved, it may be worth looking at a utility called oradim to delete and recreate the tns service.
-
hello,
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.
bye
drishti
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|