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