Oracle Database - Local Naming Method

Card Puncher Data Processing

About

The local naming method stores net service names and their connect descriptors in a localized (on each individual client's) configuration file named tnsnames.ora to locate network addresses.

Local naming is most appropriate for simple distributed networks with a small number of services that change infrequently.

Configuring the Local Naming Method

How to ?

The local naming method adds net service names to the tnsnames.ora file. Each net service name maps to a connect descriptor. The following example shows a net service name mapped to a connect descriptor:

sales=
(DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
  (CONNECT_DATA= 
     (SERVICE_NAME=sales.us.acme.com)))

To configure with the local naming method, use one of the following tools:

Verify the Listener configuration

Ensure that the listener (located on the server) is configured to “listen on” the same protocol address you configured for the net service name. By default, the listener should already be configured for the TCP/IP protocol on port 1521.

Distribute the Configuration

After one client is configured, it is best to simply copy the tnsnames.ora and sqlnet.ora configuration files to the same location on the other clients. This ensures that the files are consistent.





Discover More
Card Puncher Data Processing
Oracle Database - Naming method (naming resolution method)

The Oracle Net Services naming method is resolution method used by a client application to resolve a connect identifier to a connect descriptor when attempting to connect to a database service. They...
Oracle Database Net Manager
Oracle Database - Oracle Net Manager

Oracle Net Manager enables you to configure Oracle Net Services for an Oracle home on a local client or server host. You can use Oracle Net Manager to configure the following network components: ...
Card Puncher Data Processing
Oracle Database - SQLNET.ORA

Located on client and database server computers, this file may include: Client domain to append to unqualified service names or net service names Order of naming methods the client should use when...
Card Puncher Data Processing
Oracle Database - tnsnames.ora

Located primarily on the clients, this file contains net service names mapped to connect descriptors and is a part of the local naming method in order to make a database connection. TNS_ADMINORACLE_HOME...



Share this page:
Follow us:
Task Runner