Tip of the week: After server reboot, unable to start application services due to ORA-12203: TNS: Unable to Connect to Destination.
Resolution: As there are several fixes to this issue, one unique place to look for is the iptables/firewall in Redhat server. Even though EBS applications worked fine until the reboot, we looked at the iptables that was disabled using 'service iptables stop' but was never turned off in rc. Nonetheless, this forced the iptables to be enabled during startup and blocked the tns port.
running 'service iptables off' helped to fix the issue.
Also, you can confirm if this is the case by simply running telnet dbserver port number . If it doesn't connect, about fix is valid.
Resolution: As there are several fixes to this issue, one unique place to look for is the iptables/firewall in Redhat server. Even though EBS applications worked fine until the reboot, we looked at the iptables that was disabled using 'service iptables stop' but was never turned off in rc. Nonetheless, this forced the iptables to be enabled during startup and blocked the tns port.
running 'service iptables off' helped to fix the issue.
Also, you can confirm if this is the case by simply running telnet dbserver port number . If it doesn't connect, about fix is valid.
No comments:
Post a Comment