3 Replies Latest reply: Jan 24, 2014 5:51 PM by 619a229f-8fad-4ca0-af1b-cf3410661c14 RSS

Port Redirect on Oracle Database XE?

619a229f-8fad-4ca0-af1b-cf3410661c14 Newbie
Currently Being Moderated

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.






  • Correct Answers - 10 points
  • Helpful Answers - 5 points