HiveBrain v1.2.0
Get Started
← Back to all entries
debugMinor

Error ORA-12541: TNS:no listener

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
errortnslistenerora12541

Problem

Whenever I try to start the listener (I just have only one Oracle database) I get the following:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=admin-41f89f35d)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error


tnsnames.ora

# TNSNAMES.ORA Network Configuration File: F:\Oracle\network\admin\tnsnames.ora  
    # Generated by Oracle configuration tools.  

    PROJECT =  
      (DESCRIPTION =  
        (ADDRESS_LIST =  
          (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))  
        )  
        (CONNECT_DATA =  
          (SERVICE_NAME = PROJECT)  
        )  
      )  

    INST1_HTTP =  
      (DESCRIPTION =  
        (ADDRESS_LIST =  
          (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))  
        )  
        (CONNECT_DATA =  
          (SERVER = SHARED)  
          (SERVICE_NAME = MODOSE)  
          (PRESENTATION = http://HRService)  
        )  
      )  

    EXTPROC_CONNECTION_DATA =  
      (DESCRIPTION =  
        (ADDRESS_LIST =  
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))  
        )  
        (CONNECT_DATA =  
          (SID = PLSExtProc)  
          (PRESENTATION = RO)  
        )  
      )


listerner.ora

# LISTENER.ORA Network Configuration File: F:\Oracle\network\admin\listener.ora  
# Generated by Oracle configuration tools.  

LISTENER =  
  (DESCRIPTION_LIST =  
    (DESCRIPTION =  
      (ADDRESS_LIST =  
        (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))  
      )  
    )  
  )  

SID_LIST_LISTENER =  
  (SID_LIST =  
    (SID_DESC =  
      (SID_NAME = PLSExtProc)  
      (ORACLE_HOME = F:\Oracle)  
      (PROGRAM = extproc)  
    )  
    (SID_DESC =  
      (GLOBAL_DBNAME = PROJECT)  
      (ORACLE_HOME = F:\Oracle)  
      (SID_NAME = PROJECT)  
    )  
  )


I really don't know what the problem is. My tnsnames.ora and listener.ora file

Solution

As a quick fix, you can just remove the entries (with respect to your database)from both the tnsnames.ora and listerner.ora.
In your scenario, remove this from tnsnames.ora

PROJECT =  
      (DESCRIPTION =  
        (ADDRESS_LIST =  
          (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))  
        )  
        (CONNECT_DATA =  
          (SERVICE_NAME = PROJECT)  
        )  
      )


and this from listerner.ora

SID_LIST_LISTENER =  
  (SID_LIST =  
    (SID_DESC =  
      (SID_NAME = PLSExtProc)  
      (ORACLE_HOME = F:\Oracle)  
      (PROGRAM = extproc)  
    )  
    (SID_DESC =  
      (GLOBAL_DBNAME = PROJECT)  
      (ORACLE_HOME = F:\Oracle)  
      (SID_NAME = PROJECT)  
    )  
  )


and then you can try to open up the database.
These entries would be created automatically.
And we hope the listener listens to us this time.

Code Snippets

PROJECT =  
      (DESCRIPTION =  
        (ADDRESS_LIST =  
          (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))  
        )  
        (CONNECT_DATA =  
          (SERVICE_NAME = PROJECT)  
        )  
      )
SID_LIST_LISTENER =  
  (SID_LIST =  
    (SID_DESC =  
      (SID_NAME = PLSExtProc)  
      (ORACLE_HOME = F:\Oracle)  
      (PROGRAM = extproc)  
    )  
    (SID_DESC =  
      (GLOBAL_DBNAME = PROJECT)  
      (ORACLE_HOME = F:\Oracle)  
      (SID_NAME = PROJECT)  
    )  
  )

Context

StackExchange Database Administrators Q#12384, answer score: 2

Revisions (0)

No revisions yet.