I am facing a problem today with our Production Database.
User with our branches using VPN connection cannot connect to our Oracle Database.
As per checking the alert log, I saw this message
Fatal NI connect error 12170.
TNS for Linux: Version 18.104.22.168.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 22.214.171.124.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 126.96.36.199.0 - Production
Time: 13-AUG-2013 13:08:42
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.131)(PORT=1137))
We are using Oracle 11gR2 Database running OEL 6
Kindly help us to solve this.
My firewall is disable in my db host.
I also check the firewall on client end and it is also disabled.
I also talk to my Network Administrator for adjustment in Router and Firewall to allow port 1521 to accept connection but still unsuccessful.
What seems to be the problem ?