I am not able to establish connection with Oracle 10g while doing JDBC test am getting below error, can you please help to get it fixed.
Testing failed:invalid connection properties setting.
[l7tech]Oracle JDBC Driver] Error establishing socket to host and port:192.168.0.5:1521. Reason:No route to host
My connection details are like below:
Driver Class: com.l7tech.jdbc.oracle.OracleDriver
JDBC URL : jdbc:l7tech:oracle://192.168.0.5:1521;ServiceName=XE
1)Oracle server is running on windows machine.
2)Am not able to ping my windows machine(where Oracle is running) from my gateway appliance, but I can able to ping from my windows machine to gateway appliance. So what network settings might be wrong here?
We are using NAT network adapter for gateway appliance.
Thanks in advance....
You can ping from Windows to the gateway but u cant ping from Gateway to Windows Machine. That only means that gateway is open which is replying to your ping request but as Windows is not able to reply the gateway ping request, there is something blocking the gateway request in the Windows.
Please first check that if any firewall is blocking your ping request in the Windows Machine. Ping using only the IP. If you need to ping using the hostname then do Map the IP to the hostname in the Windows Machine by going into the c: /Windows/system32/drivers/etc/hosts.
While Connecting to the user which is 'system' in your case. You need to run a grant all permission script for the user 'SYSTEM' with the machine IP you're accessing the DATABASE.
Please check the JDBC URL ur entering I guess it should be in below format
Please Correct me if I am Wrong.
Make sure your DNS on Gateway is correctly configured. Make sure Firewall is not blocking ping and tcp port 1521 to and from Gateway.
Next is to see if an explicit entry in the hosts file will solve the issue. Log into Gateway linux machine and get to root command line. Next type "Vi /etc/hosts" and add the <IP> <hostname> on a new line and save and exit the file (:wq). (EX: 192.168.1.12 gatewaya.ca.com). Then try to test your JDBC connection again or you could also issue a ping from Gateway to your Windows machine.
If still having an issue then you may need to add some Static IP Routes to the routing table in standard linux manner or refer to our documenation below: