Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Have you checked that the machines actually can find each other? That is, is "databaseServer" in a DNS or the machines hosts-file and that the lookup to it is correct.

share|improve this answer

check that there isn't a firewall between the 2 servers, and you can run tnsping from your client to see if it can see the server at all.

share|improve this answer
    
I tried and I get a TNSTNS-03505 error. –  David Basarab Sep 22 '09 at 17:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.