Home » RDBMS Server » Server Administration » Listener not starting
icon13.gif  Listener not starting [message #377757] Wed, 24 December 2008 22:09 Go to next message
I3C2
Messages: 24
Registered: June 2008
Junior Member
Sad Whenever I try starting the listener (by using lsnrctl command )it throws up the following error...
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

Can somebody pls help me out in resolving this issue?
Re: Listener not starting [message #377759 is a reply to message #377757] Wed, 24 December 2008 22:11 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
- You open services.msc, try to start the listener
- You login to the database in localhost, recheck status of instance.
icon13.gif  Re: Listener not starting [message #377760 is a reply to message #377759] Wed, 24 December 2008 22:16 Go to previous messageGo to next message
I3C2
Messages: 24
Registered: June 2008
Junior Member
I tried from services.msc It throws up the error..

"Could not start the OracleOrahome92TNSListener service on Local Computer. Error 3: System cannot find the path specified."
Re: Listener not starting [message #377761 is a reply to message #377760] Wed, 24 December 2008 22:23 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
What's result from "patch to executable" in service "Oracle..SIDListener"?
What's result from NetManager's Listener?
Can you connect to database in local?
icon13.gif  Re: Listener not starting [message #377763 is a reply to message #377761] Wed, 24 December 2008 22:30 Go to previous messageGo to next message
I3C2
Messages: 24
Registered: June 2008
Junior Member
path to executable shows as blank...
Re: Listener not starting [message #377764 is a reply to message #377763] Wed, 24 December 2008 22:35 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
No Listener to find. Try to recreate with Net Assistance or Net Manager.
icon4.gif  Re: Listener not starting [message #377805 is a reply to message #377764] Thu, 25 December 2008 04:35 Go to previous messageGo to next message
I3C2
Messages: 24
Registered: June 2008
Junior Member
I am not sure how to create one pls help...
icon14.gif  Re: Listener not starting [message #377806 is a reply to message #377805] Thu, 25 December 2008 05:12 Go to previous messageGo to next message
I3C2
Messages: 24
Registered: June 2008
Junior Member
I was able to create a new listener service and access oracle. However I continue to get the following error...I am not sure why?
TNS-01153: Failed to process string:
NL-00313: null pointer or null size Shocked

[Updated on: Thu, 25 December 2008 05:13]

Report message to a moderator

Re: Listener not starting [message #378000 is a reply to message #377757] Sat, 27 December 2008 12:26 Go to previous message
IT Guru
Messages: 59
Registered: January 2007
Member
uninstall & reinstall listner from oracle cd
Previous Topic: ORA-00214: controlfile
Next Topic: tablespace growth prediction
Goto Forum:
  


Current Time: Fri Nov 29 15:51:38 CST 2024