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

Filed under:

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

Related posts about oracle10g