How to configure Jira with Oracle Exadata using service names?

[John M]

I am fairly experienced with these upgrades but the Jira 4.4 dbconfig.xml setup does not include an option to pass an Oracle service_name. My DBA says the DB URL string format is passing the SID as the service name and we need to pass that differently somehow. I have not found in my searches any other options I can add to dbconfig.xml. Here is my error each time, whether I use the UI or manual config. Regards, John

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)

I may have worked around this issue but still testing. The example uses colon SID but I found Bamboo config (very different) uses slash which may be working now. Using the Atlassian-provided example was throwing me off. This one seems to work.

<url>jdbc:oracle:thin:@uprd-scan.researchnow.com:1521/rnmlprd_jira</url>

[John M]

Answer included, dbconfig.xml needed forward slash in front of SID and not colon. Tried this after looking at working Bamboo and Confluence installs. Example should be updated on Atlassian site, I had a vendor support ticket for this as well.