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