In this module, you have learned how to install, configure, and test a Oracle Net Services client.
You should now have a working knowledge of all the components of Oracle Net Services on both the client and the server, including the ability
- Describe the PC file-system architecture for Oracle Net Services
- Use Oracle Net Services Assistant to manage tnsnames.ora
- Run the Oracle installer for Oracle Net Services clients to install and configure Oracle Net Services
- Use the Oracle Net Services Assistant to add a remote database to the tnsnames.ora file
- Manage a master copy of tnsnames.ora in a large network
- Test your Oracle Net Services connectivity to remote databases
Configuring tnsnames.ora File After Installation
You can add network service names to the tnsnames.ora file at any time after installation.
To configure the local naming method, perform the following tasks:
Task 1: Configure Net Services Names
To configure the network services names, use one of the following methods:
Each method provides similar functionality. However, Oracle Net Manager has more configuration options for the sqlnet.ora file.
Net Services Names Configuration using Oracle Enterprise Manager Cloud Control
The following procedure describes how to configure network service names in the
file with Oracle Enterprise Manager Cloud Control:
- Access the Net Services Administration page in Oracle Enterprise Manager Cloud Control.
- Select Local Naming from the Administer list, and then select the Oracle home that contains the location of the configuration files.
- The Local Naming page appears. You may be prompted to log in to the database server.
- Click Create Like. The Create Net Service Name page appears.
- Enter a name in the Net Service Name field.
You can qualify the network service name with the client's domain. The network service name is automatically domain qualified if the sqlnet.ora file
parameter NAMES.DEFAULT_DOMAIN is set.
- In the Database Information section, configure service support as follows:
- Enter a destination service name.
- Select a database connection type.
The default setting of Database Default is recommended for the connection type. If dedicated server is configured in the initialization
parameter file, then you can select Dedicated Server to force the listener to spawn a dedicated server, bypassing shared server configuration.
If shared server is configured in the initialization parameter file and you want to guarantee the connection always uses shared server, then select
- In the Addresses section, configure protocol support, as follows:
- Click Add. The Add Address page appears.
- From the Protocol list, select the protocol on which the listener is configured to listen. This protocol must also be installed on the client.
- Enter the appropriate parameter information for the selected protocol in the fields provided.
- (Optional) In the Advanced Parameters section, specify the I/O buffer space limit for send and receive operations of sessions in the Total Send
Buffer Size and Total Receive Buffer Size fields.
- Click OK.
The protocol address is added to the Addresses section.
- Click OK to add the network service name. The network service name is added to the Local Naming page.
- Select connect-time failover and client load balancing option for the addresses.
- Click OK.
The next module concludes this course.