How to connect to a DB with a service name?

BrianB April 1, 2014

I have followed the instructions for "https://confluence.atlassian.com/display/JIRAKB/How+to+Connect+JIRA+to+ORACLE+Using+Service+Name" but it did not work because the SID is not the same across the servers. Atlassian support is not sure the article would apply with different SIDs. Is this possible?

2 answers

1 accepted

1 vote
Answer accepted
Andris Grinbergs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2014

What do you mean with "SID is not the same across the servers"? Do you have more than 1 database server?

BrianB April 1, 2014

becausewehave4differentservershostingtheDBsnow

iftheloadononeserverisoverload

systemwillpickupsomeDBsandmovetoanotherserverwhichhasmorecapacityatthattime

SO the SID could change

Andris Grinbergs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2014

It seams like Oracle thin java client can't do this "magic". It seams you should then install full oracle client on Jira server. And use similar option in Jira tomcat:

-Doracle.net.tns_admin=$ORACLE_HOME/network/admin

Probably you should read this article carfully: http://docs.oracle.com/cd/B19306_01/java.102/b14355/urls.htm

Andris Grinbergs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2014

Try following syntax in dbconfig.xml <url> section:

jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=service_name)))"

After @ you should write service name database definition from your tnsnames.ora

0 votes
BrianB April 22, 2014

This worked! Sorry for the delay, been busy with projects. Thanks for your advice

Suggest an answer

Log in or Sign up to answer