What is a TNS entry in Oracle?

A TNS (Transparent Network Substrate) name is the name of the entry in tnsnames.ora file which is kept in $ORACLE_HOME/network/admin. This file contains the information which is used by the system to connect to oracle database. Using this a client can fetch server associated information transparently.

What is TNS name in Oracle Database?

What is a TNS? It is an alias. Like a hostname is an alias for an IP address, a TNS is an alias for an OCI (Oracle Call Interface) connection string. This string identifies the database server and database instance to connect to.

How do I create a TNS service name?

Procedure

  1. Enter dbca at the Oracle command-line to start the Oracle Net Configuration Assistant tool.
  2. On the Welcome window, select Local Net Service Name configuration.
  3. Select Add.
  4. Enter WAREHOUS in the Service Name field.
  5. Select TCP as the network protocol to communicate with the Tivoli Data Warehouse database.

Where Tnsnames Ora is located?

ORACLE_HOME\network\admin directory
tnsnames. ora is located in the ORACLE_HOME\network\admin directory on Windows.

How do I find my TNS details?

Do the following:

  1. Log on to the host where the Oracle database resides.
  2. Change to the following directory: Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
  3. To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
  4. Repeat step 3 to verify that the TNS listener is running.

Is Oracle 10g Express Edition free?

Oracle Database 10g Express Edition (Oracle Database XE) is a free, downloadable version of the world’s most capable relational database.

What is Oracle XE used for?

Oracle Database XE is easy to install, easy to manage, and easy to develop with. With Oracle Database XE, you use an intuitive, browser-based interface to administer the database, create tables, views, and other database objects, import, export, and view table data, run queries and SQL scripts, and generate report.

How do I manually create Tnsnames Ora?

Procedure

  1. FTP the following file from your Oracle server:
  2. Add the following lines:
  3. Replace the string yourhost in the line (HOST = yourhost ) with the name of your Oracle server.
  4. (optional) Replace the default port number 1521 in the line (PORT = 1521 ) with your required port number.
  5. Write and quit the file.