Oracle DB Does Not Always Start Up Automatically After a Server Reboot in Windows

Sometimes oracle server processes not fully started automatically after a Server Reboot in Windows and you got ora-1017 in application event logs

Steps to Troubleshoot

  • Increase the time out parameter in the registry: ORA__SHUTDOWN_TIMEOUT
  • Although the parameter name indicates shutdown, this parameter controls the timeout for STARTUP as well as SHUTDOWN.
  • The default setting is 90. Changing it to 180 usually works.
  • Increasing the timeout to a longer value enables the server initialization processes to complete and allow the instance to get started