DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: MTS

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    Hi Friends,
    Greetings.

    I am trying to setup the MTS on windows 2000 oracle 8.1.7. In Init.ora i setup the parameters:

    MTS_SERVERS=3
    MTS_MAX_SERVERS=8
    MTS_DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=2)"
    MTS_MAX_DISPATCHERS=4
    MTS_SERVICE="TEST"
    MTS_LISTENER_ADDRESS ="(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=MSFT-MAN)"

    I am getting an ERROR:

    SVRMGRL>STARTUP

    Invalid specification for system parameter MTS_DISPATCHERS.

    Please look into the parameters and correct me.

    Thanks
    Ravi
    ravi

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can you do a tnsping service_name on the server? Could you give us the complete error message?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    157
    Hi Sam

    The error message is :

    ORA-00101: invalid specification for system parameter MTS_DISPATCHERS

    Thanks
    Ravi
    ravi

  4. #4
    Join Date
    Nov 2000
    Posts
    157
    tnsping is working fine

    TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 09-O
    01 15:14:29

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(PORT=1521))
    OK (380 msec)

    Thanks
    Ravi
    ravi

  5. #5
    Join Date
    Nov 2000
    Posts
    157

    mts

    MTS_SERVERS=3
    MTS_MAX_SERVERS=8
    MTS_DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=2)"
    MTS_MAX_DISPATCHERS=4
    MTS_SERVICE="TEST"
    MTS_LISTENER_ADDRESS ="(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=msft-man)"

    THE ERROR IS:

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

    tnsping is OK

    any suggestions please
    Ravi
    ravi

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Could you put the following in the place as in order, and try starting up

    Code:
    MTS_DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=Hostname)(SERVICE=SID))(DISPATCHERS=2)" 
    MTS_MAX_DISPATCHERS=4 
    MTS_SERVERS=3 
    MTS_MAX_SERVERS=8
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    do u have this parameter in the init.ora

    mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=XXXXXX))"


    if you do not have try with that
    sonofsita
    http://www.ordba.net

  8. #8
    Join Date
    Nov 2000
    Posts
    157
    HI GUYS

    WHEN I TRIED THIS I AM GETTING THE ERROR:

    MTS_DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(SERVICE=TEST))(DISPATCHERS=2)"
    MTS_MAX_DISPATCHERS=4
    MTS_SERVERS=3
    MTS_MAX_SERVERS=8
    MTS_LISTENER_ADDRESS ="(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=msft-man)"




    SVRMGR> STARTUP
    ORA-00101: invalid specification for system parameter MTS_DISPATCHERS
    ORA-00102: network protocol (ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(SERVICE=TEST)
    ) cannot be used by dispatchers


    Thanks
    Ravi
    ravi

  9. #9
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    if you are on unix box and not using sco then this shall help you:

    Note:1005046.6
    Subject: ORA-00101 AND ORA-00102 USING SQL*NET TCPIP ON A UNIX PLATFORM
    Type: PROBLEM
    Status: PUBLISHED
    Content Type: TEXT/PLAIN
    Creation Date: 09-AUG-1994
    Last Revision Date: 09-JUL-2001


    Problem Description:
    ====================

    You are trying to start an Oracle7 database using a UNIX platform; using MTS
    (multi-threaded server) on SQL*Net V2. You are getting error messages
    ORA-00101 and ORA-00102.


    Problem Explanation:
    ====================


    ORA-00101: "invalid specification for system parameter mts_dispatchers"
    Cause: The syntax for the "mts_dispatchers" parameter is incorrect.
    Action: Refer to the manual for correct syntax.

    ORA-00102: "network protocol %s cannot be used by dispatchers"
    Cause: The network specified in "mts_dispatchers" doesn't have the
    functionalities required by the dispatchers.
    Action: Refer to the manual on network protocols supported by the
    dispatchers.


    Search Words:
    =============

    ORA-101 ORA-102

    Solution: DESIRED PROTOCOL MUST BE PROPERLY LINKED

    Solution Description:
    ====================

    Verify that the Desired Protocol has been properly linked.

    To relink:

    1. Login as oracle
    2. cd $ORACLE_HOME/rdbms/lib
    3. make -f oracle.mk install

    Note: You may also have to relink other product executables.

    1. cd $ORACLE_HOME//lib
    2. make -f .mk install

    sonofsita
    http://www.ordba.net

  10. #10
    Join Date
    Nov 2000
    Posts
    157

    mts

    Thank you very much for the info friends. I will get back to u if i come across any problem again.

    Thanks
    Ravi
    ravi

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