Oracle Database - Database Service

Card Puncher Data Processing

About

An Oracle database is represented to clients as a service. A database can have one or more services associated with it.

When an instance starts, it registers itself with a listener using one or more service names.

A service is identified by a service name, for example, sales.us.example.com. The service name is specified by the SERVICE_NAMES initialization parameter. The DBMS_SERVICE package can also be used to create services.

A client uses a service name to identify the database it must access. The information about the database service and its location in the network is transparent to the client because the information needed for a connection is stored in a repository.

To connect to a database service, client applications use a connect string.

Architecture

One Service for Each Database

Oracle Database One Service For Each Database

The sales and finance databases are each identified by a service name, sales.us.example.com and finance.us.example.com, respectively. A service name is a logical representation of a database. When an instance starts, it registers itself with a listener using one or more service names. When a client program or database connects to a listener, it requests a connection to a service.

A service name can identify multiple database instances, and an instance can belong to multiple services. For this reason, the listener acts as a mediator between the client and instances and routes the connection request to the appropriate instance. Clients connecting to a service need not specify which instance they require.

Multiple Services Associated with One Database

Oracle Database Multiple Services Associated With One Database

Associating multiple services with one database enables the following functionality:

  • A single database can be identified different ways by different clients.
  • A database administrator can limit or reserve system resources. This level of control enables better allocation of resources to clients requesting one of these services.

How to

know the services of a database

Metadata

select service_id, name from v$services;
SERVICE_ID NAME
---------- ----------
         6 pdborcl.HotITem.local
         5 orclXDB
         6 orcl.HotITem.local
         1 SYS$BACKGROUND
         2 SYS$USERS

listener

You can use the listener command below.

lsnrctl service
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 02-OCT-2013 14:48:47

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "orcl.HotITem.local" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:707 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB.HotITem.local" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: HI-LAPTOP-NGD, pid: 4888>
         (ADDRESS=(PROTOCOL=tcp)(HOST=HI-LAPTOP-NGD.HotITem.local)(PORT=17435))
Service "pdborcl.hotitem.local" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:707 refused:0 state:ready
         LOCAL SERVER
The command completed successfully





Discover More
Card Puncher Data Processing
Oracle Database - Configuration of the Listener (listener.ora)

A listener is configured with one or more listening protocol addresses, information supported services, and parameters that control its run-time behavior. The listener configuration is stored in the configuration...
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...
Card Puncher Data Processing
Oracle Database - Connect Identifier

A connect idenfier is the part of the connect string when a users initiate a connection to designate the service to which they want to connect to. The connect identifier is : a connect descriptor....
Card Puncher Data Processing
Oracle Database - Connect String (Client Connection Initiation)

Users initiate a connection request to a database service by providing a connect string. A connect string includes: a username and password, along with a connect identifier. A connect identifier...
Oracle Database Net Ldap
Oracle Database - Directory naming method (LDAP-compliant)

A naming method that resolves a database service, net service name, or net service alias to a connect descriptor stored in a central directory server. The directory naming method stores connect identifiers...
Card Puncher Data Processing
Oracle Database - Input/Output (I/O)

physical io (on the drive) is aimed to seed the buffer cache where the logical io (database logical) occurs. There are several ways to handle excessive I/O waits. In the order of effectiveness, these...
Oracle Database Listener
Oracle Database - Listener

When an database instance starts, it registers itself with a listener using one or more service names. When a client program or database connects to a listener, it requests a connection to a service. ...
Card Puncher Data Processing
Oracle Database - Naming method (naming resolution method)

The Oracle Net Services naming method is resolution method used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service. They...
Card Puncher Data Processing
Oracle Database - Net Service Alias

An alternative name for a directory naming object in a directory server. A directory server stores net service aliases for any defined net service name or database service. A net service alias entry...
Card Puncher Data Processing
Oracle Database - Net Service Name (tnsname)

A simple name for a service that resolves to a connect descriptor. Users initiate a connect request by passing a user name and password, along with a net service name in a connect string, for the service...



Share this page:
Follow us:
Task Runner