Set local_listener in db - oracle database script

Set local_listener in db - Oracle Database Script.

-- Make the sure the a listener is already running with that port(i.e 1524 here)  alter system set LOCAL_LISTENER='(ADDRESS = (PROTOCOL = TCP)(HOST = 162.20.217.15)(PORT = 1524))' scope=both;  alter system register;  select type, value from v$listener_network where TYPE='LOCAL LISTENER';