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!
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).