Oracle Database - Net Service Name (tnsname)

Card Puncher Data Processing


A simple name for a service that resolves to a connect descriptor.

Users initiate a connect request by passing a user name and password, along with a net service name in a connect string, for the service to which they want to connect:

CONNECT username@net_service_name

For instance with SqlPlus - SqlPlus Command :

sqlplus user/password@net_service_name

You can connect in an other way with the easy connect method

Depending on your needs, net service names can be stored in a variety of places, including:

  • Local configuration file, tnsnames.ora, on each client
  • Directory server
  • External naming service, such as NIS

It is used to define the database service where you want to make a connection.


Example :

net_service_name = 
) (SID = orcl)))

Discover More
Obia Powercenter Topology
OBIA - Installation Version 7.9.6 with EBS, PowerCenter, Oracle Database on Windows

Roadmap To install and set up Oracle BI Applications, do the following: preinstallation steps for the source...
Obiee Connection Pool
OBIEE 10G/11G - Oracle Call Interface (OCI) configuration

This page shows you how to install an OCI driver with OBIEE. To use it you have to install it on the BI Server machine through an Oracle Client installation (for instance an Oracle Database, an...
Owb Hs Module Definition Complete
OWB - Creating an ODBC Non-Oracle Module as data source (with Excel)

Oracle Warehouse Builder use the gateway capabilities of the oracle database to create Non-Oracle Module. This article will create an ODBC Non-Oracle Module on Excel data source. To set up the ODBC...
Owb Access Publicview Browser
OWB - Repository Browser

Repository Browser is a J2EE web software interface that permit you to: browse the data dictionary (Public View) execute some basic administrative tasks To be able to connect to the Web repository...
Card Puncher Data Processing
Oracle Database - Connect Identifier

A connect idenfier is the part of the connect string when a users initiate a connection to designate the service to which they want to connect to. The connect identifier is : a connect descriptor....
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...
Card Puncher Data Processing
Oracle Database - Database Link

A database link describes how one database instance can log in to another database instance. A schema object in one database that enables users to access objects on a different database. ...
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...
Hs Odbc Excel Define Name
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you can access data from oracle database via an odbc connection direct by using the gateway odbc agent (or program) generic connectivity. In this example, an odbc connection...

Share this page:
Follow us:
Task Runner