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?
I didn't find the right solution from the internet.
Company Profile Video Presentation
« Back to index
We'd like to thank you for visiting our message board. If you haven't been there already, please take the opportunity to explore the rest of the Oracle Band's website. A Table of Contents is included below. We greatly value your feedback, so please come here and post often. We really want to hear from you!
One Last Thing
Oracle Band Bio
News and Information
Our Mailing List
Suggest A Song
Send us your suggestions for new material
MP3 and RealAudio Samples of the band
Information & Links
We'd like to thank you for visiting our message board. If you haven't been there already, please take the opportunity to explore the rest of the Oracle Band's website. A Table of Contents is included below.
We greatly value your feedback, so please come here and post often. We really want to hear from you!