How can I configure my Oracle tnsnames file location?

oracle oracle10g tnsnames
AndrewL picture AndrewL · Apr 6, 2011 · Viewed 11.6k times · Source

I have Oracle 10g installed on Windows. Currently, my tnsnames file is stored at %ORACLEHOME%\network\admin. However, I want to configure Oracle to look somewhere else for that file.

How can I do this?

Andrew L

Answer

Chandu picture Chandu · Apr 6, 2011

You can use the TNS_ADMIN environment variable to specify a custom location of TNSNAMES.ORA file. Check this wiki: http://www.orafaq.com/wiki/TNS_ADMIN

Related questions

How to find the privileges and roles granted to a user in Oracle?

I am using Linux, Oracle10g. I have created one user called test. and granted create session and select any dictionary permission to the same user. i also granted sysdba and sysoper roles to the same users. Now i want …

Read More
Checking oracle sid and database name

I want to check SID and current database name. I am using following query for checking oracle SID select instance from v$thread; but table or view does not exist error is coming. I am using following query for checking …

Read More
CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More