Unable to connect database

thiyagarajancs · 11-10-2015, 03:06 AM

Hi,

I have configured in oracle database listener in new server. The configuration is correct and i can able to connect the database within server via listener.

But if i try to connect from outside, It's throwing the below error.

Connecting To 192.168.101.55...Could not open connection to the host, on port 1521: Connect failed.

But there is no port block and i can able access other ports like 22,23 etc., (Telnet <ip> 22).

Please help me fix this issue.

Thanks in advance.

dawyda · 11-10-2015, 03:55 AM

When you say 'from outside' do you mean from a remote network or from your LAN? If it from a remote network then make sure the correct NAT/PAT is set on your gateway/router. Also ensure your iptables allow the incoming connection to the port 1521 on the listener.

berndbausch · 11-10-2015, 04:37 AM

Quote:

Originally Posted by thiyagarajancs

But there is no port block and i can able access other ports like 22,23 etc., (Telnet <ip> 22).

What happens when you do telnet 192.168.101.55 1521?
Are you sure the database listener listens on an external address? Perhaps it's configured to only listen on the loopback address. Find out with netstat -lntp | grep 1521 (or ss instead of netstat).
And double-check the firewall, as dawyda recommends.

thiyagarajancs · 11-11-2015, 05:35 AM

Hi All,

Thanks for your help.

The issue solved by disabling the firewall.

Initially, I have tried the status by "service iptables status". But it gave error and i assumed that iptables are not configured. But later i came to know that the commands are different in linux 7. After i executed the correct command, The issue was solved.

Thanks again..