I am creating a project in Oracle Is it possible that I can change Port Number in Oracle 10g for remote connections ?
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...
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.