How to Change Default Port
of Oracle Database Listener
Applies
to:
Oracle Enterprise Linux – Version: 7
Oracle Database 11gR2
Description:
I want to change the default port of Oracle
Database Listener.
Solution:
To change the default port of Oracle Database Listener do
the following steps:
1.
Stop
Oracle Database Listener
#
lsnrctl stop
2.
Open
$ORACLE_HOME/network/admin/listener.ora file and change the port from default
1521 to 1530 or as you wish
3. Open $ORACLE_HOME/network/admin/tnsnames.ora
file and change the port from default 1521 to 1530 or as you wish to change
4.
Re-start
the listener
# lsnrctl start
5.
Login
to Database as sysdba
# sqlplus / as sysdba
SQL> alter system set local_listener=”(ADDRESS=(PROTOCOL=TCP)
(HOST=localhost) (PORT=1530))”;
SQL> alter system register;
Exit;
6. lsnrctl stop
7.
lsnrctl
start
Oracle Database Listener Port has been
changed from 1521 to 1530
Your comments, especially which will help us
improve the functionality, will be greatly appreciatedJ
