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 + rservices.msc
  • Linux (CentOs):sudo systemctl restart oracle-xe

Related Posts:

  1. SQL error “ORA-01722: invalid number”
  2. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  3. QL Error: ORA-00933: SQL command not properly ended
  4. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  5. ORA-28040: No matching authentication protocol exception
  6. SQL Error: ORA-00942 table or view does not exist
  7. ORA-00984: column not allowed here [duplicate]
  8. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  9. How to resolve ORA 00936 Missing Expression Error?
  10. SQL not a single-group group function
  11. PLS-00201 – identifier must be declared
  12. issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
  13. ORA-30926: unable to get a stable set of rows in the source tables
  14. PLS-00103: Encountered the symbol “CREATE”
  15. SQL error “ORA-01722: invalid number”
  16. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  17. No more data to read from socket error
  18. ORA-12899: value too large for column
  19. Oracle startup not possible – ORA-00845: MEMORY_TARGET not supported on this system – but memory size seems to be fine
  20. Oracle date format picture ends before converting entire input string
  21. SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  22. SQL Error: ORA-00913: too many values
  23. UTL_FILE.FOPEN() procedure not accepting path for directory?
  24. ORA-01653: unable to extend table by in tablespace ORA-06512
  25. SQL Error: ORA-01861: literal does not match format string 01861
  26. ORA-28001: The password has expired
  27. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  28. Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
  29. sqldeveloper error : no ocijdbc11 in java.library.path on windows 7
  30. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  31. Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
  32. ORA-01747: invalid user.table.column, table.column, or column specification
  33. SQL Queries “00904. 00000 – “%s: invalid identifier”
  34. How to display databases in Oracle 11g using SQL*Plus
  35. grant select on view
  36. Hibernate dialect for Oracle Database 11g?
  37. Query to display all tablespaces in a database and datafiles
  38. ‘NOT LIKE’ in an SQL query
  39. ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
  40. How can I set a custom date time format in Oracle SQL Developer?
  41. How to copy files into a virtual box oracle box
  42. Find out the history of SQL queries
  43. ORA-00904: invalid identifier
  44. how to fix oracle ORA-01722 invalid number error
  45. ORA-00979 not a group by expression
  46. ORA-00907: missing right parenthesis
  47. error: ORA-65096: invalid common user or role name in oracle
  48. ORA-12154 could not resolve the connect identifier specified
  49. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  50. ORA-01843 not a valid month- Comparing Dates
  51. ORA-00918: column ambiguously defined in SELECT *
  52. Oracle error : ORA-00905: Missing keyword
  53. What does SQL Select symbol || mean?
  54. How do I limit the number of rows returned by an Oracle query after ordering?
  55. Oracle SELECT TOP 10 records
  56. Can a foreign key be NULL and/or duplicate?
  57. How to Select Top 100 rows in Oracle?
  58. What is the purpose of a listener in Java?
  59. ORA-12560: TNS:protocol adaptor error
  60. What does the following Oracle error mean: invalid column index
  61. ORA-00972 identifier is too long alias column name
  62. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  63. What does the following Oracle error mean: invalid column index
  64. Oracle Apex column link from LOV values
  65. PLS-00103: Encountered the symbol when expecting one of the following:
  66. ORA-00918: column ambiguously defined in SELECT *
  67. ORA-00918: column ambiguously defined in SELECT *
  68. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  69. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  70. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  71. ORA-01861: literal does not match format string
  72. Is there a combination of “LIKE” and “IN” in SQL?
  73. What is it exactly a BLOB in a DBMS context
  74. SQLRecoverableException: I/O Exception: Connection reset
  75. How do you create a temporary table in an Oracle database?
  76. Oracle “Partition By” Keyword
  77. How to insert date values into table
  78. Oracle SQL: Update a table with data from another table
  79. PCI\VEN_10EC&DEV_522A&SUBSYS_837D103C&REV_01
  80. Oracle SQL query for Date format
  81. How to execute an oracle stored procedure?
  82. What is the Oracle equivalent of SQL Server’s IsNull() function?
  83. How SID is different from Service name in Oracle tnsnames.ora
  84. SQL selecting rows by most recent date with two unique columns
  85. Comparing Dates in Oracle SQL
  86. Convert timestamp to date in Oracle SQL
  87. How do I reset a sequence in Oracle?
  88. MySQL equivalent of DECODE function in Oracle
  89. How do I use CREATE OR REPLACE?
  90. Oracle: If Table Exists
  91. DATEDIFF function in Oracle
  92. How to create id with AUTO_INCREMENT on Oracle?
  93. LEFT function in Oracle
  94. What is the difference between Views and Materialized Views in Oracle?
  95. How do I view the Explain Plan in Oracle Sql developer?
  96. ORA-01779: cannot modify a column which maps to a non key-preserved table
  97. ORA-01735: invalid ALTER TABLE option – Toad
  98. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  99. PLS-00049 bad bind variable While using :OLD
  100. Run Oracle SQL script and exit from sqlplus.exe via command prompt

Leave a Comment

tech