Quote Originally Posted by PAVB
Just because poster attempted to "run" tnsnames.ora? wasn't that cute?

hehehehe.... dude, to set your ORACLE_HOME and ORACLE_SID on windows:

c:\> set ORACLE_SID=
c:\> set ORACLE_HOME=

... to check the environment ...

c:\> set ora


... remember these settings will be lost when you close your command prompt window....


to set it permanently, set it in the advanced properties on "My Computer"