Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access the TNS_ADMIN value in Oracle through Command Prompt

944059Jul 6 2012 — edited Jul 7 2012
I am trying to get the TNS_ADMIN value but I m an not getting Expected Results . My tnsNames.Ora are located at the following locations : -
1) C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
2) C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN

As you can see from the belowcode, TNS_ADMIN is not displaying the correct location. Please correct me where I am going wrong.
C:\>set TNS_ADMIN=%ORACLE_HOME%\network\admin

C:\>echo %TNS_ADMIN%
%ORACLE_HOME%\network\admin

C:\>echo %ORACLE_SID%
%ORACLE_SID%

C:\>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2012
Added on Jul 6 2012
4 comments
3,891 views