Oracle Error ORA-12560 TNS:Protocol Adapter error?
Posted
by
David Basarab
on Server Fault
See other posts from Server Fault
or by David Basarab
Published on 2009-09-22T17:31:06Z
Indexed on
2011/01/14
20:55 UTC
Read the original article
Hit count: 280
oracle10g
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?
© Server Fault or respective owner