Mts

[yxez]

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

[davey23uk]

nothing to do with each other

[yxez]

thanks dave,

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

[davey23uk]

same as usual

[yxez]

thanks dear you seem tired...u talk so little

[yxez]

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

[davey23uk]

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

[yxez]

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