Changing DB for jira DC on Azure

[Ramakrishna Grandhi]

Hi atlassian team, I've a setup jira dc environment on azure with sql server as DB, from template given by atlassian. Everything works fine so far. Now i want to change DB to oracle.

Can you help me understand where can i find dbconfig.xml for this environment? i.e. which azure resource will have this file or on which machine i can run Jira configuration tool?

Below are the resources i could see in the azure resource group and i'm following instructions given in this page: https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-oracle-938846856.html

[Robert Wen_Cprime_]

Hello @Ramakrishna Grandhi !

There will be a copy of dbconfig.xml in the Jira home directory of each node in your jiracluster VM set.

[Ramakrishna Grandhi]

Thank you @Robert Wen_Cprime_,

[Ramakrishna Grandhi]

@Robert Wen_Cprime_ 

I dont find config.sh in the install directory of the node. Will it work if i edit below shown dbconfig.xml manually? i mean both.

[Robert Wen_Cprime_]

So, normally on Jira installations there are two directories: a Jira home directory (typically underneath /var) and the Jira install directory (typically under /opt/atlassian).

config.sh would be in a /bin directory under the Jira install directory.

dbconfig.xml would be in the Jira home directory.

You could directly edit the dbconfig.xml file.  Just to be safe, you should edit both instances.

[Ramakrishna Grandhi]

Thank you @Robert Wen_Cprime_ 

I've run config.sh , test connection was successful. And then i restarted node from azure portal, so that jira could pick these changes. After restart, these are the contents

But jira goes down completely, like below.

can you please tell me how can i fix this?

[Ramakrishna Grandhi]

Interestingly it is showing database-type as oracle10g, though i've installed 19c

[Robert Wen_Cprime_]

If you're sure you've followed all the steps (including putting the new jdbc jar file on all the nodes), maybe you should contact Atlassian Support.

https://support.atlassian.com/contact/#/

[Ramakrishna Grandhi]

Thank you, i've filed this ticket, https://getsupport.atlassian.com/servicedesk/customer/portal/35/CA-1615128
Hope someone will address it.