When trying to connect to a database in SQL Optimizer I am receiving an "ORA-12154: TNS:could not resolve service name" error.
WORKAROUND #1:
1) Right click on your My Computer icon and select properties.
2) In the Advanced tab click the Environment Variable button.
3) In the bottom portion of the window (System variables) click New.
4) For the variable name type: TNS_Admin
5) For the Variable value put the path to the folder that contains your tnsnames.ora file.
6) Hit OK on all the windows that were opened.
7) Try to connect in SQL Optimizer.
WORKAROUND #2:
If you are on Vista, make sure that the UAC option is disabled. To disable the UAC option, please follow the instructions in the following link: http://www.petri.co.il/disable_uac_in_windows_vista.htm
WORKAROUND #3:
If Optimizer is installed on a 64bit box and is using a 10g or below Oracle client then Optimizer will need to be uninstalled and reinstalled in a folder outside the Program Files(x86) folder e.g. C:\Quest Software. This is an Oracle bug.
