Re: linux Oracle8i MTS configuration

As I recall, you have to have a listener working first.

On Fri, 15 Jun 2001 06:17:11 GMT, "intellect2k" <intellect2k_at_hotmail.com> wrote:

>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 Mon Jun 18 2001 - 07:00:33 CDT