We are currently using Oracle 11. We would like to use the tnsnames.ora and use a short url to have JIRA connect to the database.
An example of a shortURL is jdbc:oracle:thin:@DBNAME.WORLD
So a couple of questions:
Does JIRA require a port number and sid, which wouldn't be in a short URL.
Do I need to do anything special to get the tnsnames.ora on the classpath?
The solution was to go into the setenv.sh file located in the <jirahome>/bin directory and insert the following line.
JVM_SUPPORT_RECOMMENDED_ARGS="-Doracle.net.tns_admin=/oracle/network/admin"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.