Differences

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Text|String|Character)

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 11:00]
gerardnico
db:oracle:service_handler [2017/09/06 19:29] (current)
gerardnico ↷ Page moved from oracle:service_handler to db:oracle:service_handler
Line 5: Line 5:
  
 A service handler can be a: A service handler can be a:
-  * [[dispatcher|shared server ​process with a dispatcher]] +  * [[dispatcher|dispatcher in shared server ​configuration]] 
-  * or a dedicated server process,  +  * or a [[dedicated server process|dedicated server process]],  
-  * or pooled.+  * or [[pooled ​server|pooled]].
  
-You can configure it in the [[connect descriptor|connect descriptor]].+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.1279875605.txt.gz · Last modified: 2010/07/23 11:00 by gerardnico