What about Windows NT
Jesse, September 09, 2002 - 12:10 am UTC
I faced the same problem in Windows NT. Which directory does
Oracle writing the sockets?
Thks.
September 09, 2002 - 8:15 am UTC
As this is a unix specific issue, it must be something different on windows.
you are not facing the same issue, its different but without more info -- one cannot say what.
Sorry this is an NT issue too
David Jackson, May 30, 2003 - 12:31 pm UTC
Bad reply
May 30, 2003 - 1:50 pm UTC
care to explain why -- tell me, where do you find /var exactly on windoze.
this is *not* an NT issue.
Why /var/tmp/.oracle?
A reader, May 30, 2003 - 4:41 pm UTC
What tips you off that this is a issue with /var/tmp/.oracle and not something else?
The error simply says
Solaris Error: 2: No such file or directory
why do you think this is referring to /var/tmp/.oracle?
Just curious
RE: Why /var/tmp/oracle?
Mark A. Williams, May 30, 2003 - 4:59 pm UTC
From Metalink:
Doc ID: Note: 1073522.6
Subject: TNS-12541: When Starting Listener
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 08-JUL-1999
Last Revision Date: 20-MAR-2003
Problem Description:
====================
You receive the following messages in the "listener.log" file:
TNSLSNR for Solaris: Version 8.0.5.0.0 - Production on 07-JUL-99 18:43:51 (c) Copyright 1997 Oracle Corporation. All rights reserved.
System parameter file is /infosys/oracle/tnsadmin/listener.ora
Log messages written to /var/log/oracle/sqlnet/lsnr01.log
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=ipckey)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory
Solution:
=========
The Listener requires access to the directory '/var/tmp/oracle' in order to write socket files. The socket files are used for internal pipe connections to the database. Make sure that the Oracle user is the owner in this directory and has full permissions to it.
Problem Explanation:
====================
The ORA-12541 is actually cause by a Unix/Solaris error #2 :No such file or directory. This can be caused when the Listener attempts to access internal pipes socket files.
Note: 1073522.6 is a published note, so it is publicly accessible.
- Mark
listener
aby, August 01, 2003 - 2:30 am UTC
i can't start the listener in windows NT. it is showing the same error mentioned above.what should i do?
List of listeners
Venki, January 05, 2004 - 6:39 am UTC
Is there any way we can find out list of listners running using LSNRCTL utility??
January 05, 2004 - 7:35 am UTC
you sort of need to know the port they are running on.
on windoze, you can list the running services (net .... something. use "help net")
on unix'es you can "ps ... | grep tns"
Fixed my LISTENER problem
Faisal Ali, March 25, 2004 - 8:44 pm UTC
my /var/tmp/.oracle directory got deleted on HP-UX 11 and when the server rebooted, the listener could not start.
Thanks for the help.