I am using Oracle8i Enterprise Edition Release 18.104.22.168.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.
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
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 ?