Help with ERROR: TNS:could not resolve the connect identifier specified
Hi,
I am running a Windows 2008 64-bit server. I installed the Oracle Client 10.2.0.4. and I have Oracle home path set up in the Path Environment variable. The tnsnames.ora has the correct service name. The Tnsnames.ora is located in the c:\Oracle\product\10.2.0\client_1\network\admin folder. I have added 'authenticated users' to the Oracle home folder and have rebooted the server.
I have successfully set up a linked server to the Oracle database that I am trying to connect to with SQLPlus. TNSPing displays the service name. Telnet shows that the port 1521 is open for the Oracle database server I am trying connect to.
I am running a Windows 2008 64-bit server. I installed the Oracle Client 10.2.0.4. and I have Oracle home path set up in the Path Environment variable. The tnsnames.ora has the correct service name. The Tnsnames.ora is located in the c:\Oracle\product\10.2.0\client_1\network\admin folder. I have added 'authenticated users' to the Oracle home folder and have rebooted the server.
I have successfully set up a linked server to the Oracle database that I am trying to connect to with SQLPlus. TNSPing displays the service name. Telnet shows that the port 1521 is open for the Oracle database server I am trying connect to.
0