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

Thread: Mts

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    Mts

    Hi Friends,

    Im confused about multi-threading system(MTS) and agtctl.
    Are these two terms the same? I guess they involved dispatchers.

    In 8i, to be able to use MTS, you just have to edit the init.ora
    and add a line ....dispatchers=5. It is true also in 9i and 10g?
    or is it where this agtctl is all about.

    Can i configure MTS in 8i using agtctl command? honestly i haven't
    understand this agtctl yet coz its new to me


    Thanks a lot
    Last edited by yxez; 02-16-2006 at 10:42 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    nothing to do with each other

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks dave,

    So can i add mts dispatchers in 10g by editing init.ora also?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    same as usual

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks dear you seem tired...u talk so little

  6. #6
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    hi davey....

    I tried to alter sytem and set mts_dispatchers = 3 in 10g ...but...
    it says its already obsolete in 10g


    How can i enable muti-threaded server in 10g pls


    Thanks

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    hasnt been called MTS for ages, shared_server now

    a very very quick search of the doc came up with ....

    http://download-uk.oracle.com/docs/c...c.htm#i1010000

  8. #8
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks davey...

    This is my first time to configure MTS Shared server as we always use the default dedicated server

    On my 10g AIX 5L database, I issue this:

    ALTER SYSTEM SET SHARED_SERVERS = 5;

    And i edited my tnsnames.ora like this:

    ORA10 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.50)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = ora10.world)
    )
    )

    But when i run the command:

    $ sqlplus system/manager@ora10
    ERROR:
    ORA-12520: TNS:listener could not find available handler for
    requested type of server

    But if i change the server=dedicated it will go thru...

    Did I miss something...

    ========================================

    We have also Oracle 8i on IBM AIX 4.3.3

    I configured the MTS by editing the init.ora and add mts_dispatchers=5
    then bounced the db.

    on my local tnsnames i have:

    ORA8 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.60)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = ora8.world)
    )
    )

    When I run locally $ sqlplus system/manager@ora8 ....it worked

    But when I run it using windows client I got 10g
    client on windows with same tnsnames.ora
    SQL> connect system/manager@ora8
    ERROR:
    ORA-12545: Connect failed because target host or object does not exist

    ....but when i run it on client on AIX 4.3.3 10g is was successful.

    Any help pls...Thanks again
    Last edited by yxez; 02-20-2006 at 10:02 AM.

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