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
> clients. I have 1000+ clients who are connecting to various databases
> using tnsnames.ora. At this point I cant track them all down to issue
> new connect strings. Heres the picture
>
> server 1 TRU64 Oracle 9i <-- has 7 primary databases that are being
> moved to server2
> server2 HPUX Oracle 10g <-- new home of the 7 databases above
>
> 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 clients are
> and notify them of the new changes.
>
> For right now Im not (cannot) use onames or oid, I need to rely on the
> listener
> I've read about the remote listener but there arent clear cut examples.
>
> Has anyone done this? can you share the configuration or documentation
> on how to do this?
>
> TIA
> bob
>
> --
> "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."
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l