Wednesday 10 July 2013

Lesson 62 : What is Service in RAC

What is Service in RAC ?

Services are the entry point to the database. Service names will be used by the clients to connect to the database. Services are created and started on an instance. The service can be configured to run on any instance and thus the client do not need to know which instance it is connecting to. Services offer greater flexibility in maintaining client connections.

You should always use srvctlto manage services in RAC environment. Do not use service_namesdatabase initialization parameter or DBMS_SERVICES packages to create and manage services. Because services are automatically started and stopped on the individual instances by the clusterware by setting the service_namesparameter. Hence you manually modify this parameter, that will interfere with the clusterware operation.

No comments:

Post a Comment