-
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
-
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]
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|