Re: Finding TNS listener ports

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 29 Jul 2020 15:33:09 -0400

Bala, the solution is a tool called "nmap", very popular among the network administrators:

root@umajor:/home/mgogala# nmap ora19c
Starting Nmap 7.80 ( https://nmap.org ;) at 2020-07-29 14:58 EDT
Nmap scan report for ora19c (192.168.2.53)
Host is up (0.00034s latency).
rDNS record for 192.168.2.53: ora19c.home.com
Not shown: 997 closed ports
PORT     STATE SERVICE
22/tcp   open  ssh
111/tcp  open  rpcbind
_*1521/tcp open  oracle*_
MAC Address: 08:00:27:6B:DB:70 (Oracle VirtualBox virtual NIC)

Nmap done: 1 IP address (1 host up) scanned in 0.36 seconds

I am sure that your network administrator will gladly allow you to install nmap.

Regards

On 7/29/20 2:26 PM, Bala wrote:

Gurus,

We have over 25 Oracle 12cR2 databases with listeners running on one solaris server.

Is there any quick way to find ports of running listeners in Solaris ?  ( some unix level command to execute and get listing of running listeners with ports ?)

Thank you for your time.
Best
--
Bala Rao

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Other related posts: