Sample Header Ad - 728x90

Not possible to connect to remote Oracle XE with public IP

0 votes
0 answers
74 views
I have a problem with my database, I cannot access to it via public IP (remote). I have developed a java stocks program, which uses JDBC to connect to DB. My database is Oracle Database Express Edition (XE), mounted in Windows 10 to serve a stocks control program. The program works perfect while running on the same PC (localhost), but recently I wanted to access to it via remote connection. The steps I followed are these: 1. Tell my ISP company to fix me an static public IP. 2. Configure a forwarding port in my router. 3. Create an SSH tunnel on server to route the traffic from forwarded port to database port (1521). Comprobations I have done: -Reaching the opened port via external access: **OK** -Testing the SSH tunnel on server to be working. IP and port put on a browser, and the command line where the tunnel is debugging shows connection attempts. **OK** -Testing SQLplus to connect to the remote server with public IP. **ERROR (BUT DEBUG CONSOLE ON SSH TUNNEL SHOWS A CONNECTION ATTEMPT)**. ORA-12537: TNS: closed connection. -Testing JDBC to connect from my application to the remote server with public IP. **ERROR**. Network adapter cannot establish the connection. (NO CONNECTION ATTEMPT). I also have configured a DDNS in the router with noIP, but the behavior is the same. Anyone has an idea about this? I have tried several times. **UPDATE:** After downloading Orace Call Interface, SQLplus connects, but my Java application does not show any sign of connection. Error: java.sql.SQLRecoverableException: Error de E/S: The Network Adapter could not establish the connection Error en la conexión de la base de datos
Asked by Fran Casas (1 rep)
Sep 19, 2024, 06:34 AM
Last activity: Sep 22, 2024, 01:59 PM