Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I configure my Oracle tnsnames file location? [closed]

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

like image 510
AndrewL Avatar asked Jan 20 '23 01:01

AndrewL


1 Answers

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

like image 147
Chandu Avatar answered Jan 22 '23 14:01

Chandu