Setting Initialization Parameters for Service Registration

To ensure service registration works properly, the initialization parameter file should contain the following parameters:

• SERVICE_NAMES for the database service name

• INSTANCE_NAME for the instance name

• LOCAL_LISTENER for the local listener

• REMOTE_LISTENER for the remote listener, if any

• FORWARD_LISTENER for the forward listener

For example:

SERVICE_NAMES=sales.us.example.com
INSTANCE_NAME=sales

The value for the SERVICE_NAMES parameter defaults to the global database name, a name comprising the DB_NAME and DB_DOMAIN parameters in the initialization parameter file. The value for the INSTANCE_NAME parameter defaults to the Oracle system identifier (SID).

Note: Starting with Oracle Database 19c, customer use of the SERVICE_NAMES parameter is deprecated. To manage your services, Oracle recommends that you use the SRVCTL or GDSCTL command line utilities, or the DBMS_SERVICE package.

See Also: Oracle Database Reference for additional information about the SERVICE_NAMES and INSTANCE_NAME parameters