Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

From: Durinda.Jones <Durinda.Jones_at_yellowcorp.com>
Date: Wed, 25 Jul 2001 10:52:29 -0700
Message-ID: <F001.00354E5B.20010725110838@fatcity.com> 






A couple of things I would check.  I don't believe you need the ADDRESS_LIST
parameter, unless you will have multiples.  I would remove the spaces in the
parameter.  I would make sure that the HOST equals the machine name,
possibly make the entry upper case.  As foolish as it sounds, I've seen
these things make a difference.



Set it up to look like this and see if it helps.  LOCAL_LISTENER =
"(Address=(Protocol=TCP)(Host=ORA2000)(Port=1521))" 



I recently had a problem where the HOST wasn't the same as the machine name.
Fixed that and the problem went away.



Hope this helps out,


Durinda



-----Original Message-----


Sent: Wednesday, July 25, 2001 1:11 PM


To: Multiple recipients of list ORACLE-L




this option is not set so i assume default is OFF.......
any other clue.......



-----Original Message-----


Sent: Wednesday, July 25, 2001 12:26 PM


To: Multiple recipients of list ORACLE-L




Check the client's sqlnet.ora.  It can override the server config with
USE_DEDICATED_SERVER=ON setting.



Steve



-----Original Message-----


Sent: Wednesday, July 25, 2001 10:36 AM


To: Multiple recipients of list ORACLE-L





Hi,



I have configured the server to use MTS and still dedicated connections r
used.


What might be the reason....database is 8.1.6.3.4





LSNRCTL> services


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...


  ora2000               has 6 service handler(s)
    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready

      D004 <machine: ORA2000, pid: 1956>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D003 <machine: ORA2000, pid: 1952>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D002 <machine: ORA2000, pid: 1948>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D001 <machine: ORA2000, pid: 1944>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D000 <machine: ORA2000, pid: 1940>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))

  PLSExtProc            has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  ora2000               has 6 service handler(s)
    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D004 <machine: ORA2000, pid: 1956>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D003 <machine: ORA2000, pid: 1952>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D002 <machine: ORA2000, pid: 1948>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D001 <machine: ORA2000, pid: 1944>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387))

    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D000 <machine: ORA2000, pid: 1940>


      (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385))

  ora2000               has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  ora2000               has 6 service handler(s)
    DEDICATED SERVER established:76 refused:0
      LOCAL SERVER




The command completed successfully




init.ora looks like:


mts_dispatchers = "TCP,5"
mts_max_dispatchers=50 
mts_servers=20  
mts_max_servers=50 




LOCAL_LISTENER = "(ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000)
(Port=1521)))" 




Thanks


Harvinder

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Austin, Steve S
  INET: steve.s.austin_at_xo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Durinda.Jones
  INET: Durinda.Jones_at_yellowcorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Received on Wed Jul 25 2001 - 12:52:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US