jpchausseau
Member²
I have an application using DOA which works fine on a LAN. However, I cannot connect to the database through a 'plain' internet connection as detailed below:
For development purposes, Oracle 8i is installed on a W2K workstation with IP adress 192.168.0.14. This workstation also runs Apache. No firewall on this workstation.
The LAN connects to internet through a router (nexLand) and a ADSL modem with a fixed IP adress. The router is configured to allow access to port 1521 (Oracle's listener) and port 80 (Apache) on workstation 192.168.0.14.
1- Now, if I try to connect to the database through the LAN, with the host name in Net8 defined as 192.168.0.14 (and port number 1521), everything works fine from another ('calling') workstation.
2- If I disconnect the 'calling' workstation from the LAN, and connect it to the internet through a modem and a phone line, I am unable to connect to the host name defined as above, but with the IP adress changed to the fixed ADSL modem adress ('ADSL_IP_adress'). However, I can connect to the Apache server on the workstation running the Oracle server, which should eliminate the router as the source of the problem.
3- If I connect the 'calling' workstation both to the LAN and to the internet with the modem and phone line, I can connect to Oracle by using either 192.168.0.14 or 'ADSL_IP_adress'.
Could this be a security problem on the workstation running Oracle? Any idea to help? Many thanks in advance,
Jean-Paul Chausseau
For development purposes, Oracle 8i is installed on a W2K workstation with IP adress 192.168.0.14. This workstation also runs Apache. No firewall on this workstation.
The LAN connects to internet through a router (nexLand) and a ADSL modem with a fixed IP adress. The router is configured to allow access to port 1521 (Oracle's listener) and port 80 (Apache) on workstation 192.168.0.14.
1- Now, if I try to connect to the database through the LAN, with the host name in Net8 defined as 192.168.0.14 (and port number 1521), everything works fine from another ('calling') workstation.
2- If I disconnect the 'calling' workstation from the LAN, and connect it to the internet through a modem and a phone line, I am unable to connect to the host name defined as above, but with the IP adress changed to the fixed ADSL modem adress ('ADSL_IP_adress'). However, I can connect to the Apache server on the workstation running the Oracle server, which should eliminate the router as the source of the problem.
3- If I connect the 'calling' workstation both to the LAN and to the internet with the modem and phone line, I can connect to Oracle by using either 192.168.0.14 or 'ADSL_IP_adress'.
Could this be a security problem on the workstation running Oracle? Any idea to help? Many thanks in advance,
Jean-Paul Chausseau
