Database Networking (MOSC)

MOSC Banner

ORA-12541 TNS: 'No listener error' Troubleshooting

Here are some steps to troubleshoot a "no listener" error.  Very often the listener is not using the PORT or HOST
that the client expects.  This document should help in finding the cause:

Troubleshooting Guide for ORA-12541 TNS: No Listener  (Doc ID 2059450.1)

Sample of some quick listener checks:

UNIX:

1)  Grep for tns listener process.

     ps -ef | grep tns

     Confirm the listener process is present.

     Confirm the listener is running under:

        A)  The correct name (LISTENER, LISTENER_SCANx, etc)

           The correct $ORACLE_HOME/bin (GRID, RDBMS_HOME)

2)  Check netstat output and confirm the port/address:

      netstat -an | grep <listener port here>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center