To get access to the remote oracle database, there has to be an open tunnel towards an allowed server that has access to the restricted ones (remote oracle database), giving the impression that the workstation is allowed to database directly.
DIAGRAM ::
Workstation --> allowed server (IP) --> remote Database.
We can make such connection via putty in below steps ::
1.We can add the allowed server IP (in session category) in the hostname and selecting protocol SSH.
2.IN SSH category, select TUNNELS and then adding new forwarded port info.
a) Sourceport : Lxxxx
b) db_name:1521
Now, im trying to connect to remote database via netbeans. I have put the info such as :
Drivername: Oracle Thin (service ID)
Host:db_name
Port:1521
SID:DB2
username:xxxx
password:yyyy
But when i try to connect, it throws an Error on netbeans such as ::
Unable to add connection. The network adapter couldn't establish the connection.
Could plese advise the to solve this problem ? Should we insert tunnel info to be stored in netbeans somewhere ?