Q
Problem solve Get help with specific problems with your technologies, process and projects.

"Operation timed out" error when connecting from client

When I connect through SQL from Oracle Client to Oracle9i Server installed on Windows 2003 Server, I am getting the error "ORA-12535 TNS: Operation timed out." It seems whenever the client tries to connect to the server, the system is assigining a dynamic (new) port number and not 1521.

When I connect through SQL from Oracle Client to Oracle9i Server installed on Windows 2003 Server, I am getting the error "ORA-12535 TNS: Operation timed out." If I remove the firewall on Windows, I can connect. I also have open port 1521 on the server, but still I am getting the same error. It seems whenever the client tries to connect to the server, the system is assigining a dynamic (new) port number and not 1521. Can you please help me out? Due to security and virus problems I can't stop the firewall.
On the Windows platform, you must ensure that the port being listened on is open (in this case, that is 1521), as well as setting up a SQL*Net/Net8 Proxy such as Connection Manager if no proxy is provided by the firewall vendor. The reason for this is even though the port is open the TCP layer will redirect the port to another port.

For more information on Oracle's Connection Manager, review the Oracle9i Net Services Administrator's Guide.

Dig Deeper on Oracle database installation, upgrades and patches

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close