Re: MTS Gurus: I need config help

Brian Martin <icbkr_at_ix.netcom.com> wrote:
>Anybody with a working set of MTS listeners on 7.x,
>please send me your /etc/tnsnames.ora and ~/network/admin/listner.ora
>files so i can compare to mine. something is obviously fubared
>since when i connect using a tns connection, i get these
>goofy (LOCAL=NO) processes. Also, anybody knowing of a
>decent summary of the whole ob.MTS, please let me know.
>
>This MTS stuff is documented like Whitewater. I know where the
>Clinton's can go for their biographies: Oracle Documentation...
>
>bmartin
>ever vigilant in his pusuit of performance!
>SPOON!
Your use of the term 'Guru' put me off at first but I have decided to reply because I have recently cleaned up this same problem at my site. What I found and did may be of use to you.
What follows is the result of my own investigation and assistance from Oracle Support.

The (LOCAL=NO) process is a dedicated server process. If it occurs when you are logged onto the server and have TWO_TASK set to a tns 'service' name then the place to look for a possible problem is in init???.ora. The line I had to change was
MTS_DISPATCHERS = "tcp,2" to MTS_DISPATCHERS = "tcp,2","ipc,2" you also need the lines
(ADDRESS =
  (PROTOCOL = IPC)
  (KEY = <service_name.domain>)
)
in listener.ora (in the address_list section) where service_name is what is in TWO_TASK (and therefore in tnsnames.ora) and domain is whatever you have defined (the default is .world) and is in sqlnet.ora.

If the (LOCAL=NO) process occurs when you are logged onto a client and have TWO_TASK set then the place to look is in tnsnames.ora. If you have something like (CONNECT_DATA = (SID = MYSID)(SRVR = DEDICATED) then this condition will occur (caveat here - this might not be the only place in tnsnames.ora where you can place the (SRVR = DEDICATED) parameter but it works on my system).

I also noticed that there was a noticable delay after starting the listener before the MTS dispatcher connections where complete. Mine takes a few seconds less than 3 minutes. If a connection is attempted during this time then a dedicated server will be created. To check when the the MTS connections had been completed I did lsnrctl server
which shows all dispatchers. (another caveat - this delay may only be on my system).

I hope this is of some help.

Geoff Received on Wed Sep 04 1996 - 00:00:00 CEST