Oracle Listener Status check

[Joe Banks]

I'm new to this. What is the best way to check the status of the listener? Ours is hanging and causing an IVR app to hang during a sys check step. Any ideas would be helpful.

[Hai Nguyen_1]

Joe,

Login as oracle, then run:

# lsnrctl status

My spelling may not be correct. if lsnrctl does not work, try lnsrctl.

Hai

[Joe Banks]

Thanks, I can start with that. I would ultimately like the IVR to query the status and receive a reply that it can report on. Then I can alert based on status of listener.

[Tom Danzig]

lsnrctl status

=============================

Or if you don't want all the output:

lsnrctl status 1>/dev/null 2>&1

if [[ $? -eq 0 ]]
then
echo "Listener is OK"
else
echo "Listener is NOT OK"
fi

[Wodisch]

Hi,

checking wether the listener runs, is usually NOT enough (it may be hanging), so you'll have to do something like:
- lsnrctl status # like the others wrote
- tnsping TNSNAME # wether it responds
- sqlplus USER/PASSWORD@TNSNAME script # do something (like "select * from v$database;")

If all three do well, then you can be fairly certain that is DOES work...

Just my $0.02,
Wodisch