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-l

Other related posts: