This content has been marked as final. Show 9 replies
Over VPN, then you must check with firewall team with ports specific to Oracle database listening across.
Further you can refer to Billy comments on below discussion
Connect to Oracle server over a vpn tunnel
- Pavan Kumar N
It seems like a routing problem.
I think that, when you established the vpn to your client (D1) , you loss conectivity with D2 database.
Check the conectivity (just by ping) and tell me if this is true
From To result
PC -> D1 OK
D1 -> D2 OK
PC -> D2 Fail
Is something usual with vpn. You must talk with your networking department :-(
I suspect your DB Link may not recognize your DB TNS information. I suggest using the following format when creating your DB Link.
CREATE DATABASE LINK D2 CONNECT TO <USERNAME_on_D2> IDENTIFIED BY <Password_on_D2> USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST_IP>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=D2)))';
This way, it will bypass the TNSNAMES.ORA file and have all the information required to map down your remote DB.
AnkitV wrote:my car is not working
I have created it in this manner only on both D1 and my PC, but at D1 its OK, but not working on my PC.
tell me how to make my car go
while "not working" is likely 100% factual it is also 100% devoid of any actionable details.
is COPY & PASTE broken for you?
AnkitV wrote:ping uses a different port and different protocol than does a database connection.
I am able to successfully ping the servers of D1 and D2 from my PC.
Also, tnsping gives positive response with service names D1 and D2 from my PC.The service names are meaningless. tnsping only confirms you reached a listener on the designated port. That does NOT mean you will be able to connect to a database, only that the path to the listener is open.
see: [url http://edstevensdba.wordpress.com/2011/02/27/tnsping-101/] tnsping-101