-
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 :) :D
Thanks a lot
-
nothing to do with each other
-
thanks dave,
So can i add mts dispatchers in 10g by editing init.ora also?
-
-
thanks dear :D you seem tired...u talk so little :p
-
hi davey....
I tried to alter sytem and set mts_dispatchers = 3 in 10g ...but...
it says its already obsolete in 10g :confused:
How can i enable muti-threaded server in 10g pls
Thanks
-
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
-
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