Database Services

The Database Services tab enables you to specify the database service(s) for which the listener is to receive connect requests. The listener needs this information to connect a client to the database.

If the database is Oracle8i, static service information is not required in the listener.ora file. Service information is registered with the listener automatically through service registration. If you are using Oracle Enterprise Manager, static information for an Oracle8i database is required.

Static information in the listener.ora file is required for an Oracle8 database or Oracle7 database.

Click Add Database to add database service information.

Global Database Name

Enter the database name and domain name of the database as provided by the SERVICE_NAMES parameter or DB_NAME and DB_DOMAIN parameters in the initialization file.

Oracle Home Directory

Enter the Oracle home location of the database.

notice.gif
Note: Windows NT already knows the Oracle home. Therefore, this field is not needed for a connection to a service on Windows NT.

SID

Enter the Oracle System Identifier (SID) for the instance.

Do Not Use Prespawned Dedicated Servers

Click to not use prespawned dedicated servers.

Use Prespawned Dedicated Servers

Click to use prespawned dedicated servers to improve the time it takes to establish a connection to a server where the multi-threaded server (MTS) connection model is not in use or is not supported on a given machine.

notice.gif
Note: Prespawned dedicated servers are not available on Windows NT.

Configure Prespawned Servers button

Click to specify the number prespawned dedicated server to start for the listener. These pre-started dedicated servers last for the life of the listener.

Add Database button

Click to configure service information for a database. A new Database tab displays where you can enter service information for another database.

Remove Database button

Click to delete the selected Database tab and its service information.

seealso.gif
See Also:
Statically Configure Database Service Information
Configure Prespawned Dedicated Servers for Database Services