Hi Brian, Thanks for your prompt response. But I have already checked this and its TRUE . Regards Mamta ________________________________ From: ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Dwyer, Brian Sent: Tuesday, 17 March 2009 17:24 To: ora-apps-dba@xxxxxxxxxxxxx Subject: RE: Reg:Oracle Service ************************************************************************ *** Internet email is not to be treated as a secure means of communication. North Yorkshire Police monitors all internet email activity and content. This communication is intended for the addressee(s) only. Please notify the sender if received in error. Unauthorised use or disclosure of the content may be unlawful. Opinions expressed in this document may not be official policy. Thank you for your co-operation. ************************************************************************ *** Check your registry entry on the server. hkey_local_machine/software/oracle In here the there are ORA_<SID>_AUTOSTART entries, these should be set to TRUE if you want the database to start via the services. Brian ________________________________ From: ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of NEELI-SC, Mamta Sent: 17 March 2009 09:16 To: ora-apps-dba@xxxxxxxxxxxxx Subject: RE: Reg:Oracle Service Hi sarfraz, In logfile its not displaying any message :-( Regards Mamta ________________________________ From: ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of fraz baig Sent: Tuesday, 17 March 2009 17:13 To: ora-apps-dba@xxxxxxxxxxxxx Subject: RE: Reg:Oracle Service Check services log for windows ________________________________ Subject: Reg:Oracle Service Date: Tue, 17 Mar 2009 17:10:57 +0800 From: Mamta.NEELI@xxxxxxxxxxxxxx To: ora-apps-dba@xxxxxxxxxxxxx Hello DBA's I have 11.5.9 on windows 2003 server. Everything was working fine by yesterday. Suddenly my database is not starting when I do by services. But it starts when I do through command prompt(SQLPLUS). Anyone has any idea on this? Please guide me. Thanks Mamta ________________________________ check out the rest of the Windows Live(tm). More than mail-Windows Live(tm) goes way beyond your inbox. More than messages <http://www.microsoft.com/windows/windowslive/>