Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> redirect client requests

redirect client requests

From: Bob Metelsky <bobmetelsky_at_comcast.net>
Date: Mon, 28 Feb 2005 19:34:34 -0500
Message-ID: <4223B89A.7040606@comcast.net>


 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
Received on Mon Feb 28 2005 - 19:37:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US