Differences

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

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