starting Oracle service automatically

Hi

I am using Oracle8i Enterprise Edition Release 8.1.6.0.0. with windows2000 professional. The problem is that the database does not start automatically when I reboot the machine. The status in service panel is indicating starting instead of started.

I delete the password file , and drop the OracleServiceMYDB service then reboot the machine and recreate the password file and OracleServiceMYDB.

C:\>orapwd file=C:\Oracle\Ora81\DATABASE\pwdMYDB.ora password=mydb entries=5
C:\>ORADIM -NEW -SID MYDB -INTPWD mydb -STARTMODE a -PFILE C:\Oracle\admin\MYDB\pfile\initMYDB.ora

The instance is started and connected to mydb database. now I am able to connect and work with the database “The status in service panel is indicating started for OracleServiceMYDB service” now every thing is ok, but when I reboot the machine, I got OracleServiceMYDB starting but never started and got my old problem.

The following parameter is introduced into my windows registry as I drop and recreate the service using ORADIM utility

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 ORACLE_SID"="MYDB

ORA_mydb_AUTOSTART= TRUE
ORA_mydb_PFILE= C:\Oracle\admin\MYDB\pfile\initMYDB.ora
ORA_mydb_SHUTDOWN= TRUE 
ORA_mydb_SHUTDOWNTYPE=i
ORA_mydb_SHUTDOWN_TIMEOUT=30

By default OracleServiceMYDB service use LOCALSYSTEM account to login as a service.
When I change the service to login as administrator the service is started when I reboot the machine and the problem is solved. but not as localsystem account.
For OracleOraHome81TNSListener and other services the localsystem is working very well.
why this happened ?
TIA Ahmad A Alghaden
alghaden_at_alumni.fdu.edu
KSA Received on Fri Aug 08 2003 - 16:49:14 CEST