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';
-- 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';