Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> redirect client requests
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-lReceived on Mon Feb 28 2005 - 19:37:39 CST
![]() |
![]() |