******************************************************************
* Description: Check each port is being listened by which process
* Date: 10:34 AM EST, 02/19/2021
******************************************************************
<1> Check the server port is being listened by which process:
|
|__ $ netstat -tulpn
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:10000 0.0.0.0:* LISTEN 29537/httpd
tcp 0 0 0.0.0.0:8400 0.0.0.0:* LISTEN -
tcp 0 0 127.0.0.1:37138 0.0.0.0:* LISTEN -
tcp6 0 0 :::31600 :::* LISTEN 28738/rwserver
tcp6 0 0 :::9179 :::* LISTEN 29113/java
tcp6 0 0 :::4443 :::* LISTEN 29537/httpd
udp6 0 0 :::14021 :::* 27718/java
udp6 0 0 :::14021 :::* 28738/rwserver
udp6 0 0 :::7574 :::* 27718/java
<2> Check further on detail:
|
|__ $ netstat -tulpn | grep 1521
|
|__ $ ps -ef | grep
oracle 17988 1 0 Feb12? 00:00:21 /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnlsnr LISTENER -inhert
Reference:
|
|__ o. Oracle Supplemental Log - https://docs.oracle.com/database/121/SUTIL/GUID-D857AF96-AC24-4CA1-B620-8EA3DF30D72E.htm#SUTIL1582
|
|__ o. Oracle Log Mining - https://oracle-base.com/articles/8i/logminer
|
|__ o. Oracle 19c Log Mining - https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-logminer-utility.html#GUID-3417B738-374C-4EE3-B15C-3A66E01AE2B5
Your Comments