In one of my client machines every time Windows starts we have to start the Oracle database manually. Is there a solution/ command to start the database automatically when the machine is started/restarted?
Follow the below steps to get it done:
Open the registry with regedit. Always back up the registry before making changes. Navigate to the key
There will be a key called:
ORA_SID_AUTOSTART. SID is your database SID.
This key should be set to
TRUE. If not the server starts but does
not start the database. There is also an
ORA_SID_SHUTDOWNwhich you want to be
TRUEso that if the server is shut down the service will shutdown the database.
- If you want to manually start the database set
FALSE. The service will start but not the database.
on Windows system you have to use oradim.exe to admnister the Oracle instance behavior. This is the documentation: Using ORADIM to Administer an Oracle Database Instance
You have to check:
- if the Windows service exists (if not create it with oradim);
- how it is configured (using oradim)