Re: Can the listener forward connect request to another server

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Wed, 14 May 2003 12:04:58 -0400
Message-ID: <dRtwa.6902$945.20516@tor-nn1.netcom.ca>

You can have your TNSNAMES.ORA configured so that it calls for an IP alias address.
That's what I have.
I can move the database around if the server needs servicing, or whatever.

You setup the IP alias on your server's IP stack. I have no idea how you do it on other OSes than OpenVMS. Or even if it can be done.

In order for this to work you need a listener running on all machines known by this alias name. Usually only one machine is configured to answer requests so all you have to do, to move the db on the other node, is:

a) setup an alias for machines A and B and make A the "main" one
a) stop the db on node A
b) set the node the will pick up requests sent to the alias and make that

node B (B becomes "main")
b) start the db on node B

and your users can log in again.

HTH

--

OpenVMS 7.2-1, Oracle 8.1.7.4

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove zulu from my address

"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 Wed May 14 2003 - 11:04:58 CDT