Manage Data: Net Service Names

The Net Service Names tab enables you to query, add, remove or load net service names into an Oracle Names server. You can add or remove one net service name reference at a time. Net service names represent services stored in the Oracle Names server.

Action

Query
Click to query for the net service name specified in the Service Name field.
Add
Click to create a new net service name.
Remove
Click to remove a selected net service name and its address from the Addresses list box.
Load
Click to import net service names from an existing tnsnames.ora file into an Oracle Names server. Imported net service names display in the Addresses list box.
Execute button
Click to perform the net service name query, add, remove, or load operation.

Service Name

Enter the net service name you are planning to query, add or remove.

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 to 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 to connect to a release 8.1 database service.
SID

Enter an Oracle System Identifier (SID) to connect to a pre-release 8.1 database.
Connect Type
From the list, specify how you want to connect to a database service: dedicated server, shared server (multi-threaded server (MTS), 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 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.

Load Service Names from tnsnames.ora File

Enter the location of the tnsnames.ora file, or use the Browse button to find the tnsnames.ora file.