Re: MTS Server Configuration

Jay Mehta wrote:
> "Oracle<SID> (DESCRIPTION=(Local=yes) (Address=(protocaol=beq)))" If we
> want to use mts servers/dispatchers for all the users including ones
> from unix server itself, what changes do we make?

As I'm given to understand it, all you need to do is specify the same service in your local connect string as you do from a remote login and then ensure your mts dispatchers are listening on "ipc".

ergo:

from client, you connect as username/password_at_service from commandline, you connect as username/password_at_service

in your init*.ora, in the mts section, you should have a piece like
set_some_mts_variable="tcp,2"
or whatever
make it look like this: ="tcp,2","ipc,1"

and restart your database.

MTS is weird, I've got it working on one box, but on a nearly identical box using config files that were copied and modified for the different hostid, it doesn't work.

*sigh* Received on Fri Sep 06 1996 - 00:00:00 CEST