Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am tring to save the tnsnames.ora fille, but couldn't it showing acess denied. Any one have any idea regarding this? Curently I am using Oracle 11g on Windows 7

share|improve this question
don't you get a UAC prompt? – Sathya Mar 12 '12 at 9:01
What I have done with errors like this. and I sometimes run into it with tnsnames.ora or web.config or similar. save your edits to your desktop and then drag and drop it into the appropriate directory. – Glenn Ferrie May 7 '15 at 13:13

In most case this means that you want to save the file at a location where you need administrator permissions to do so. There are two possible solutions for this:

  1. Store the file somewhere else where you don't need admin permission (like own documents or something like that).

  2. Start the program you use to save the file as Administrator (if you have the permission to do so) and save the file anywhere you want. !Caution! If you save the file this way, you are able to overwrite other files with the same name even if they are critical and you are able to store the file in locations where the normal user can't read it.

share|improve this answer

I had a similar issue with the hosts file, which I was trying to edit using notepad.
You can only edit and save this file as Administrator, so try this:

Go to Start > All Programs > Accessories, right click Notepad and then click Run as Administrator (might prompt for password).
Then do File > Open and navigate to the tnsnames.ora file.

Make the changes then it should allow you to save (CTRL+S).

share|improve this answer

I had similar problem and I found out that the folder where this file was in had a read-only flag (the read-only flag re-appeared every time no matter what I did). Sharing out a folder to network users (and then stopping sharing after that) fixed the issue and I was able to save the file.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .