Configure Server: Database

The Database tab enables you to configure storage of Oracle Names server information in a region database or in an Oracle Names server's local cache. A region database consists of tables stored in an Oracle database that is accessible by the Oracle Names server.

No Region Database

Click if you want service registration data replicated continuously among Oracle Names servers.

Region Database

Click if you want service registration data stored in an Oracle database. Specify the connection information so the Oracle Names server can connect to the database.

Database

Protocol
From the list, select the protocol for the address that the listener is configured to listen on. Depending on the protocol chosen, enter protocol parameter information in the fields as appropriate.
+ button
Click create a new protocol address. A new Address tab displays where you can select the protocol and enter protocol information in the fields.
X button
Click to remove the selected Address tab and its address information.
< button
Click to move the protocol address up in the list order.
> button
Click to move the protocol address down in the list order.
Advanced button
Click to configure multiple address options, such as source routing, connect-time failover, and client load balancing.
Service Name
Enter a service name if configuring this Oracle Names server to connect to a release 8.1 database service.
SID

Enter an Oracle System Identifier (SID) if configuring this Oracle Names server to connect to a pre-release 8.1 database.
Connect Type
From the list, specify how you want the Oracle Names server to connect to region database: dedicated server, shared server (multi-threaded server), or whatever the database has been configured to use.
If MTS is configured, you can select Dedicated Server to force the listener to spawn a dedicated server to bypass MTS configuration.
If MTS is configured in the initialization file and you want to guarantee this connection always uses MTS, select Shared Server.
Use Oracle8i Release 8.0 Compatible Identification
Click this option if the database pre-release 8.1 database service. You have to enter a SID for the database in the SID field.
Clear this option if you are configuring for a release 8.1 database service. You must enter a service name in the Service Name field.
Advanced button
Click to configure advanced CONNECT_DATA parameters.

Additional Informaton

User
Enter a valid DBA user name for the database.
Password
Enter the password for the user name.
Optional button
Click to specify refresh settings for the region database.
  • Refresh from Database: Enter a time value of how often to refresh the region database with information.
  • Retry Interval: Enter a time value for the amount of time to wait for a response.
  • Retry Expiration: Enter a time value to the amount of time to wait before terminating the retry attempt.