Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

add comment

2 Answers

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
add comment

For temporary use you can also use Linux iptables NAT Redirect

share|improve this answer
add comment

Your Answer

 
discard

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