5

I am trying to save the tnsnames.ora file, but couldn't. It showed access denied. Any one have any idea regarding this? Currently I am using Oracle 11g on Windows 7

2
  • 2
    don't you get a UAC prompt?
    – Sathyajith Bhat
    Mar 12, 2012 at 9:01
  • 1
    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. May 7, 2015 at 13:13

3 Answers 3

5

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.

3

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).

1

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.

You must log in to answer this question.

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