nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to connect to a DB with a service name?

BrianB

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?

Accepted answers

Andris Grinbergs

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

All comments

Andris Grinbergs

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

BrianB

becausewehave4differentservershostingtheDBsnow

iftheloadononeserverisoverload

systemwillpickupsomeDBsandmovetoanotherserverwhichhasmorecapacityatthattime

SO the SID could change

Andris Grinbergs

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

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

BrianB

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