Q

Error when trying to connect through SQL*Plus or Oracle Net Manager

I installed Oracle client on a Win2K computer. I want to connect to Oracle Database in another computer. I get this error when I connect using SQL*Plus: "ORA-12535: TNS:operation timed out." I tried to use Oracle Net Manager to connect to the database server, but I also got this error.

I installed Oracle client on a Win2K computer. I want to connect to Oracle Database in another computer. I get this error when I connect using SQL*Plus: "ORA-12535: TNS:operation timed out." Here is my tnsnames.ora (on the client machine):
ORCL.TANDUC.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = yentt)(PORT = 1521))
    )
    (CONNECT_DATA =
       (SERVER = DEDICATED)
 (SERVICE_NAME = orcl)
    )
  )
and sqlnet.ora (on client machine):
NAMES.DEFAULT_DOMAIN = tanduc.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
I tried to use Oracle Net Manager to connect to the database server, but I also got this error. Please help me to figure out the problem as soon as possible. I am stuck now!

Are you able to connect to this Oracle database from any other client workstation? If so, what release of the client

software has been installed on the other machine? Are you certain that the username/password you are supplying is valid? I tend to think that this is not the problem otherwise you would be getting a different error back from the database server.

Confirm that the listener is running on the database server. If the listener is running, replace the host name in your tnsnames.ora file with the IP address of the database server and attempt the connection again.

One more possibility is that the value specified for CONNECT_TIMEOUT_<listener_name> in the listener.ora is incorrect.

Finally, it is possible that a firewall is preventing you from connecting to the database server.

This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close