Useful shortcuts for vi editor

Showing posts with label port. Show all posts
Showing posts with label port. Show all posts

Tuesday 1 November 2016

How to configure listener port when it changes (like 1522) ?

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.

Sunday 12 April 2015

How to find a listening port in Linux?

There are two simple ways for finding the listening port.
  • lsof | grep 8080
  • netstat -an | grep 8080