Startup delay waiting for databases to come online

[Guillaume Leonard]

Hi,

We use JIRA Data Center (on-prem) with Oracle database servers. JIRA is hosted on a server while Oracle databases on another one.

When rebooting both servers (JIRA and Oracle), due to planned or unplanned maintenance, the JIRA server comes back much quicker than the Oracle one. This has the effect that JIRA service starts up much quicker and eventually complains that there is a database issue, since the database is not yet reachable. Once all databases are up, we must manually go into the Windows Services on the JIRA server and restart the JIRA service manually.

As said, JIRA is configured as a Windows Service on the JIRA server. We could configure the startup of the service to be a Delayed Startup, but in the case that Oracle databases are already available, I would like to JIRA to start as soon as possible.

Is there some sort of built-in mechanism to monitor the database server and in case it is offline, wait for x amount of time before giving up ? I actually would like to increase this "timeout" value at startup, if this is possible.

Thank you,

Guillaume.

[Tuncay Senturk _Snapbytes_]

Hi @Guillaume Leonard 

Welcome to the Community!

My two cents: manually start Oracle and Jira servers. Once Oracle is up, then start Jira server. I would not automate starting all servers at once.

If you need to automate the process, then I'd suggest a script which would run on startup, checking whether the database is up and starting Jira Windows service via CLI.