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 11:22]
gerardnico
db:oracle:service_handler [2017/09/06 19:29] (current)
gerardnico ↷ Page moved from oracle:service_handler to db:oracle:service_handler
Line 13: Line 13:
 ===== 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.1279876969.txt.gz · Last modified: 2010/07/23 11:22 by gerardnico