How to configure JIRA with Oracle RAC DB?

Patrick Toma February 29, 2012

Hi we are trying to connect a new JIRA 5 install to Oracle 10G RAC server.. it is able to connect if I give it an instance name in the SID, but not the service name.

Do you have documentation of the proper way to configure JIRA to talk to Oracle RAC?

Thanks,
Patrick

<jira-database-config>

<name>defaultDS</name>

<delegator-name>default</delegator-name>

<database-type>oracle10g</database-type>

<schema-name></schema-name>

<jdbc-datasource>

<url>jdbc:oracle:thin:@orac6n1-vip.pd.wdh.intuit.com:1521:JIRA011</url>

<driver-class>oracle.jdbc.OracleDriver</driver-class>

<username>jiradbuser</username>

<password>jiradbuser</password>

<pool-size>15</pool-size>

</jdbc-datasource>

</jira-database-config>

1 answer

1 vote
AndreyevM March 1, 2012

I never tried this with JIRA 5, but in earlier versions (3.x and 4.x) worked fine to me. In atlassian/application-data/jira/dbconfig.xml I writed:

...
<database-type>oracle10g</database-type>
<schema-name></schema-name>
...
<url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dbsid)))</url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<username>dbusername</username>
<password>dbpass</password>
<pool-size>15</pool-size>
...

HIH!

Suggest an answer

Log in or Sign up to answer