Find and Check the Oracle Listener Service (Windows)

The Oracle Net Listener (TNS Listener) accepts client connections and hands them off to database services. On Windows it runs as a standard Windows Service. This page shows fast, reliable ways to find the listener and verify its status.

1. Services console (GUI)
   • Press Win+R → type services.msc → Enter.
   • Sort by Name and look for a service like OracleOraDB19Home1TNSListener.
   • Status shows Running (listener up) or Stopped.
2. Command line (fast)
   • PowerShell: Get-Service -Name *TNSListener* | Format-Table Name,Status,DisplayName
   • CMD: sc query type= service state= all | findstr /I TNSListener
3. Listener Control (LSNRCTL)
   • Open an Oracle command prompt (PATH includes %ORACLE_HOME%\bin).
   • Run lsnrctl status for detailed health, endpoints, services, and uptime.

Oracle uses a predictable pattern; the exact string can vary by version and home name:

OracleOraDB<version>Home<n>TNSListener
    

• 23c/19c example: OracleOraDB19Home1TNSListener
• Older 11g example (varies): OracleOraDb11g_home1TNSListener
• If you installed multiple Oracle Homes, the Home<n> suffix will differ per home.

You can list all Oracle services with:

PowerShell> Get-Service *Oracle* | Sort-Object Name | Format-Table Name, Status

Use an elevated console:

net stop  OracleOraDB19Home1TNSListener
net start OracleOraDB19Home1TNSListener
    

Or via the Services console: right-click the listener → Start/Stop/Restart.

From an Oracle-enabled shell:

lsnrctl status
lsnrctl start
lsnrctl stop
    

• If you have multiple listeners (e.g., non-default name), specify it: lsnrctl status LISTENER_DEV.
• Ensure ORACLE_HOME\bin precedes any older homes in PATH to avoid version mix-ups.

LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyServer)(PORT=1521)))
STATUS of the LISTENER
----------------------
Alias                      LISTENER
Version                    TNSLSNR for 64-bit Windows: 19.0.0.0.0
Start Date                 20-MAR-2024 23:30:55
Uptime                     0 days 12 hr. 24 min.
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MyServer)(PORT=1521)))
Services Summary...
  Service "ORCL" has 1 instance(s).
    Instance "ORCL", status READY, has 1 handler(s) for this service...
    

• Service missing? Re-run Oracle Net Configuration Assistant (NETCA) to create a listener.
• Port conflict (1521): Change the port in %ORACLE_HOME%\network\admin\listener.ora and restart, or free 1521.
• Firewall: Allow inbound TCP on the listener port from client subnets.
• Multiple homes: Verify which home owns the running listener: lsnrctl status shows the binary path.
• Service name vs DB service: A running listener doesn’t guarantee the PDB/CDB service is registered; check the “Services Summary” section.
• Permissions: Start/stop requires an elevated shell or admin rights to the service.

Logs reside under %DIAG_ADR_BASE%\diag\tnslsnr\<host>\<listener_name>\trace\listener.log (by default under diagnostic_dest). Entries include timestamps and result codes; 0 indicates success. In clustered setups, Oracle listeners can publish/consume notifications (ONS/CRS) to reflect node or service changes.