Re: Finding TNS listener ports

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_at_gmail.com> 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_at_oracle.com <mailto:COURTNEY.LLAMAS_at_oracle.com>> 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_at_gmail.com <mailto:oratips_at_gmail.com>> 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

--
http://www.freelists.org/webpage/oracle-l