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
-
2don't you get a UAC prompt?– Sathyajith Bhat ♦Mar 12, 2012 at 9:01
-
1What 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 FerrieMay 7, 2015 at 13:13
3 Answers
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:
Store the file somewhere else where you don't need admin permission (like own documents or something like that).
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.
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).
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.