All,

Were running V8.1.7.4 of the database on HP-UX 11.11
I have a database setup to use MTS. The following MTS parameters are
set in the init.ora file
mts_dispatchers='ipc,5'
mts_dispatchers='tcp,5'
mts_max_dispatchers=50
mts_servers=10
mts_service=testdb
mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(KEY= testdb)(host=172.27.248.12)(port=1521))"


An output from the LSNRCTL> services command is shown below. It shows
that the testdb database has all of the dispatchers registered with
the listener.
LSNRCTL> services
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))
Services Summary...
extproc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
testdb has 10 service handler(s)
DISPATCHER established:3 refused:0 current:0 max:2046 state:ready
D009 <machine: arcrm1, pid: 16060>
(ADDRESS=(PROTOCOL=tcp)(HOST=arcrm1)(PORT=65298))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D008 <machine: arcrm1, pid: 16058>
(ADDRESS=(PROTOCOL=tcp)(HOST=arcrm1)(PORT=65297))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D007 <machine: arcrm1, pid: 16056>
(ADDRESS=(PROTOCOL=tcp)(HOST=arcrm1)(PORT=65296))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D006 <machine: arcrm1, pid: 16054>
(ADDRESS=(PROTOCOL=tcp)(HOST=arcrm1)(PORT=65295))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D005 <machine: arcrm1, pid: 16052>
(ADDRESS=(PROTOCOL=tcp)(HOST=arcrm1)(PORT=65294))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D004 <machine: arcrm1, pid: 16050>
(ADDRESS=(PROTOCOL=ipc)(KEY=#16050.1))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D003 <machine: arcrm1, pid: 16047>
(ADDRESS=(PROTOCOL=ipc)(KEY=#16047.1))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D002 <machine: arcrm1, pid: 16045>
(ADDRESS=(PROTOCOL=ipc)(KEY=#16045.1))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D001 <machine: arcrm1, pid: 16043>
(ADDRESS=(PROTOCOL=ipc)(KEY=#16043.1))
DISPATCHER established:0 refused:0 current:0 max:2046 state:ready
D000 <machine: arcrm1, pid: 16041>
(ADDRESS=(PROTOCOL=ipc)(KEY=#16041.1))
The command completed successfully
LSNRCTL>


I can connect to the database with no problem from any client,
HOWEVER, when I setup the connection in my TNSNAMES.ORA file to use a
(SERVER=DEDICATED) connection, to override the MTS settings, I receive
the following error message:

/orabase/products/8.1.7.4/network/admin> sqlplus system@testdb

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 25 09:35:07 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-12519: TNS:no appropriate service handler found




This is how I setup my tnsnames.ora file to use a dedicated server
which generates the error message above.
testdb =
(description=
(address=(protocol=tcp)(host=172.27.248.12)(port=1 521))
(connect_data=
(sid=testdb)
(instance_name=testdb)
(server=dedicated)
))


Anyone have any ideas why the MTS connections (i.e. (SERVER=SHARED) )
work but dedicated connections do not?

On 25 Jun 2003 06:35:54 -0700, jpsebasti (AT) hotmail (DOT) com (JP) wrote:


Evidently you didn't read the documentation prior to setting up mts.
You are using the mts parameters in the v7 fashion.
The mts_listener parameter is obsolete and shouldn't be used, the
mts_dispatchers parameter has different syntax and is now used to set
up all of mts. Please read the documentation and revise your mts
parameter accordingly.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address