New to Oracle programs, would like to know how to do following?
Server has a listener on default Port 1521 and
want the server to respond to the client
with a different Port (or different server) with tns 'redirect' msg.
Can this be supported by configuring listener.ora and tnsnames.ora?
if yes, how? If changing the Port param to a number eg. 1550 in both .ora files,
I assume this will make the client to send initial 'connect' to Port 1550 instead of
1521 and tns 'redirect' will not be triggered.
Please note this has also the disadvantage when you shutdown the listener all connections will be dropped.
Also note when not using port 1521 you need to set the local_listener parameter in your spfile/init.ora.
Senior Oracle DBA