MTS Dispatcher/listener question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: MTS Dispatcher/listener question

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Question

    I have set my init.ora to the following....

    mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)(DISPATCHERS=5)"
    mts_servers=5
    mts_max_servers=100

    I've also changed the listener.ora file to .....

    # LISTENER.ORA Network Configuration File: /n01/app/oracle/product/8.1.6/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = iggy)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = iggy)(PORT = 2481))
    )
    )


    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /n01/app/oracle/product/8.1.6)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = iggy.fundshub.com)
    (ORACLE_HOME = /n01/app/oracle/product/8.1.6)
    (SID_NAME = iggy)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = catl.fundshub.com)
    (ORACLE_HOME = /n01/app/oracle/product/8.1.6)
    (SID_NAME = catl)
    )
    )


    However when i check the services on lsnrctl, I don't get any dispatcher info.....

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    Services Summary...
    PLSExtProc has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    catl has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    iggy has 1 service handler(s)
    DEDICATED SERVER established:11 refused:0
    LOCAL SERVER
    The command completed successfully

    I've looked in v$dispatcher and there are 5 there, listening on ports 36700,36701,36702,36703,36704.....

    Why don't i get any information about the dispatchers when i query the listener services?????

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    After setting things did you get to bounce your instances and listener?


    It looks like your database is still in the dedicated server mode and not in mts mode. that is the reason why you notice the dedicated server information and not the MTS information.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    What kind of Oracle server are you runing? Standard or Enterprise edition?

    I've noticed in Oracle 8.1.6 Standard Edition on NT that SERVICES command in lsnrctl displays only dedicated servers, while shared servers are not displayed although the MTS is correctly configured and works as it should. I think this is a bug in Standard edition....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    I'm using the Enterprise Edition 8.1.6.1.0 64 bit on slaris 2.7 64 bit.

    I've stopped restarted database and listener.
    The only thing I can think of is that this machine is on the other side of a firewall and the mts ports aren't allowing data through. I believe you can hard code the ports for the dispatcher? Is this true...?

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes, you can "fix" the port the dispatcher uses to connect user to the database over a shered server. The following is the entry we use to allow connections on fixed port through firewall using MTS:

    mts_dispatchers = "(address=(PARTIAL=TRUE)(PROTOCOL=TCP)(HOST=my_host)(PORT=2000))"

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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