Try
netstat -a|grep LISTEN|grep EXTPROC
I don’t have multiple users, so grep oracle for me works but assuming yours
will all be different user there.
Courtney Llamas | Strategic Customer Program | +1.713.374.2102
Oracle Manageability <https://www.oracle.com/manageability/>
On Jul 29, 2020, at 2:28 PM, Bala <oratips@xxxxxxxxx> wrote:
Thanks much for email. Your solution would work if listener was listening for
multiple databases. in our scenario,
Each of the 25 plus databases use different unix user account and different
port ( like 1530,1531........etc)
thanks
On Wed, Jul 29, 2020 at 3:00 PM Courtney Llamas <COURTNEY.LLAMAS@xxxxxxxxxx
<mailto:COURTNEY.LLAMAS@xxxxxxxxxx>> wrote:
How many listeners are running? Typically, the multiple DBs can use the
same listener. So the 25 db’s may all be using default LISTNER.
To see what listener processes are running:
$ ps -ef|grep lsnr
14700 12995 0 11:32 pts/2 00:00:00 grep lsnr
16872 1 0 Jan07 ? 00:34:57
/u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr LISTENER -inherit
To see what the listener is doing…
/u01/app/oracle/product/19.0.0/dbhome_1/bin/lsnrctl status LISTENER|grep PORT
Or…
/u01/app/oracle/product/19.0.0/dbhome_1/bin/lsnrctl status LISTENER|grep PORT
Should give you an idea of how many listeners, and what ports are listening…
Courtney Llamas | Strategic Customer Program | +1.713.374.2102
Oracle Manageability <https://www.oracle.com/manageability/>
On Jul 29, 2020, at 1:26 PM, Bala <oratips@xxxxxxxxx
<mailto:oratips@xxxxxxxxx>> 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
--
Bala Rao