(SERVER=SHARED) connections work but (SERVER=DEDICATED) does not

From: JP <jpsebasti_at_hotmail.com>
Date: 25 Jun 2003 06:35:54 -0700
Message-ID: <e5d36cc8.0306250535.340890da@posting.google.com>

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_at_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=1521))
        (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? Received on Wed Jun 25 2003 - 08:35:54 CDT