Add/Edit Static Database Service Page

Use this page to enter or edit static database registration information for a listener. The changes you make here are applied to the listener.ora file, rather than to a running listener.

For more information, see the chapter "Configuring and Administering the Listener" in the Oracle Net Services Administrator's Guide.

Usage Tips

The following table lists some of the fields to which you should pay close attention:

Field	Description
Service Name	Use this field to identify the database service. While processing a client connection request, the listener tries to match the value of this parameter with the value of the `SERVICE_NAME` parameter in the client connect descriptor. If the client connect descriptor uses the SID parameter, then the listener does not attempt to map the values. This parameter is primarily intended for configurations with Oracle8 release 8.0 or Oracle7 databases (where dynamic service registration is not supported for dedicated servers). This parameter may also be required for use with Oracle8i, Oracle9i, and Oracle 10g database services by some configurations.
Oracle Home Directory	Use this setting to specify the Oracle home location of the instance. Without this setting, the listener assumes its Oracle home for the instance. On Windows, this setting is specified by the `ORACLE_HOME` parameter in `HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID` of the Windows registry.
Oracle System Identifier (SID)	Use this field to specify the Oracle System Identifier (SID) of the instance. You can obtain the SID value from the `INSTANCE_NAME` parameter in the initialization parameter file.

Field

Description

Service Name

Use this field to identify the database service.

While processing a client connection request, the listener tries to match the value of this parameter with the value of the SERVICE_NAME parameter in the client connect descriptor. If the client connect descriptor uses the SID parameter, then the listener does not attempt to map the values.

This parameter is primarily intended for configurations with Oracle8 release 8.0 or Oracle7 databases (where dynamic service registration is not supported for dedicated servers). This parameter may also be required for use with Oracle8i, Oracle9i, and Oracle 10g database services by some configurations.

Oracle Home Directory

Use this setting to specify the Oracle home location of the instance. Without this setting, the listener assumes its Oracle home for the instance.

On Windows, this setting is specified by the ORACLE_HOME parameter in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID of the Windows registry.

Oracle System Identifier (SID)

Use this field to specify the Oracle System Identifier (SID) of the instance. You can obtain the SID value from the INSTANCE_NAME parameter in the initialization parameter file.

Related Topics

Creating a Listener

Configuring Listeners

About Listeners

Enterprise Manager Information Roadmap