FreeLists / oracle-l / RE: redirect client requests

[William B Ferguson <wbfergus@xxxxxxxx>]

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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of jkstill@xxxxxxxxx
Sent: Monday, February 28, 2005 6:46 PM
To: bobmetelsky@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx>
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