Skip to content

How to Add Service to Database

There're several ways that can add a service to the normal, typical database (non-CDB) as followings.

  • Instance Level: Alter System set Service_Names
  • The traditional approach only applies to normal databases or in root containers, it's simple and fast.

  • Database Level: DBMS_SERVICE Create a New Service
  • The DBMS_SERVICE package can make a customized service for both single-instance and RAC databases.

  • Cluster Level: Srvctl Add Service
  • The option is only suitable for RAC database, the difference is that the service is controlled by cluster.

As for adding a service to pluggable database (PDB), it's somewhat different.

Leave a Reply

Your email address will not be published. Required fields are marked *