RE: redirect client requests

From: William B Ferguson <wbfergus_at_usgs.gov>
Date: Tue, 1 Mar 2005 06:45:15 -0700
Message-ID: <OF294D4E9F.4E5D3881-ON07256FB7.004B4FB0@usgs.gov>

Can you get another network card installed in the new server and assign = it
the old server's address?

Or in your old server, modify the listener.ora file for database = requests
to be redirected to the new server? This would still mean the network traffic would have an extra hop, back and forth though.

---

Bill Ferguson
U.S. Geological Survey - Minerals Information Team PO Box 25046, MS-750
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208

~ Managers take credit for the work of their group.

Leaders give credit to their group ~

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of jkstill_at_gmail.com
Sent: Monday, February 28, 2005 6:46 PM
To: bobmetelsky_at_comcast.net
Cc: oracle-l_at_freelists.org
Subject: Re: redirect client requests

Bob,

If you are moving all the databases to a new server simultaneously, you could rename the old server, set up a DNS Cname that points the old = server
name to the new server, then get rid of the Cname when you are sure it = is
safe to do so.

Don't know where you would mine for the DNS hits to the server name, but someone here is sure to know.

Or have a better idea. :)

Jared

On Mon, 28 Feb 2005 19:34:34 -0500, Bob Metelsky = <bobmetelsky_at_comcast.net>
wrote:
> I have a situation where I need to redirect database requests from=20
> clients. I have 1000+ clients who are connecting to various databases=20
> using tnsnames.ora. At this point I cant track them all down to issue =

> new connect strings. Heres the picture

>=20

> server 1 TRU64 Oracle 9i <-- has 7 primary databases that are being=20
> moved to server2 server2 HPUX Oracle 10g <-- new home of the 7=20
> databases above

>=20
> I need to have the listener of server1 bounce database connections to =

> server2 over time I can mine the listener log to figure out who the=20
> clients are and notify them of the new changes.

>=20

> For right now Im not (cannot) use onames or oid, I need to rely on=20
> the listener I've read about the remote listener but there arent clear =

> cut examples.

>=20
> Has anyone done this? can you share the configuration or documentation =

> on how to do this?

>=20

> TIA
> bob

>=20

> --
> "Oracle error messages being what they are, do not
> highlight the correct cause of fault, but will identify
> some other error located close to where the real fault lies."

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 01 2005 - 08:47:18 CST