What is this Site!!

All about Real time requirements in Orale Stay Tune!!

Wednesday, November 7, 2007




Change the Port number after the Installation


How to change the Port number after the installation of Oracle software?

Ports 1521/1526 are the default port numbers Oracle will listen on for SQL*Net (Oracle 7) or Net8 (Oracle 8) out of the box.


There is a file in directory:

%ORACLE_HOME%\network\admin (Oracle 7) or %ORACLE_HOME%\net8\admin(Oracle 8) called listener.ora that specifies the ports to listen on.

(if you change it you need to change the tnsnames.ora file on all clients that connect to it - including itself, that file usually resides in the same location- if you don't they will not know which port to try to connect to)

0 comments: