problem in configuring MTS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: problem in configuring MTS

  1. #1
    Join Date
    Jul 2002
    Posts
    14

    Thumbs up

    Hi,

    We have Oracle 8.1.7standard edition on windows2000professional. To configure MTS services, I have added following parameters under INIT.ORA file:
    ------------------------------------------
    mts_dispatchers = "(protocol=TCP)(disp=6)(mul=ON)(tick=15)(pool=true)(con=5)"
    mts_dispatchers = "(protocol=IPC)(disp=6)(mul=ON)(tick=15)(pool=true)(con=5)"
    mts_max_dispatchers = 10
    mts_servers = 6
    mts_max_servers = 12
    mts_listener_address="(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.144.121)(PORT = 1521))"


    ------------------------------------------
    and also modified the tnsnames.ora files as:

    ------------------------------------------

    sofT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.144.121)(PORT = 1521))
    )
    (CONNECT_DATA = (service_name = soft))
    )
    in my listener.ora file:(soft..is my listenername,service name,instance name,dbname)
    SOFT =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.144.121)(PORT = 1521))
    (ADDRESS = (PROTOCOL = IPC)(PROGRAM = extproc))
    )
    )
    )

    SID_LIST_SOFT =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = soft)
    (ORACLE_HOME = C:\oracle\ora81)
    (SID_NAME =soft)
    ))
    After restarting the ORACLE instance I run following SQL:

    select sid, server
    from v$session
    /

    Then I get the result as all the servers is DEDICATED.

    We have more than 20 sessions connected. Is there any settings require to set for listener.ora and tnsnames.ora files?

    Please can you help how to set MTS for ORACLE.

    Thanks,
    Raju

  2. #2
    Join Date
    Mar 2001
    Posts
    144
    one thing I see at the moment is forcing the client to connect as shared. Add the line (server=shared) in the connect_data section of the entry to the tnsnames.ora. It should read something like this:

    sofT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.144.121)(PORT = 1521))
    )
    (CONNECT_DATA = (service_name = soft)
    (SERVER=SHARED))
    )

    I am not too sure about the mts_listener_address parameter though as it's obsolete for 8.1.7. I think you may need to remove that line and edit the mts_dispatchers line or add local_listener parameter.

    HOH

    [Edited by ramaral on 08-07-2002 at 08:48 AM]

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    You better check documentation, Oracle SE may not have MTS option at all.
    Best wishes!
    Dmitri

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