Rename the Oracle Listener

1. Here you need to stop your listener

$ lsnrctl stop LISTENER

2. Now you can modify the file

$ORACLE_HOME/network/admin/listener.ora

As per the screenshot, you need to change LISTENER to LISTENER_ECC in listener.ora file where it is marked with red line, save it and start the new listener

$  lsnrctl start LISTENER_ECC

Then check the process name when you will do

$ ps -ef|grep lsn

orar s 1069298

1   0   Mar 29

-  4:39 /oracle/R  S/112_64/bin/tnslsnr LISTENER_ECC -inherit

Now you can see the listner is started with new name.

Wait its not done yet, when you will do R3trans -d it will not work!

You need to change the local listener inside oracle database, for that please proceed as below

Let your new listener LISTENER_ECC keep running

Start your SQL prompt with ora<sid>

SQL> show parameter local_listener

NAME                                 TYPE        VALUE

———————————— ———– ——————————

local_listener                       string

Here you need to modify the parameter “local_listener”

SQL> alter system set local_listener=’(address=(protocol=tcp)(host=ara- – -dbp05)(port=1521))’;

System altered.

Note: hostname and port should be same as it is mentioned in listener.ora

SQL> alter system register;

System altered.

Now you can go and execute R3trans -d, it will be able to connect to database.

The renaming of listener is complete!

Hope this will be of help to some of us.