Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MTS Connection Problem
Frank,
what OS are you running on?
Here is my 2 cases(both listeners are on port 1521):
1, I have oracle 8.0.5.1.0 running on Linux, the mts parameters:
mts_dispatchers="tcp,1" mts_max_dispatchers=10 mts_servers=1 mts_max_servers=10 mts_service=devl mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(host=serverpc))"
the listener 'passed' the connection to a randam port which was
registered to
the listener when the Database started.
my client points to port 1521 on which the listener listens, the
client got a
shared connection without any problems.
2, I have 8.1.6.0.0 running on NT40 server. the mts paramters:
mts_dispatchers = "(ADDRESS=(PROTOCOL=TCP)(HOST=sun)(port=5000))(dispatchers=1)"
in this case, if a client points to port 1521 from a different
machine, it wouldn't work, but if the client points to port 5000 which
is specified in the
parameter, the client got a shared connection.
if the client pointed to 1521 or 5000 from same machine as the server, they worked as stated in your post. However the 1521 connection gets a dedecated connection, 5000 gets a shared connection.
I also tried to specified 1521 in the mts paramter as you did, the
listener
simply ignores the Database's request and starts only the dedicated
services.
Hope this helps
Ping
Frank Zimmer <zimmer_at_i7-business.com> wrote in message news:<3B8A4739.4E03A9D_at_i7-business.com>...
> Hi,
> i'm trying to set up a MTS Environment and now i get problems connecting
> to the DB (configured as an MTS Server from init.ora
>
> mts_dispatchers = "(protocol=TCP)(disp=2)"
> mts_listener_address = "(ADDRESS=(PROTOCOL=tcp)(HOST=I7A39)(PORT=1521))"
> mts_max_dispatchers = 5
> mts_max_servers = 5
> mts_servers = 5 )
>
> now connecting to the server from the same machine with e.g SQL+ works
> with no problems, but trying to connect from a remote machine will not
> work,
> i get the error message 12545 -
>
> what's my error ???
>
> greetings
>
> Frank Zimmer
Received on Mon Sep 03 2001 - 16:26:52 CDT