I am using Oracle Database 10g. Both Servers are Windows 2003.
I have an Orcale Database set up on one server.
Here is the TNSNames.ora from the server with the database.
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORCL.VIRTUALHOLD.COM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = databaseServer)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
The Environmental Variables on the Server are
ORACLE_HOME = C:\oracle\product\10.2.0\db_1 ORACLE_SID = orcl
I am trying to connect to it from another box that has Oracle Client installed.
Here is the tnsnames.ora installed on the other client server.
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = databaseServer)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) ORACLE_HOME = C:\oracle\product\10.2.0\client_1 ORACLE_SID = orcl
Locally on the database server I can connect to through sqlplus with no issues.
On the client machine I keep getting the error:
ORA-12560: TNS:protocol adapter error
What am I missing? Does the client TNSNames.ora need to be different?