Re: linux oracle MTS configuration

"intellect2k" <intellect2k_at_hotmail.com> wrote in message news:<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 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.
> thank you,
> intellect2k

You need to have a listener running in order to be able to work with MTS. Please run the netasst utility and set up a listener and start it with lnsrctl start. If the database is already running while the listener starts, it will take a few minutes before it recognizes the database is running mts.
When configuring the listener forget about Oracle 8 connections unless you are planning to run Oracle Enterprise Manager also.

Note: MTS is by NO means MANDATORY, and if this is a single-user box I wouldn't bother configuring it.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Jun 15 2001 - 11:06:14 CEST