0

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?

  • Are you using grid infrastructure? if you are then your database should be registered with Oracle Restart which will automatically start database and its dependent components upon system reboot. – JSapkota Jan 15 '16 at 10:45
1

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 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\oracle_home_name.

    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_SHUTDOWN which you want to be TRUE so that if the server is shut down the service will shutdown the database.

  • If you want to manually start the database set ORA_SID_AUTOSTART to
    FALSE. The service will start but not the database.
  • ORA_SID_AUTOSTART is already set to TRUE.still facing the same issue. – Mahesh Oracle DBA Feb 26 '16 at 11:07
1

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.