ORA-12541: TNS: no listener

by

The error ORA-12541: TNS:no listener typically occurs when client cannot connect to an Oracle Database. It means the listener process is not running on the specified server and port. Here are some steps to troubleshoot and resolve this issue:

Check Listener Status:

Use the command lsnrctl status to check if the listener is running.

If you have a specific listener name, use lsnrctl status.

$lsnrctl status INDPRD

Start the Listener:

If the listener is not running, start it using the command lsnrctl start.

Verify Connection Details:

Ensure that the connection string in your tnsnames.ora file is correct and matches the details in the listener.ora file.

<Address_Name> =

  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(Host = <hostname>)(Port = <port>))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = <service_name>)
    )
  )

Check for Network Issues:

Make sure there are no network issues preventing the client from reaching the server.

Leave a Comment