Ora-12541:TNS:no listener

[ick1383]

Hello all,

I run an application based on Oracle 8.1.7 (Server OS: Windows 2000 SP4) and all of a sudden, on a random basis, I started to get an error message on client machines - "Ora-12541:TNS:no listener", not being able then to connect to the db. The problem happens more often on a client machine where I have the Web Server of my application.

The OracleOra817TNSListener service is started and I even if I stop and restart it, or try the "lsnrctl stop/start" commands, the error persists. After rebooting the server the application runs fine, but after a while the message starts to come up again on a the client side.

The TNSNAMES.ORA on the client matches the file with the same name on the server. The TNSPING on the client side runs fine and then suddenly I get the NO LISTENER error.

I performed a fresh installation in the beginning of the year and just recently I started to get this error. I also read some previous messages on this forum regarding the error but could not conclude what is happening at my environment.

I would appreciate any help. Thank you very much!
Ivo

[marist89]

Can you verify that the listener is going up and down?

[ick1383]

I am not sure if I understand your question, but even when I get the error, the service is up and running. Also, even typing lsnrctl stop/start the error persists.

Thank you!!

[marist89]

Put it another way, is your listener really going up and down or is it always up even when you get these error messages?

[ick1383]

It is always up even when I get these error messages. Again, everything is running fine and all of a sudden the error message appears. Then, after rebooting the client machine I can connect correctly to the db on the server until I get the error again (on the client side).

Thank you again!

[marist89]

I'd be looking at two things:
1. make sure the instance is registered in the listener.ora.
2. make sure your local_listener parameter in the init.ora is pointing to the correct listener.

[ick1383]

On the server machine I do have a init.ora, but it does not have a local_listener parameter. There is no such file on the client side.

The listener.ora on the server machine is like this:

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

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dx06smt3)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = dx06smt3)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora817)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = decasp.dx06)
(ORACLE_HOME = C:\oracle\ora817)
(SID_NAME = decasp)
)
)

The Global name, SID, Oracle home and Host entries are all correct.

What really surprises me is that, as I mentioned before, the problem happens more often on a client machine where I have the Web Server of my application and not on the other Win32 client machines.

Thank you!!