Re: Service doesn't start the database

astalavista wrote:
> >
> > sqlplus "/ as sysdba"
> > startup
> >
> > and see if it starts then.
> >
> > If it does, exit sqlplus, back to the prompt, and:
> >
> > oradim -edit -sid basedata -starttype a
>
> Yes, the database started by hand ...thankfully
> I will try (re-try) to use oradim tomorrow

"net start oracleservice" not starting the database means your service was simply not created to autostart the database. In case you haven't recreated the service yet, what's the value for this registry key:

HKLM | Software | Oracle | All_Homes | Home0 (or whatever number appropriate) | ORA_<SID>_AUTOSTART

This "autostart" has nothing to do with Windows service autostart on reboot.

Yong Huang Received on Tue Aug 02 2005 - 23:07:05 CDT