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>
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.