Database Services

Database Services

Database Services tab allows you to register Oracle8i release 8.0 or Oracle7 databases with the listener.

An Oracle8i release 8.1 database dynamically instance registers itself with the listener. When configuring a listener for use with an Oracle8i release 8.1, it is not necessary to configure the listener with information about the database. Release prior to this release still require static configuration in the LISTENER.ORA.

Add Database button:

Click this button to specify a database service for the listener. A new Database tab displays where you can select the protocol and enter protocol information in the fields.

Remove Database button:

Click this button to delete the database in the current Database tab displayed.

Database tab:

Use this tab to configure a listener to handle requests for Oracle8i release 8.0 or Oracle7 database services, you will need to provide information that the listener needs to identify and then start those services. Static configuration is also required for other services, such as external procedures and heterogeneous services, and some management tools. You do this by specifying the following:

Global Database Name:

Enter the database name and domain name of the database as provided in the INIT.ORA file. If you want to refer to the database by its global database name on the network, then you must specify that global database name to the listener.

Oracle Home Directory:

Specify the Oracle home location of the database.
Note: Windows NT already know the Oracle home. Therefore, this option is not needed for connection to a service on Windows NT.

SID:

Specify the system identifier.

Do Not Use Prespawned Dedicated Servers:

Select this option if you do not want to use prespawned dedicated servers.

Use Prespawned Dedicated Servers:
Select this option if you want to use prespawned dedicated servers to improve the time it takes to establish a connection to a server where the multi-threaded server is not in use or is not supported on a given machine. Prespawned dedicated servers also allow for better use of allocated memory and system resources by recycling server processes. They do this by creating ready to use database service processes to handle requests on various protocols. This way, users do not need to wait for a new process to initialize when making a connection.
Note: Prespawned dedicated servers are not available on Windows NT.

Configure Prespawned Servers button:
Click this button to view or alter the default characteristics of prespawned servers.
Note: Prespawned dedicated servers are not available on Windows NT.

Global Database Name:	Enter the database name and domain name of the database as provided in the INIT.ORA file. If you want to refer to the database by its global database name on the network, then you must specify that global database name to the listener.
Oracle Home Directory:	Specify the Oracle home location of the database. Note: Windows NT already know the Oracle home. Therefore, this option is not needed for connection to a service on Windows NT.
SID:	Specify the system identifier.
Do Not Use Prespawned Dedicated Servers:	Select this option if you do not want to use prespawned dedicated servers.
Use Prespawned Dedicated Servers:	Select this option if you want to use prespawned dedicated servers to improve the time it takes to establish a connection to a server where the multi-threaded server is not in use or is not supported on a given machine. Prespawned dedicated servers also allow for better use of allocated memory and system resources by recycling server processes. They do this by creating ready to use database service processes to handle requests on various protocols. This way, users do not need to wait for a new process to initialize when making a connection. Note: Prespawned dedicated servers are not available on Windows NT.
Configure Prespawned Servers button:	Click this button to view or alter the default characteristics of prespawned servers. Note: Prespawned dedicated servers are not available on Windows NT.