Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> linux Oracle8i MTS configuration

linux Oracle8i MTS configuration

From: intellect2k <intellect2k_at_hotmail.com>
Date: Fri, 15 Jun 2001 06:17:11 GMT
Message-ID: <HLhW6.15107$i03.3433428@typhoon.jacksonville.mediaone.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US