Q

ORA-12535: Operation times out when trying to connect to database

Since we moved a server, the outside PC cannot connect to the database. I can perform a successful ping to the server but my operation times out (ORA-12535) when I try to TNSPing.

We have a PC sitting outside of our firewall hosting a Web application. The PC was communicating with a database that resides inside the firewall. Last weekend, we had to move the server into a new rack so we shut it down, unplugged it, moved it, plugged it back in and powered up. Since that move, the outside PC cannot connect to the database. I can perform a successful ping to the server but my operation times out (ORA-12535) when I try to TNSPing. The server is running Windows 2003 Server and the PC is running XP.

Check the tnsnames.ora file (usually located in $ORACLE_HOME\network\admin) on the workstation residing outside the firewall to see whether the service definition for the database it is attempting to connect to is using an IP address rather than hostname. A physical move (which involved a stop and start) of the server may have caused it to obtain a different IP address than it had previously. If the IP address is used in the tnsnames.ora...

file, be sure that it is the correct one for the database server or change it to use hostname instead.

Finally, check to see that the port the listener is listening on is accessible through the firewall so that the workstation residing outside the firewall can connect. If you are unsure which port the listener is using, check the listener.ora file on the database server usually located in $ORACLE_HOME/network/admin.

This was first published in April 2007
This Content Component encountered an error

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close