Subject: Odp: plug-gw for SQL*Net (oracle)

From: "Mariusz Potocki" <[email-masked]>
Date: Mon, 10 Jan 2000 09:28:44 +0100

[To be removed from this list send the message "unsubscribe fwtk-users" in the
BODY of a mail message to [email-masked].]

>Dear fwtk users,
>
>i wonder if anyone has put some effort in extending
>plug-gw for sqlnet so that it can switch to different
>servers (hosts with listeners) depending on the
>SID of the destination database.
>
>Currently we are using one firewall to connect to
>databases on one server (with one listener the clients
>connect).
>
>In a fail-over environment it would be very useful to
>switch database services to differnet backup machines,
>which could be many.
>
>Is there anyone who did it?
IMHO it's wrong approach to the problem.
Instead of hacking plug-gw to solve specific problem with Oracle, you should
refine your Oracle configuration.
In case of database failure you can change on-the-fly your tnsnames.ora or
names service to point listener to backup database. Dumb plug-gw and most
dumb users won't see any change in database.