The problem is that each time I boot my
machine I have to manually start the database by using DBA Studio. I looked into
Administrative Tools->Services. All Oracle related services mentioned there, are set to Automatic.
The registry value at HKLM\Software\Oracle\Home<x>\ORA_<SID>_AUTOSTART is set to TRUE and no message errors appear.
Could someone help me?
To start a database automatically when your server boots up, ensure the following registry setting is enabled: ORA_sid_AUTOSTART.
One can also specify autostart when creating new database services. Verify if this was done by opening Control Panel -> Services (Control Panel -> Administrative Tools -> Services on Windows 2000) and check if it is set to AUTOMATIC.
You may need to recreate the services mentioned above using the "oradim" (Instance Manager) utility. Start by opening a DOS command console window. Look at this example (assume a SID of TEST):
rem Delete the old service
ORADIM -DELETE -SID test -SRVC servicename
rem Create a new services with the STARTMODE AUTO property
oradim -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile C:\orant\admin\TEST\pfile\initTEST.ora