Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> linux Oracle8i MTS configuration
I have unsucessfully tried setting up an MTS connection for Oracle8i but
have come up short.
I am following directions from the book Oracle8i for linux starterkit.
In the book it says to configure the $ORACLE_HOME/dbs/initSID.ora file.
The parameters it tells me to add are:
mts_dispatchers = "(protocol=TCP)(DISP=1)(mul=OFF)(pool=OFF)" mts_servers = 1 mts_max_servers = 20
I followed the directions but my results were not correct.
I just was wondering if there were anythin I was missing since I followed
the book.
Do I have to create a listener first? Setup Net8?? the book does not
mention these things till later.
It only mentions that to check to see if the MTS configuration has worked
then run the query:
select server
from v$session where audsid = USERENV('SESSIONID');
where the server field should be SHARED and in my case it remains
DEDICATED.
I do not want to continue with the Oracle setup until resolving this
issue, again I do not know much about Oracle setup and NET8 configuration
but as far as the book goes I should see the correct value which is
SHARED.
I am not the only one with this problem I have seen posts from others.
If anyone can help I appreciate their effort.
please email me at: intellect2k_at_hotmail.com
thank you,
intellect2k
Received on Fri Jun 15 2001 - 01:17:11 CDT