Re: linux Oracle8i MTS configuration

Hi,

Below is an example of my mts linux 8i settings:  mts_dispatchers = "(address=(partial=true)(protocol=tcp)(host=192.168.1.77)(queu esize=128)) (dispatchers=5) (connections=100) (sessions=50)" mts_servers=1
mts_max_servers=4

From looking at your setup you are not specifying the host. To check if mts is running, access lsnrctl and type services. You should see dispatcher processes.

"intellect2k" <intellect2k_at_hotmail.com> wrote in message news:<HLhW6.15107$i03.3433428_at_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 - 05:58:27 CDT