TNS Listener Won't Start
546959Apr 13 2007 — edited Apr 16 2007I'm running Oracle XE on a Windows 2000 computer and yesterday started getting this error:
-----------------------------------------------------------------------------------------------------------------------------
C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net start OracleXETNSListener
The OracleXETNSListener service is starting.
The OracleXETNSListener service could not be started.
The service did not report an error.
More help is available by typing NET HELPMSG 3534.
------------------------------------------------------------------------------------------------------------------------------
I checked the listener status and this is the message I get:
------------------------------------------------------------------------------------------------------------------------------
C:\oraclexe\app\oracle\product\10.2.0\server\BIN>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-APR-2007 10:24:14
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost.mydomain)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error
------------------------------------------------------------------------------------------------------------------------------
I don't understand what is going on here. It says it failed to start the listener because my computer doesn't exist? Can anyone shed some light on my problem and point me in the right direction to resolve the issue? I'd be most appreciative... I'm fairly new to this program and have only been working with it since November. I haven't had any issues up until now.