Oracle service and listener not starting

11-30  Source: Network gathering  Views:0 

Advertisement
In my oracle 10.1.0.2.0 on windows Xp server today I found all the oracle services are stopped and when I try to start the listener it gives me the following error..
C:\>lsnrctl
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 15-JUL-2008 11:16
:02
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=suman)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
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
LSNRCTL> start
Starting tnslsnr: please wait...
Failed to start service, error 3.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 3: No such process
LSNRCTL>
I have set the oracle_home and oracle_sid also no difference. I tried to start from windows service window it gives me error 3: can not find the path specified.
I have re-created the listener and net configuration but still no improvement.
Any advice from you please?
Regards
Suman
do you any other version of oracle installed in your system...
the conflict will be beause of that...
u need to set environment variable for oracle_home as your 10g database... then restart the system...
then set oracle_sid
it should work
Related articles