Re: Can't connect over VPN

Hi,

in-line

bdbafh_at_gmail.com wrote:
> NAT (network address translation) can make this quite tricky.
> I think that I've explained this dozens of times.
> basically, the redirect from the listener to the client gives the
> client an IP_address:port that the client cannot get to (route-wise).
> a timeout results.
>
> either connection manager (CMAN) or the use of shared
> servers/dispatcher can make this work.
>

1. According to this link: http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family_0104.pdf

CMAN is _not_ available for Standard Edition (SE). Shared servers for SE, just to get VPN working, is also unfortunate. Jonathan's web site is helpful is you have CMAN and an EE database.

2) I might also recommend a level 16 SQL*Net trace at the client if problems persist, so you can see exactly what the client is doing. We've found some interesting /issues/ with instance handoff between RAC listeners. The client trace shows the connection string passed to the client and the /issues/ causing the connection to fail. In one case, we saw a host without domain which required a fix.

HTH. Good luck.

Regards,

Mike Thomas Received on Sun Mar 13 2005 - 13:37:46 CST