Can you connect this way?Yes i am able to connect the database by the above way.
What is the out put of lsnrctl at your database hostLSNRCTL> status
yoonus wrote:problem does NOT involve hostname resolution or anything out on the network.
If your tnsparameter 'host' uses <hostname> not ip, can you ping to the host with hostname?
Can you change to ip and try if you are using hostname
Note: Please make sure TNS_ADMIN is pointing to the correct directory path where you have copied your tnsnames.ora
cmd set TNS_ADMIN=C:\oracle echo %TNS_ADMIN% sqlplus CONN scott/tiger@TESTDB
933663 wrote:look at the path above
I have removed the constants of C:\oracle to E:\app\username\product\11.2.0\dbhome_1\NETWORK\ADMIN
moved Tnsnsames.ora,Listener.ora,sqlnet.ora folder
and restarted the system and modified the environmental variable to access the path E:\app\username\product\11.2.0\dbhome_1\NETWORK\ADMIN
H:\>echo %TNS_ADMIN%and now look at the path above