Re: Can the listener forward connect request to another server

Hi from Paris

You can use the TAF feature of the Net8 layer, which allow you to specify severals IP adresses for a given connect string in the 'tnsnames.ora'.

After having deployed the new client configuration, connection will be made on server 1 as long as listener is up and database running. Whenever you want to switch your server, you start the listener and databaseon node 2, then stop listener on node 1. Current session will stay on instance 1, but new sessions will be open on instance 2.

You could even, in case your application can manage it, shutdown instance on node 1 and failover automatically connected sessions on node 2.

RTFM: in the Net8 Administrator guide, look at the "Transparent application Failover" feature, and search on Metalink for 'tnsnames.ora' examples. TAF has been implemented since Oracle 8.0

"rherbst" <rherbst_at_rz.uni-potsdam.de> a écrit dans le message de news:b95ube$ef1$1_at_zeppelin.rz.uni-potsdam.de...
> Hi *,
>
> imagine the following situation:
> I have an Oracle instance foo1 on server bar1.
> Now I want to migrate the DB to server bar2. But I have a large
> amount of clients working with this DB and I am not able to
> correct the tnsnames.ora on all clients within a reasonable
> time.
>
> Can I configure the LISTENER on server bar1 to redirect/forward
> connection requests to the new instance on server bar2? Or have you
> any other suggestions how to solve the problem?
>
> Regards!
> Rainer
>
> P.S. Oracle 8.1.7 on both servers, TCP network
>
Received on Tue May 06 2003 - 18:09:19 CDT