MTS_DISPATCHERS ERROR -- Cannot startup DB.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: MTS_DISPATCHERS ERROR -- Cannot startup DB.

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    77
    Had anyone encountered this before?

    I set the MTS parameters in INIT.ORA as in the following:

    LOCAL_LISTENER = LISTENER
    MTS_SERVICE = ORCL7
    MTS_DISPATCHERS ="(protocol=tcp) (dispatchers=2)"
    MTS_MAX_DISPATCHERS = 2
    MTS_SERVERS = 1
    MTS_MAX_SERVERS = 6

    When I try to start up the database, I received this error:

    SVRMGR> startup
    ORA-00101: invalid specification for system parameter MTS_DISPATCHERS.


    The only way I can start the database is when I commented out these parameters. But how can I startup with them?

    DB running on Win2k and it's version 8.1.7. Thanks in advance!!

  2. #2
    Join Date
    Dec 2000
    Posts
    138

    Cool

    the mts_dispatchers should be like this:


    mts_dispatchers = "(ADDRESS=(protocol=TCP)) (connections=2) (dispatchers=2)"

    HTH
    -dharma

  3. #3
    Join Date
    Mar 2001
    Posts
    77
    Tks. I did a search in the web and found that this is quite common a problem. If anyone out there had solved this problem before, can u please give me a hand? Thank u!!

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What dharma had posted would work fine for the dispatchers. Did you try that in your init.ora file. For the time being comment out the LISTENER, if you have only one listener on your server. One other thing is that you might want to have atleast 2 servers when you have 2 dispatchers.

    Try them and let us know the result.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2001
    Posts
    77
    Hi Sam,

    What if I have more than 1 listeners and 2 databases running in the same system?

    I followed your instructions and commentted out the listener, error still persists.

    Also, since I am running the database against 1 server, instead of adding another server, I reduce the dispatchers to one like so:
    MTS_DISPATCHERS ="(ADDRESS=(protocol=tcp) (connections=2) (dispatchers=1)"

    I received ora error msg :

    ORA-01078 failure in processing system parameters

    Cause: Failure during processing of initialization parameters during system
    startup.
    Action: Further diagnostic information should be in the error stack. -- there's no error stack

    Thanks again for the help!!

  6. #6
    Join Date
    Dec 2000
    Posts
    138
    I dont know if u saw the brackets properly if u dont use them properly u'll definitely end up in an error msg. tell us if you used as this- exactly

    mts_dispatchers = "(ADDRESS=(protocol=TCP)) (connections=2) (dispatchers=2)"

    -dharma


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