Oracle Database - TNS_ADMIN environement variable

Card Puncher Data Processing


TNS_ADMIN is a environment variable value which give the directory where the file tnsnames.ora must be searched.

It's really helpful when you have more than one Oracle Client Product installed. It takes precedence on the windows PATH environment variable.

Example :


Discover More
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...
Card Puncher Data Processing
Oracle Database - Configuration of the Listener (listener.ora)

A listener is configured with one or more listening protocol addresses, information supported services, and parameters that control its run-time behavior. The listener configuration is stored in the configuration...
Oracle Registry Windows
Oracle Database - Environment Variables / Registry Values

To configure the database installation, Oracle provide several Environment variable / Registry Value. : oracle_sid is used for a local connection - direct to the server - without using a listener...
Oracle Database 11gr2 Typical Installation
Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)

Installation of Oracle Database 11g Release 2 (11.2) on Oracle Enterprise Linux 5. Linux OEL installation login as root RAM: At least 1 GB swap space The following table describes...
Card Puncher Data Processing
Oracle Database - ODBC Driver Insallation on Linux

where is the data manager home () and ~/.odbc.ini === Drivers === Example odbcinst.ini === DSN === odbc.ini Minimal parameters Complete: ==== Test it ==== with ===== Support...
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 - cman.ora configuration file

Located on the computer where Oracle Connection Manager runs, this configuration file includes the following components: A listening endpoint Access control rule list Parameter list Each Oracle...
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...
Oracle Database Installationl Location 11gr2 Oel Linux X86 64
Oracle Database 11gR2 - Installation on Linux OEL 5 Update 5 (x86_64)

Installation of Oracle Database 11g Release 2 (11.2) x86_64 on Oracle Enterprise Linux 5 Update 5 on the file system (ie without ASM) or GRID. Linux OEL installation login as root ...
Sql Developer Encoding
SQL Developer - (Installation|Configuration)

(Installation|Configuration) backup metadata such as connection, report, ... The best way is to search in the documentation of SQL Developer the section “Location of User-Related Information”...

Share this page:
Follow us:
Task Runner