SyntaxFix

[oracle] Oracle client ORA-12541: TNS:no listener

You need to set oracle to listen on all ip addresses (by default, it listens only to localhost connections.)

Step 1 - Edit listener.ora

This file is located in:

  • Windows: %ORACLE_HOME%\network\admin\listener.ora.
  • Linux: $ORACLE_HOME/network/admin/listener.ora

Replace localhost with 0.0.0.0 

# ...

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    )
  )

# ...

Step 2 - Restart Oracle services

  • Windows: WinKey + r

    services.msc

  • Linux (CentOs):

    sudo systemctl restart oracle-xe

enter image description here

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to listener

• Android - How to achieve setOnClickListener in Kotlin? • Oracle client ORA-12541: TNS:no listener • How to properly stop the Thread in Java? • Can I have onScrollListener for a ScrollView? • Create a custom event in Java • TNS-12505: TNS:listener does not currently know of SID given in connect descriptor • Remove an onclick listener • Using Switch Statement to Handle Button Clicks • JavaScript: remove event listener • Counting Chars in EditText Changed Listener