******************************************************************
* 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