Documentation for JIRA 4.4. Documentation for other versions of JIRA is available too.
These instructions will help you connect JIRA to an Oracle 10g or 11g database. Oracle 9i is no longer a supported database for use with JIRA and the 11.2.x drivers from Oracle do not support 9i.
Please note that a number of the Oracle server versions cannot be used with JIRA or are inherently unstable. The known issues with Oracle servers are as follows:
If you are Migrating JIRA to Another Server, create an export of your data as an XML backup. You will then be able to transfer data from your old database to your new database, as described in Switching databases.
On this page:
jiradbuser
). Remember this database user name, as it will be used to configure JIRA's connection to this database in subsequent steps.create user <user> identified by <user_pass> default tablespace <tablespace_name> quota unlimited on <tablespace_name>;
grant connect to <user>; grant create table to <user>;
Skip this step if you are using JIRA Standalone distribution. JIRA Standalone includes the Oracle JDBC driver.
ojdbc5.jar
for JDK 1.5, ojdbc6.jar
for JDK 1.6) to the lib/
directory.Please note that a number of the Oracle JDBC driver versions cannot be used with JIRA or are inherently unstable. The known issues with Oracle drivers are as follows:
There are two ways to configure your JIRA server to connect to your Oracle database:
Please Note:
The JIRA Configuration Tool is only available with JIRA Standalone.
config.bat
in the bin
subdirectory of the JIRA Installation Directory.config.sh
in the bin
subdirectory of the JIRA Installation Directory. Please Note: You may need to set the JAVA_HOME
environment variable to run the JIRA Configuration Tool. See Installing Java for details.
To connect JIRA to Oracle using the JIRA Configuration Tool:
dbconfig.xml
file in your JIRA Home Directory.<connection-properties>SetBigStringTryClob=true</connection-properties>
element to your dbconfig.xml
file), these custom settings will be deleted upon clicking the 'Save' button and you will need to reinstate them manually.Congratulations — you have finished! Proceed to 'Next Steps' below.
dbconfig.xml
file at the root of your JIRA Home Directory.Please Note:
Ensure that the <database-type/>
element's content specifies your type of database, as shown below. If you forget to do this and you start JIRA, your database tables may be created incorrectly. Refer to our Incorrect database type specified documentation if this happens to you.
dbconfig.xml
file, escape any '&
' characters by adding 'amp;
' to the end of each one.
<?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <delegator-name>default</delegator-name> <database-type>oracle10g</database-type> <schema-name></schema-name> <jdbc-datasource> <url>jdbc:oracle:thin:@<hostname>:<port number>:<SID></url> <driver-class>oracle.jdbc.OracleDriver</driver-class> <username>jiradbuser</username> <password>[enter db password]</password> <pool-size>15</pool-size> </jdbc-datasource> </jira-database-config>
<url/>
element's content might look similar to — jdbc:oracle:thin:@dbserver:1521:ORCL
dbconfig.xml
file (at the root of your JIRA Home Directory).Please Note:
<connection-properties>SetBigStringTryClob=true</connection-properties>
as a child of the </jdbc-datasource>
element in your dbconfig.xml
file. Adding this connection property may overcome these problems. Be aware that you will need to restart JIRA for this setting to take effect.
You should now have JIRA configured to connect to your Oracle database. The next step is to start it up!
Please see JIRA and Oracle.