Oracle Database - Service Handler

Card Puncher Data Processing

About

Service handlers act as connection points from the listener to an Oracle database.

A service handler can be a:

You can configure it for a client connection in the connect descriptor with the SERVER parameter.

How to see which service handler is configured?

To see which service handler is configured for a service, enter this command:

lsnrctl SERVICES [listener_name]

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.

[oracle@oel11g 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

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - Connect Descriptor (TNS Connect String)

The Connect Descriptor (known also as TNS Connect String) is a type of connect identifier. It defines the parameters that need the Oracle Net Service to connect to a database service : the protocol...
Oracle Database Dedicated Server
Oracle Database - Dedicated Server Process

In a dedicated server configuration, the listener starts a separate dedicated server process for each incoming client connection request dedicated to servicing the client. After the session is complete,...
Oracle Database Service Registration
Oracle Database - Service Registration

A feature by which the PMON process automatically registers information with a listener. Because this information is registered with the listener, the listener.ora file does not need to be configured with...
Oracle Database Shared Server
Oracle database - Dispatcher and Shared Server Process

The shared server architecture uses a dispatcher process to direct client connections to a common request queue. An idle shared server process from a shared pool of server processes picks up a request...



Share this page:
Follow us:
Task Runner