13.5 Configuring Static Service Registration
The listener uses the dynamic service information about the database and instance before using statically configured information in the listener.ora
file.
Configuration of static service information is necessary in the following cases:
-
Use of external procedure calls
-
Use of Oracle Heterogeneous Services
-
Use of Oracle Data Guard
-
Remote database startup from a tool other than Oracle Enterprise Manager Cloud Control
-
Connections to Oracle databases earlier than Oracle8i release 2 (8.1)
- Parameters for Static Service Registration
Understand the static service settings in thelistener.ora
file for static service registration. - Configuring Static Service Information for the Listener
Learn how to statically configure database service information for the listener using Oracle Enterprise Manager Cloud Control.
Parent topic: Enabling Advanced Features of Oracle Net Services
13.5.1 Parameters for Static Service Registration
Understand the static service settings in the listener.ora
file for static service registration.
Example listener.ora File
This example shows a listener.ora
file configured for static service registration. The LISTENER
entry defines the listening protocol address for a listener named Listener
, and the SID_LIST_LISTENER entry provides information about the external services statically supported by the Listener
listener.
LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=extproc) (queuesize=50)))) SID_LIST_listener= (SID_LIST= (SID_DESC= (SID_NAME=plsextproc) (ORACLE_HOME=/oracle8) (PROGRAM=extproc)))
The SID_LIST_listener_name parameter setting in the listener.ora
file specifies information about the databases served by the listener. When services are configured statically, a listener starts a dedicated server process when it receives a client request. If the instance is not up, then the server returns an Oracle not available
error message.
If a database cannot find the listener, then configure the listener.ora
file with the GLOBAL_DBNAME parameter, as shown in the following example
SID_LIST_listener=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME
=sales.example.com)
(SID_NAME=sales)
(ORACLE_HOME=/u01/app/oracle))
Static Service Settings in listener.ora
Parent topic: Configuring Static Service Registration
13.5.2 Configuring Static Service Information for the Listener
Learn how to statically configure database service information for the listener using Oracle Enterprise Manager Cloud Control.
Note:
If you are using connect-time failover or TAF, such as in an Oracle Real Application Clusters environment, then do not set the GLOBAL_DBNAME parameter.
-
Access the Net Services Administration page in Oracle Enterprise Manager Cloud Control.
-
Select Listeners from the Administer list, and then select the Oracle home that contains the configuration files.
-
Click Go. You may be prompted to log in to the database server.
The Listeners page appears.
-
Select a listener, and then click Edit.
The Edit Listener page appears.
-
Click the Static Database Registration tab, and then click Add.
The Add Database Service page appears. Enter the required information in the fields.
-
Click OK.
Note:
You can also configure static service information with Oracle Net Manager. See Statically Configure Database Service Information in the online help for additional information.