How do I create a Tnsnames Ora entry?

How do I create a Tnsnames Ora entry?

Creating the tnsnames. ora file

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.

How can I set the path of Tnsnames Ora?

Answer

1. On the desktop Right-click on My Computer and select Properties > Advanced tab.
2. Click the Environment Variables button.
3. In the System variables section click the New button.
4. Enter a variable name of TNS_ADMIN then enter a variable value of the path to the TNSNAMES.
5. Click OK.

What is the path for Tnsnames Ora?

By default, the tnsnames. ora file is located in the ORACLE_HOME/network/admin directory.

What to do with your tnsnames.ora file?

Connecting to InfoAccess requires the appropriate entries in your computer’s TNSnames.ora file. This article explains how to add, replace, or edit your TNSnames.ora file to ensure a successful connection to InfoAccess. When the Oracle client is installed for the first time, it does not come with a TNSnames.ora file.

How to edit tnsnames.ora in EPM?

Directions: 1 Begin by clicking on Start > All Programs > Accessories 2 Right-click on Notepad and select Run as administrator 3 In Notepad, click on File > Open. 4 Locate the folder where you installed the Oracle Client ( ORACLE_HOME ). 5 If files named tnsnames.ora or sqlnet.ora already exist in the folder, open them.

What do I need to know about sqlnames.ora file?

The sqlnames.ora file is where the Oracle Client stores various network connection settings which apply to ODBC connections. Like tnsnames.ora, entries in the file follow a rigid format. In order to connect to EPM, users must add lines permitting an encrypted connection.

Where can I find copies of tnsnames and sqlnet entries?

Copies of the tnsnames and sqlnet entries used to connect to the EPM database are included in the initial authorization email EPM users receive. This document describes in detail how to insert those entries into the corresponding files and how to determine whether they were inserted correctly.