We help IT Professionals succeed at work.

Change tnsnames.ora to tnsnames1.ora1

Medium Priority
694 Views
Last Modified: 2013-12-19
I have copied my tnsnames.ora file to tnsnames1.ora file

is there any way that we can divert the setting of oracle to point to the file  tnsnames1.ora

from  tnsnames.ora

i have permission issues in editing  tnsnames.ora that is the reason i am doing this.

I am using windows oracle! not linux !
Comment
Watch Question

Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
no,  local naming is only configurable through tnsnames.ora

if you have remote naming like onames or ldap you can point to different servers.
David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
Seems to make sense that if you don't have rights on that file, either you are not supposed to, or that the problem needs to be addressed.  You can move the TNSNAMES and SQLNET type files to any directory, provided the user has the TNS_ADMIN environment variable resolving to that new directory.  Once you resolve your security issue, it would be wise to put a shortcut in that $OH/network/admin folder, resolving to the new location.
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
oh duh!  I was thinking too small and looking at the file itself.  of course,  tns_admin environment variable will let you pick whatever directory you want.

good point about the permissions though too!
David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
Does this address your need?

Author

Commented:
But there is no tns_admin environment variable in my PC!
Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
you can create one

from command line....

it would look something like this normally (if it was present)...
set tns_admin=c:\oracle\network\admin

change it to something like this...
set tns_admin=c:\oracle\network\some_other_directory


or right click on my computer, properties, advanced, environment variables and create one

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
David VanZandtSr Software Engineer
CERTIFIED EXPERT
Commented:
If you want to keep from recreating it  every time a user logs on, then it has to be a user or system variable.  See Microsoft's KB document 310519 for specifics: http://support.microsoft.com/kb/310519.
 
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.