How to configure JIRA with Oracle RAC DB?

[Patrick Toma]

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>

[AndreyevM]

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!