connection timed out error with oracle on RHEL5.0 and app on window-xp

kapilbajpai88 · 07-17-2008, 06:14 AM

installed oracle 10g on RHEL5.0 and application program on windows-xp. getting error:connection timed out ,when trying to access oracle from windows machine...
pls suggest smthing as both ping and cygwin shows same error....

TB0ne · 07-17-2008, 08:35 AM

Quote:

Originally Posted by kapilbajpai88

installed oracle 10g on RHEL5.0 and application program on windows-xp. getting error:connection timed out ,when trying to access oracle from windows machine...
pls suggest smthing as both ping and cygwin shows same error....

Make sure your database is up and running? Make sure it's listening on the port your application is looking for? Make sure there's not a firewall between the two, blocking that port? Perform some basic functionality testing on your database?

kapilbajpai88 · 07-18-2008, 02:36 AM

even after restarting database, the problem is there. listner is showing that database is up and proper.
how can i check firewall settings on linux machine?? it might be due to that also, but it was working fine till monday 14th july.
do suggest what else should i try??

kapil.

TB0ne · 07-18-2008, 09:00 AM

Quote:

Originally Posted by kapilbajpai88

even after restarting database, the problem is there. listner is showing that database is up and proper.
how can i check firewall settings on linux machine?? it might be due to that also, but it was working fine till monday 14th july.
do suggest what else should i try??

kapil.

You don't say what kind of firewall you might have, or if you're in an environment where you might have a hardware-based firewall, or if this is even on the same network. Hard to give you any advice without knowing. You can do an "iptables -L" (as root), to see if you've got any iptables rules running. Since you're using RHEL, you can contact RedHat support, and they can help you with any firewall questions you might have.

What happened on or before Monday? Something apparently changed....what were you doing?

kapilbajpai88 · 07-18-2008, 11:34 AM

i thought it was firewall problem, but actually it was related with port blockage.
i tried adding port and refreshing port settings and it worked. it might be hit-and-trial as well, but the problem is resolved.

anyways, thank you for your concern.
bye.