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

👉 Check our complete guide: Oracle Error Codes Guide