| Question about MTS_DISPATCHERS [message #162612] |
Sun, 12 March 2006 03:05 |
Vamshee
Messages: 32
Registered: February 2005
|
Member |
|
|
Hi
Our Current Environment: Oracle 8.1.7 / windows.
We have a Production Database and its Standby Database
resting on two different servers.
On going through the init file of Prod Database, i
have come accross this line
***********************************
mts_dispatchers = "(protocol=TCP)(tick=15)(pool=true)"
***********************************
On Standby its specified as
*************************************
mts_dispatchers = "(protocol=TCP)"
**************************************
Also,i noticed that on the tnsnames.ora
server=dedicated parameter is issues as follows
CPPP.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
CPPPROD-APPDATA.CA.KP.ORG)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)(SID = CPPPSTBY))
Question : 1
-------------
what is the significance of using (tick=15)(pool=true)
under MTS_DISPATCHERS ?
( i tried searching through google and metalink , but couldnt find a relevant answer)
Question : 2
---------------
As i explained our current setup, do we really need to
have this mts_dispacther parameter.
(We are actually trying to get rid of (server=dedicated) parameter from the tnsnames.ora, however on taking it out the Oracle applications on client is not running.
Will taking out this mts parameters from PDB and SDB allow me in eliminate the DEDICATED parameter).
Thanks in Advance.
Regards,
Vamshee.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
