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

From: JP <jpsebasti_at_hotmail.com>
Date: 25 Jun 2003 11:57:03 -0700
Message-ID: <e5d36cc8.0306251057.1ba9e6d@posting.google.com>

We got it working now.
According to Oracle, we were not using current MTS parameters in the database.

Here is what we were using:

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))"

Here is what they recommended and what appears to have fixed the problem:

mts_dispatchers= "(PROTOCOL=TCP)(DISPATCHERS=5)"
mts_max_dispatchers=10
mts_servers=10
mts_max_servers=15

local_listener="(ADDRESS=(PROTOCOL=tcp)(host=172.27.248.12) (port=1521))"

Also, after the above parameters were changed to what Oracle recommended, the suggestion made earlier to use GLOBAL_DBNAME=testdb in the listener.ora parameter file also works.
> 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 - 13:57:03 CDT