Oracle Database - Naming method (naming resolution method)

Card Puncher Data Processing


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 support:

  • localized configuration on each client,
  • or centralized configuration that can be accessed by all clients in the network.

Oracle Net provides four naming methods:

Naming Method Repository Type
local naming local with the tnsnames.ora file
directory naming central with an ldap
Easy Connect naming does not require a repository
external naming

Choosing a Naming Method

Selecting the appropriate naming method for mapping names to connect descriptors depends upon the size of the organization.

  • For a small organization with only a few databases, use Easy Connect naming to make TCP/IP connections with the host name of the database server or local naming to store names in tnsnames.ora file on the clients.
  • For large organizations with several databases, use directory naming to store names in a centralized directory server.
  • For an Internet network, configure the application Web servers needed to connect to the databases with the local naming method.

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database - Connect Descriptor (TNS Connect String)

The Connect Descriptor (known also as TNS Connect String) is a type of connect identifier. It defines the parameters that need the Oracle Net Service to connect to a database service : the protocol...
Card Puncher Data Processing
Oracle Database - Connect String (Client Connection Initiation)

Users initiate a connection request to a database service by providing a connect string. A connect string includes: a username and password, along with a connect identifier. A connect identifier...
Oracle Database Net Ldap
Oracle Database - Directory naming method (LDAP-compliant)

A naming method that resolves a database service, net service name, or net service alias to a connect descriptor stored in a central directory server. The directory naming method stores connect identifiers...
Card Puncher Data Processing
Oracle Database - Easy Connect Method with host, port and service name (EZCONNECT)

The easy connect method is one of the naming method to get all the data needed to identified the location of the database. The easy connect naming method eliminates the need for service name lookup in...
Card Puncher Data Processing
Oracle Database - External naming method

A naming method that uses a third-party naming service, such as NIS.
Card Puncher Data Processing
Oracle Database - Local Naming Method

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...
Card Puncher Data Processing
Oracle Database - Oracle Net Configuration Assistant

Oracle Net Configuration Assistant is provided primarily to configure basic network components during installation, including: Listener names and protocol addresses Naming methods the client will...
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...

Share this page:
Follow us:
Task Runner