How to setup TNS_ADMIN for JIRA installation

Question

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?

Anthony Galati1 · Accepted Answer

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"