How to Change Default Port of Oracle Database Listener
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
Comments
Post a Comment