Register Oracle service name on Listener other than 1521

While the default port number of the Oracle LISTENER 1521, then the Oracle database will register the services names within the Listener, but when we change the port number or adding an other listener, we have to manage this by configuring the initialization parameter “local_listener”, in my case there are an other Listener 1551.

Steps:

1. Check the Listener creation
2. Start the Listener with the port 1551
3. Create a tns names entry.
4. Configure the parameter local_listener
5. Check the Listener status

Step 1: Check the Listener creation:

[oracle@db12cr2 ~]$ cat /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
 listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
 Generated by Oracle configuration tools.
 LISTENER =
   (DESCRIPTION_LIST =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
     )
   )
 LISTENER51 =
   (DESCRIPTION_LIST =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1551))
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1551))
     )
   )

Step 2: Start the Listener with the port 1551:

$ lsnrctl status  LISTENER51
 LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-OCT-2020 10:57:28
 Copyright (c) 1991, 2016, Oracle.  All rights reserved.
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1551)))
 STATUS of the LISTENER
 Alias                     LISTENER51
 Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
 Start Date                17-OCT-2020 10:56:30
 Uptime                    0 days 0 hr. 0 min. 57 sec
 Trace Level               off
 Security                  ON: Local OS Authentication
 SNMP                      OFF
 Listener Parameter File   /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
 Listener Log File         /u01/app/oracle/diag/tnslsnr/db12cr2/listener51/alert/log.xml
 Listening Endpoints Summary…
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db12cr2.wadhahdaouehi.tn)(PORT=1551)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1551)))
 The listener supports no services
 The command completed successfully

Step 3: Create a tns names entry:

[oracle@db12cr2 ~]$ cat /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
 tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
 Generated by Oracle configuration tools.
 LISTENER_ORCL =
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 LISTENER_ORCL51 =
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1551))

Step 4: Configure the parameter local_listener

SQL> show parameter local
 NAME                     TYPE    VALUE
 
 local_listener                 string  LISTENER_ORCL
 parallel_force_local             boolean     FALSE
 SQL> alter system set local_listener='LISTENER_ORCL','LISTENER_ORCL51' scope=both;
 System altered.
 SQL> 

Step 5: Check the Listener status:

[oracle@db12cr2 ~]$ lsnrctl status  LISTENER51
 LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-OCT-2020 10:58:04
 Copyright (c) 1991, 2016, Oracle.  All rights reserved.
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1551)))
 STATUS of the LISTENER
 Alias                     LISTENER51
 Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
 Start Date                17-OCT-2020 10:56:30
 Uptime                    0 days 0 hr. 1 min. 33 sec
 Trace Level               off
 Security                  ON: Local OS Authentication
 SNMP                      OFF
 Listener Parameter File   /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
 Listener Log File         /u01/app/oracle/diag/tnslsnr/db12cr2/listener51/alert/log.xml
 Listening Endpoints Summary…
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db12cr2.wadhahdaouehi.tn)(PORT=1551)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1551)))
 Services Summary…
 Service "orcl" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service…
 Service "orclXDB" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service…
 The command completed successfully
 

Enjoy!