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.
![]() | 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.
![]() | 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.
![]() | See Also:
Statically Configure Database Service Information Configure Prespawned Dedicated Servers for Database Services |