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
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."