linux oracle MTS configuration
Date: Fri, 15 Jun 2001 06:11:33 GMT
Message-ID: <pGhW6.15106$i03.3432296_at_typhoon.jacksonville.mediaone.net>
I have unsucessfully tried setting up an MTS connection for Oracle8i but
have come up short.
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.
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
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
intellect2k
Received on Fri Jun 15 2001 - 08:11:33 CEST