TNS-12541 No Listener Error

Syltrem

2005-02-06 04:53:05 UTC

"No Listener" tells you that your client machine cannot contact the
listener.

You said you have a firewall that could be your problem
I don't undesrtand your explanation as why it should not be the case.

Try a Telnet on the listener host/port from your client.
If you get a connection refused, you can talk to the listener but of course
cannot connect using Telnet.
If you get another message (like unknown adress, or no answer or whatever
else) it may help you see what the problem is.

Post this type of questions to comp.oracle.databases.server not here

HTH
Syltrem

Post by d***@yahoo.com
Hi,
I am receiving a 12541 error trying to connect to an oracle listener
(8.1.7) 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 port 1521 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 --------
/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 ----------
/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