Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am creating a project in Oracle Is it possible that I can change Port Number in Oracle 10g for remote connections ?

share|improve this question

migrated from stackoverflow.com Nov 8 '11 at 8:10

This question came from our site for professional and enthusiast programmers.

This is more an administration than a coding question:

Oracle connections are based on server-side "listeners" - these can be configured independently of the DB itself and can use any IP/port...

Click here to read how to do that exactly - BTW: it depends on your server+network config (i.e. which OS ? Is the DB on a RAC ? etc.)!

Basically you just need to setup a listener for the DB/instance with the port number you want server-side and then use that in your client-side connection-string / TNSNAMES-config.

share|improve this answer

For temporary use you can also use Linux iptables NAT Redirect

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.