errors in database pl help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: errors in database pl help

  1. #1
    Join Date
    Jun 2000
    Posts
    104
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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.

  3. #3
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Smile

    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




  4. #4
    Join Date
    Jun 2000
    Posts
    104
    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?

  5. #5
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    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).

  6. #6
    Join Date
    Jun 2000
    Posts
    104
    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.

  7. #7
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    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.

  8. #8
    Join Date
    Oct 2000
    Posts
    21
    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.

  9. #9
    Join Date
    Jun 2000
    Posts
    104
    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
  •  


Click Here to Expand Forum to Full Width