Re: Finding TNS listener ports

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

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