Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

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.

Hope this helps, took me ages to work it out on the hosts file, it may be the same issue.


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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.