oracle services are getting started automatically on rebooting....

[James Wright]

Hi,

I am using oracle9i on Windows XP for my work. I have seen that sometimes oracle services(either listner or instance, sometimes both) are not getting started automatically on rebooting the machine. Though the services can be started manually after the reboot. I want to check what has gone wrong at oracle end.
I have checked the alert file but that does not contain any information regarding this issue.
Can anyone suggest any log file that may contain this kind of errors?

Thanks

[MichaelB999]

Check the value of ORA_<dbid>_AUTO START key in your registry.
It supposed to be set to TRUE.