TNS-12541 No Listener Error

From: <dave_93_98_at_yahoo.com>
Date: 3 Feb 2005 18:18:10 -0800
Message-ID: <1107483490.042090.97910@f14g2000cwb.googlegroups.com>

Hi,
I am receiving a 12541 error trying to connect to an oracle listener on redhat linux.

When I do an lsnrctl status it shows that the listener is running (I also did an lsof -i to verify that the port was being used by tnslsnr). When I connect via sqlplus and run show parameter service_name it displays my SID.hostname. I have verified that my firewall is not an issue (shouldn't be because I cannot even do a tnsping on this machine) and that the hostname resolves correctly.

sqlnet.ora ----------
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES) I have commented out NAMES.DEFAULT_DOMAIN = hostname when it is uncommented it gives a failed to resolve name error.

Listener.ora --------
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = SID.hostname)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = SID)

    )
  )

tnsnames.ora ----------
# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

FW =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = SID.hostname)
(SRVR = DEDICATED)

    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = SID.hostname)
(PRESENTATION = http://admin)

    )
  )

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

    )
  )

Any help would be greatly appreciated.

Thanks,
Dave Received on Thu Feb 03 2005 - 20:18:10 CST