Error ORA-12541: TNS:no listener

listeneroracle

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 files looks fine to me.

Best Answer

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.

Related Question