Oracle Dynamic Registration parameter local_listener

The local_listener parameter has two writing formats and provides different functions.

On the listener file, ports 1521 and 1526 have dynamic listening ports.

[oracle@dbsv admin]$ cat listener.ora LISTENER=  (DESCRIPTION=    (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1521))      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))SID_LIST_LISTENER=  (SID_LIST=    (SID_DESC=      (GLOBAL_DBNAME=PROD)      (ORACLE_HOME=/u01/oracle)      (SID_NAME=PROD))    (SID_DESC=      (GLOBAL_DBNAME=EMREP)      (ORACLE_HOME=/u01/oracle)      (SID_NAME=EMREP))    (SID_DESC=      (SID_NAME=plsextproc)      (ORACLE_HOME=/u01/oracle)      (PROGRAM=extproc)))LSNR2=  (DESCRIPTION=    (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1526))      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc2))))

[oracle@dbsv admin]$ cat tnsnames.ora prod= (DESCRIPTION=   (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(port=1521)))   (CONNECT_DATA=(SERVICE_NAME=PROD)(SERVER=dedicated)))lsnr2 =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = dbsv)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = dbsv)(PORT = 1526))))

Method 1: dynamically register the database to a listener with a separate Port

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=dbsv)(PORT=1526))';

Verification:

[oracle@dbsv admin]$ lsnrctl stat LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 21-JUN-2014 12:09:47Copyright (c) 1991, 2005, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.2.0 - ProductionStart Date                21-JUN-2014 10:42:29Uptime                    0 days 1 hr. 27 min. 17 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/oracle/network/admin/listener.oraListener Log File         /u01/oracle/network/log/listener.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))Services Summary...Service "EMREP" has 1 instance(s).  Instance "EMREP", status UNKNOWN, has 1 handler(s) for this service...Service "PROD" has 1 instance(s).  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...Service "plsextproc" has 1 instance(s).  Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully[oracle@dbsv admin]$ lsnrctl stat lsnr2LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 21-JUN-2014 12:09:59Copyright (c) 1991, 2005, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1526)))STATUS of the LISTENER------------------------Alias                     LSNR2Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - ProductionStart Date                21-JUN-2014 10:40:53Uptime                    0 days 1 hr. 29 min. 5 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/oracle/network/admin/listener.oraListener Log File         /u01/oracle/network/log/lsnr2.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1526)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc2)))Services Summary...Service "PROD" has 1 instance(s).  Instance "PROD", status READY, has 1 handler(s) for this service...Service "PROD_XPT" has 1 instance(s).  Instance "PROD", status READY, has 1 handler(s) for this service...The command completed successfully

No dynamically registered listener Library (READY) on port 1521, and READY on port 1526

Method 2: dynamically register the database to one or more listening ports that activate the Dynamic Registration Service

Write the listener information described by network_name in the tnsnames. ora file.

alter system set local_listener=lsnr2;

Verification:

[oracle@dbsv admin]$ lsnrctl stat LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 21-JUN-2014 12:13:26Copyright (c) 1991, 2005, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.2.0 - ProductionStart Date                21-JUN-2014 10:42:29Uptime                    0 days 1 hr. 30 min. 56 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/oracle/network/admin/listener.oraListener Log File         /u01/oracle/network/log/listener.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))Services Summary...Service "EMREP" has 1 instance(s).  Instance "EMREP", status UNKNOWN, has 1 handler(s) for this service...Service "PROD" has 2 instance(s).  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...  Instance "PROD", status READY, has 1 handler(s) for this service...Service "PROD_XPT" has 1 instance(s).  Instance "PROD", status READY, has 1 handler(s) for this service...Service "plsextproc" has 1 instance(s).  Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully[oracle@dbsv admin]$ lsnrctl stat lsnr2LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 21-JUN-2014 12:13:30Copyright (c) 1991, 2005, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1526)))STATUS of the LISTENER------------------------Alias                     LSNR2Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - ProductionStart Date                21-JUN-2014 10:40:53Uptime                    0 days 1 hr. 32 min. 37 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/oracle/network/admin/listener.oraListener Log File         /u01/oracle/network/log/lsnr2.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbsv)(PORT=1526)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc2)))Services Summary...Service "PROD" has 1 instance(s).  Instance "PROD", status READY, has 1 handler(s) for this service...Service "PROD_XPT" has 1 instance(s).  Instance "PROD", status READY, has 1 handler(s) for this service...The command completed successfully

The listeners on both ports have dynamic database registration (READY.