Dennis Yurichev: 30-Jan-2010: Random Oracle hosts statistics

30-Jan-2010: Random Oracle hosts statistics

Nmap is a powerful tool, not only for scanning a remote host for open ports, by also for random stalking for something in the Internet.

For experiment, I and my friends ran nmap with -iR 0 -p1521 options, meaning checking for open port 1521 on randomly generated IP addresses, infinitely.

Result: one working Oracle TNS Listener among nearly 69,000 random IP addresses.

Here is statistics on listener versions and operation systems.

Top 3 operation systems:

37% - Linux
52% - Windows
6% - Solaris

Oracle TNS Listener versions:

55% - 10.2
23% - 9.2
7% - 11.1
5% - 8.1
4% - 10.1
2% - 8.0
2% - 9.0

Didn't found any 11.2 working.

Full statistics: number is percentage and listener version reply.

21.22 TNSLSNR for Linux: Version 10.2.0.1.0 - Production
19.50 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
9.56 TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
4.78 TNSLSNR for Linux: Version 9.2.0.4.0 - Production
2.68 TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Production
2.68 TNSLSNR for Linux: Version 11.1.0.6.0 - Production
2.10 TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production
2.10 TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Production
1.91 TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
1.72 TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Production
1.72 TNSLSNR for 32-bit Windows: Version 9.2.0.8.0 - Production
1.72 TNSLSNR for Linux: Version 10.2.0.3.0 - Production
1.53 TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
1.53 TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
1.53 TNSLSNR for Linux: Version 10.2.0.4.0 - Production
1.34 TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
1.15 TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
1.15 TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
0.96 TNSLSNR for Linux: Version 8.1.7.0.0 - Development
0.96 TNSLSNR for Linux: Version 9.2.0.1.0 - Production
0.96 TNSLSNR for Solaris: Version 10.2.0.3.0 - Production
0.76 TNSLSNR for 64-bit Windows: Version 10.2.0.1.0 - Production
0.76 TNSLSNR for 64-bit Windows: Version 10.2.0.3.0 - Production
0.76 TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production
0.76 TNSLSNR for Linux: Version 11.1.0.7.0 - Production
0.76 TNSLSNR for MacOS X Server: Version 10.1.0.5.0 - Production
0.57 TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production
0.57 TNSLSNR for 32-bit Windows: Version 8.1.5.0.0 - Production
0.57 TNSLSNR for Linux: Version 10.1.0.3.0 - Production
0.57 TNSLSNR for Linux: Version 9.2.0.6.0 - Production
0.57 TNSLSNR for Solaris: Version 9.2.0.6.0 - Production
0.38 TNSLSNR for 32-bit Windows: Version 10.1.0.4.2 - Production
0.38 TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production
0.38 TNSLSNR for 32-bit Windows: Version 8.1.7.4.0 - Production
0.38 TNSLSNR for 32-bit Windows: Version 9.2.0.5.0 - Production
0.38 TNSLSNR for 64-bit Windows: Version 11.1.0.6.0 - Production
0.38 TNSLSNR for 64-bit Windows: Version 11.1.0.7.0 - Production
0.38 TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production
0.38 TNSLSNR for Linux: Version 10.2.0.2.0 - Production
0.38 TNSLSNR for Linux: Version 9.0.1.0.0 - Production
0.38 TNSLSNR for Solaris: Version 10.1.0.5.0 - Production
0.38 TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
0.38 TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
0.38 TNSLSNR80 for 32-bit Windows: Version 8.0.5.0.0 - Production
0.19 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Beta
0.19 TNSLSNR for 32-bit Windows: Version 8.1.7.3.0 - Production
0.19 TNSLSNR for 32-bit Windows: Version 9.0.1.4.1 - Production
0.19 TNSLSNR for 32-bit Windows: Version 9.2.0.7.0 - Production
0.19 TNSLSNR for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production
0.19 TNSLSNR for DEC OSF/1 AXP: Version 8.1.7.4.0 - Production
0.19 TNSLSNR for HPUX: Version 10.1.0.5.0 - Production
0.19 TNSLSNR for HPUX: Version 10.2.0.3.0 - Production
0.19 TNSLSNR for HPUX: Version 9.2.0.1.0 - Production
0.19 TNSLSNR for HPUX: Version 9.2.0.4.0 - Production
0.19 TNSLSNR for HPUX: Version 9.2.0.8.0 - Production
0.19 TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
0.19 TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production
0.19 TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production
0.19 TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
0.19 TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.4.0 - Production
0.19 TNSLSNR for Linux: Version 10.1.0.4.2 - Production
0.19 TNSLSNR for Linux: Version 8.1.6.0.0 - Production
0.19 TNSLSNR for Linux: Version 9.2.0.5.0 - Production
0.19 TNSLSNR for Linux: Version 9.2.0.7.0 - Production
0.19 TNSLSNR for Linux: Version 9.2.0.8.0 - Production
0.19 TNSLSNR for OS400: Version 10.2.0.1.0 - Production
0.19 TNSLSNR for Solaris: Version 11.1.0.6.0 - Production
0.19 TNSLSNR for Solaris: Version 8.0.5.0.0 - Production
0.19 TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
0.19 TNSLSNR for Solaris: Version 8.1.7.4.0 - Production
0.19 TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
0.19 TNSLSNR for Solaris: Version 9.2.0.7.0 - Production
0.19 TNSLSNR for Solaris: Version 9.2.0.8.0 - Production

→ [list of blog posts] Please drop me email about bug(s) and/or suggestion(s): my emails.