Differences

> Markup Language (ML) > Extensible Markup Language (XML)

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
db:oracle:service_handler [2010/07/23 09:35]
gerardnico
db:oracle:service_handler [2017/09/06 19:29] (current)
gerardnico ↷ Page moved from oracle:service_handler to db:oracle:service_handler
Line 2: Line 2:
  
 ===== About ===== ===== About =====
-Service handlers act as connection points ​to an Oracle database. A service handler can be a: +Service handlers act as connection points ​from the [[listener|listener]] to an Oracle database
-  * shared server process with a [[dispatcher|dispatcher]] +
-  * or a dedicated server process,  +
-  * or pooled.+
  
-You can configure it in the [[connect descriptor|connect descriptor]].+A service handler can be a: 
 +  * [[dispatcher|dispatcher in shared server configuration]] 
 +  * or a [[dedicated server process|dedicated server process]],  
 +  * or [[pooled server|pooled]]. 
 + 
 +You can configure it for a client connection ​in the [[connect descriptor|connect descriptor]] ​with the SERVER parameter.
  
 ===== Articles Related ===== ===== Articles Related =====
 {{backlinks>​.}} {{backlinks>​.}}
 +
 +===== How to see which service handler is configured? =====
 +To see which service handler is configured for a [[database service|service]],​ enter this command:
 +<​code>​
 +lsnrctl SERVICES [listener_name]
 +</​code>​
 +The SERVICES command lists the services supported by the database, along with at least one available service handler.
 +In the example belwo, it's a dedicated server process.
 +
 +<​file>​
 +[[email protected] tmp]$ lsnrctl SERVICES listener
 +
 +LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-JUL-2010 13:16:34
 +
 +Copyright (c) 1991, 2009, Oracle. ​ All rights reserved.
 +
 +Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel11g.localdomain)(PORT=1521)))
 +Services Summary...
 +Service "​oel11g.localdomain"​ has 1 instance(s).
 +  Instance "​oel11g",​ status READY, has 1 handler(s) for this service...
 +    Handler(s):
 +      "​DEDICATED"​ established:​0 refused:0 state:ready
 +         LOCAL SERVER
 +Service "​oel11gXDB.localdomain"​ has 1 instance(s).
 +  Instance "​oel11g",​ status READY, has 1 handler(s) for this service...
 +    Handler(s):
 +      "​D000"​ established:​0 refused:0 current:0 max:1022 state:ready
 +         ​DISPATCHER <​machine:​ oel11g.localdomain,​ pid: 11508>
 +         ​(ADDRESS=(PROTOCOL=tcp)(HOST=oel11g.localdomain)(PORT=42593))
 +The command completed successfully
 +</​file>​
  
 ===== Documentation / Reference ===== ===== Documentation / Reference =====
   * [[http://​download.oracle.com/​docs/​cd/​E11882_01/​network.112/​e10836/​concepts.htm#​CIAHBJAD|Understanding Service Handlers]]   * [[http://​download.oracle.com/​docs/​cd/​E11882_01/​network.112/​e10836/​concepts.htm#​CIAHBJAD|Understanding Service Handlers]]
db/oracle/service_handler.1279870552.txt.gz · Last modified: 2010/07/23 09:35 by gerardnico