How to tell if the Oracle Listener is running on a Voyager server
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Question
How to tell if the Oracle Listener is running on a Voyager server?
Answer
The Oracle Listener allows other machines on the network to connect to Oracle such as Prepackaged Access Reports (ODBC) and split server processes. Oracle itself can be running but the Listener can be down.
SSH to the Voyager server as the voyager user.
Run this command:
ps -ef | grep -i listener | grep -v grep
You should see something like the following returned if the listener is running:
oracle 2347 1 0 01:01 ? 00:00:01 /oracle/app/oracle/product/12.1.0.2/db_1/bin/tnslsnr LISTENER -inherit
Configuration information for the Listener can be obtained by running this command:
lsnrctl status
Additional Information
If you run the "ps" command shown above and the listener is not running, the command prompt will simply be returned with no further information.
If you run the "status" command shown above and the listener is not running, you'll see something like this:
[VGER] voyager@us-voyqalnx02.corp.exlibrisgroup.com : 2010.3.0/ $ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-FEB-2021 06:41:05
Copyright (c) 1991, 2020, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=us-voyqalnx02.corp.exlibrisgroup.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
[VGER] voyager@us-voyqalnx02.corp.exlibrisgroup.com : 2010.3.0/ $
- Article last edited: 08-Sept-2020