| Another ORA-12541 TNS:no listener question [message #66142] |
Mon, 17 December 2001 13:19  |
J.R.
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
I've tried pretty much everything I've read here and to no avail. However, there is one item that no one has mentioned. Some background:
Clean install Windows 2000 advanced server. (New partitions all NTFS)
Clean install Oracle 8i release 3 Enterprise Edition. (Administration install, typical config)
No errors, app installed fine.
Launch PL*SQL developer and get ORA-12541 TNS:no listener error. Checked tnsnames and listener files and all is ok. Tried starting listener from command line (lisnrctl.exe) and this is where it gets interesting. When I check status, I am notified that the listener service is started but when I check NT services console, tnslistener service is STOPPING. Tried to manually stop and restart, hung the entire system. Rebooted in safe mode, set listener service to 'automatic' rebooted and checked services. Again, the service is listed as 'stopping'. Waited more than 10 minutes for service to stop and it never did. Tried manually stopping and starting service again, and system hung again.
One idea I haven't tried because I am a complete newbie is to allow the service to log in with user rather than system account. I have read that unless I specifically grant the system account access to NTFS volumes, that may cause errors. But since all my partitions are NTFS partitions, how could the account NOT have access to NTFS volumes?
I will try reinstalling Windows and Oracle but this will be my 3rd try. (Good thing I have a test machine and am not doing this on a production server!) In the meantime, ANY suggestions are appreciated.
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
| Re: Another ORA-12541 TNS:no listener question [message #66636 is a reply to message #66391] |
Thu, 19 September 2002 04:58  |
Balwinder Singh
Messages: 2
Registered: September 2002
|
Junior Member |
|
|
Hi,
I got this error while testing the Oracle Service name in Oracle NET Manager. I checked for the Listner, it was already existing. My Oracle is running on Windows 2000. Also I checked with the NT Service for Listner, it was running, I restarted it and again tested the service name, this time error was different, I could not get the exact text but it was that Database is not up. And the NT service for the Database was also running. I restarted that also and again tested. This time successful.
Hope this will help.
Warm Regards,
Balwinder Singh.
|
|
|
|
|
|
|
|
|
|
| Re: Another ORA-12541 TNS:no listener question [message #67439 is a reply to message #66391] |
Mon, 26 July 2004 10:14 |
Ranjit
Messages: 19
Registered: November 1999
|
Junior Member |
|
|
|
A month ago we upgraded the system from Oracle 8.1.7 to Oracle 9.2, and the restart still worked. Last weekend we upgraded the production system to Oracle 9.2, and the restart stopped working. The email says “ORA-12541: TNS:no listener.” The listener is running and if we restart the system manually it works.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Another ORA-12541 TNS:no listener question [message #120697 is a reply to message #120683] |
Mon, 23 May 2005 00:42 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
OK
Then for testing purpose, pls do delete all program related entries from zonealarm admninistrator. Then startup ur services and check for which all windows/program services are trying to access the system through zonealarm. Allow/disallow them on basis of ur observations and then check.
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
