errors in database pl help

[drishti]

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.

[fraze]

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.

[tycho]

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

[drishti]

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?

[aracnid]

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).

[drishti]

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.

[aracnid]

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.

[ECG]

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.

[drishti]

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