Database Services for an Oracle RAC Database
Each database is represented by one or more services and a service is identified by a service name. A client uses service names to identify databases.
During installation, Oracle RAC databases are configured with a default database service that has the same name as the database. This service can be used for performing database management tasks. Create additional services for client and application connections to the database.
A service name, for example sales.example.com
, can be associated
with multiple database instances, and an instance can be associated with multiple
services. The listener acts as a mediator between the client and database instances and
routes the connection request to the appropriate instance. Clients connecting to a
service do not have to specify which instance they want to connect to.