After listener.ora and tnsnames.ora file changes, only run this command
SQL> ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS = (PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1522))' SCOPE=BOTH;
Check current setting
SQL> SHOW PARAMETER local_listener;
Check listener
lsnrctl status
That's all.
SQL> ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS = (PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1522))' SCOPE=BOTH;
Check current setting
SQL> SHOW PARAMETER local_listener;
Check listener
lsnrctl status
That's all.