Oracle Dynamic Registration Parameter Local_listener

The Local_listener parameter has two writing formats that provide different functionality.

On the listening file, there are dynamic listening ports on both 1521 and 1526 ports.

[email protected] 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)))

[email protected] admin]$ cat Tnsnames.ora prod= (description= (address_list= (address=      ) (protocol=tcp 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)))

How to: Dynamically register a database on a single port for listening

Alter system set Local_listener= ' (Address= (PROTOCOL=TCP) (HOST=DBSV) (port=1526)) ';

Verify:

[[email protected] admin]$ lsnrctl stat lsnrctl for linux:version 10.2.0.2.0-production on 21-JUN-2014 12:09:47Cop  Yright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (Description= (address= (protocol=tcp) (HOST=DBSV)) 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. min. sectra Ce level offsecurity on:local OS authenticationsnmp offlistener Param Eter 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, have 1 handler (s) for thisService ...  Service "PROD" has 1 instance (s). Instance "PROD", status UNKNOWN, have 1 handler (s) for the This service ...  Service "Plsextproc" has 1 instance (s). Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...  The command completed successfully[[email protected] 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)) 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. min. 5 Sectrace L  Evel 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, have 1 handler (s) for the This service ...  Service "PROD_XPT" has 1 instance (s). Instance "PROD", status ready, have 1 handler (s) for the This service ... The command completed successfully

1521 there are no dynamically registered listening libraries (ready), 1526 ports on the ready

Method Two: Dynamic registration of the database to one or more open dynamic registration services on the listening port

Write the network_name description of the listener in the Tnsnames.ora file, as above LSNR2

alter system set LOCAL_LISTENER=LSNR2;

Verify:

[[email protected] admin]$ lsnrctl stat lsnrctl for linux:version 10.2.0.2.0-production on 21-JUN-2014 12:13:26Cop  Yright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (Description= (address= (protocol=tcp) (HOST=DBSV)) 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. min. sectra Ce level offsecurity on:local OS authenticationsnmp offlistener Param Eter 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, have 1 handler (s) for thisService ...  Service "PROD" has 2 instance (s).  Instance "PROD", status UNKNOWN, have 1 handler (s) for the This service ... Instance "PROD", status ready, have 1 handler (s) for the This service ...  Service "PROD_XPT" has 1 instance (s). Instance "PROD", status ready, have 1 handler (s) for the This service ...  Service "Plsextproc" has 1 instance (s). Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...  The command completed successfully[[email protected] 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)) 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. min. Notoginseng sectrace Level offsecurity ON:local OS authenticationsnmp Offlistener Parameter file/u01/oracle/network/admin/listener.oralis  Tener 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, have 1 handler (s) for the This service ...  Service "PROD_XPT" has 1 instance (s). Instance "PROD", status ready, have 1 handler (s) for the This service ... The command completed successfully

Listening on two ports, there is a dynamic registration (ready) of the database.