Wingate & Oracle: seem no progress

Use this forum to post questions relating to WinGate, feature requests, technical or configuration problems

Moderator: Qbik Staff

Wingate & Oracle: seem no progress

Postby Surfer » Sep 17 04 8:54 pm

Hello!
It's an good old problem, but from version to version it seems no progress in Wingate:

That is a well known problem with Oracle on Windows and Wingate.
When you connect from client to server with a Wingate in the middle, the connection is on port 1521 (if is by default), but the server reply is on a random free port. The issue is that Windows Sockets API redirects the initial call to another port.

The solutions are 5:

1) Buy a proxy software that support the Net8 services and create a rule that accept all connections from net8.
2) Configure the proxy by NAT to pass port connections by bands . Some network security guys may not like it because it is not a very secure option.
3) Use Connection Manager in Oracle, so the TNS CONNECT following the REDIRECT happens at the server side of the proxy.
4) If you are on Oracle 8, you can use a WINSOCK V2 API feature called Shared Sockets . This allows a socket to be shared (or passed) between multiple processes.
5) Enable MTS. When Multi Thread Server is enabled, the replies are always in the same port that demand the query.

All this solutions may working, but they are artificial. And not each of them can take place in some configurations.
Does Qbik making any progress in this direction?
Wingate is a quite good product, but some necessary functions are absent. It's strange because it's important. World have many Oracle installations.
What about it?
WBR, Surfer
Surfer
 
Posts: 51
Joined: Sep 17 04 7:51 pm

Return to WinGate

Who is online

Users browsing this forum: No registered users and 44 guests

cron