This server will be upgraded at 3pm Sydney time on December 3rd (December 2nd, 8pm PST) and will be down for up to 30 minutes.
This documentation relates to the latest version of Confluence.
If you are using an earlier version, please go to the documentation home page and select the relevant version.

Database Setup for Oracle

Added by David Soul [Atlassian], last edited by Roy Hartono on Dec 01, 2008  (view change)
All Versions
Click for all versions
Confluence 2.10 Documentation

Index

This guide covers deploying Confluence standalone 2.2 or later against an Oracle database, and is also applicable to the WAR version. For older Confluence versions, please follow these instructions.

This database can only be set up by an Oracle database administrator. If you are not a DBA, you should not attempt to set up this database.

Oracle has a history of being extremely difficult to set up. If you do not have access to an experienced Oracle DBA in your organisation, you are recommended to select any free, scalable and easy-to-install alternative rather than proceeding with Oracle. Users evaluating Confluence are recommended to start with an alternative database and only consider migrating to Oracle after approval from their DBA. Atlassian's technical support for Oracle setup difficulties will also reflect the high minimum skill requirements for attempting an Oracle setup.

Database Setup Information

This setup guide must be used in conjunction with the list of Known Issues For Oracle. Please review that page before continuing.

Schema Requirements

Confluence must be deployed to a schema in it's own, separate Oracle instance. This avoids a Hibernate bug triggered by the existence of duplicate tablenames in other schemas, outlined here.

Database Incompatibilities

Orcale 9i and later are supported, please upgrade any older versions prior to installing Confluence.

Database driver update may be required
For all versions of Oracle, you must upgrade to the latest 10g drivers. Check the latest compatibility matrix before proceeding to the JDBC download page. We highly recommend to use the thin drivers.

Please check that your version of Oracle does not have any known issues:

Oracle Version Oracle Driver Issue Solution
Any Pre 10g Driver incompatibilities Upgrade to latest 10g drivers if compatible
Pre 9 Any Earlier DBs not compatible Upgrade DB to 9.x or later
9.0.1.0 Any DB not compatible Upgrade DB to 9.0.2.6 or later
10g 10.1.0.3.0 Drivers not compatible with Tomcat 5.5 Upgrade drivers to 10.1.0.4.0 or later

You might be also interested in a relevant JIRA documentation to check the compatibility of your Oracle server and driver.

Deploying Against Oracle

Complete the instructions for installing Confluence standalone, then return to this document instead of proceeding to the Confluence Setup Guide.

Database Preparation

Tailor these instructions to your particular database version:

  1. Perform any necessary database or driver upgrades. Download the latest compatible database drivers

  2. Create a separate instance of Oracle and apply any configuration tasks.

  3. Create a Confluence user configuration and grant access permissions.

Adding a Datasource to Tomcat

  1. Open <INSTALL>/conf/server.xml for editing.

  2. Locate the section Host -> Context
    <Host name="localhost" debug="0" appBase="webapps" unpackWARs="true" autoDeploy="false">
    <Context path="" docBase="../confluence" debug="0" reloadable="true">
         <!-- Logger is deprecated in Tomcat 5.5. Logging configuration for Confluence is specified in confluence/WEB-INF/classes/log4j.properties -->
         <Manager pathname="" />
    </Context>
</Host>
  3. Paste in the Resource section provided, prior to Manager as shown 
    <Host name="localhost" debug="0" appBase="webapps" unpackWARs="true" autoDeploy="false">
    <Context path="" docBase="../confluence" debug="0" reloadable="true">
         <!-- Logger is deprecated in Tomcat 5.5. Logging configuration for Confluence is specified in confluence/WEB-INF/classes/log4j.properties -->

         <Resource
         name="jdbc/confluence"
         auth="Container"
         type="javax.sql.DataSource"
         driverClassName="oracle.jdbc.driver.OracleDriver"
         url="jdbc:oracle:thin:@hostname:port:sid"
         username="<username>"
         password="<password>"
         connectionProperties="SetBigStringTryClob=true"
         maxActive="25"
         maxIdle="5"
         maxWait="10000"
         />

         <Manager pathname="" />
    </Context>
</Host>
  4. Change the username and password to match the Oracle login.

  5. Change url to match hostname, port and sid of the Oracle server. Sid stands for the schema name. For example: 
    jdbc:oracle:thin:@example.atlassian.com:1521:confluencedb
  6. If required, choose different maxActive and maxIdle values. These set how many total database connections will be allowed at one time, and how many will be kept open even when there is no database activity.

Configure Confluence Datasource Access

Confleunce must be configured to use this datasource:

  1. Edit the file <INSTALL>/confluence/WEB-INF/web.xml

  2. Go to the end of the file and just before </web-app>, insert the following: 
    <resource-ref>
<description>Connection Pool</description>
<res-ref-name>jdbc/confluence</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
  3. Locate the Oracle JDBC database drivers for JDK 1.4, which comes bundled with your database. We recommend using the thin drivers only. Copy ojdbc14.jar to the <INSTALL>/common/lib directory.

Confluence Setup Wizard

Now Confluence is ready to attempt to connect to Oracle:

  1. Startup Confluence using <INSTALL>/bin/startup.bat or <INSTALL>/bin/startup.sh

  2. Insert your licence and select External Database.

  3. Select Datasource Connection using your Oracle version.

  4. Enter java:comp/env/jdbc/confluence for the name of the datasource.

Confluence should now deploy using the Oracle database specified. Please read this comment on Oracle database optimisation.

Generic Oracle Configuration Tips

Websphere and Oracle

If you are planning to run Confluence on a Websphere application server and Oracle database, you should read the information on Known Issues for Websphere.

24-hour time format with Oracle 8i

We have received a report from a user that when an Oracle 8i database is configured to use 24-hour time as the default format, an exception like this may occur:

005-12-06 13:23:20 Loading root WebApplicationContext

2005-12-06 13:24:34 StandardContext[]: Exception sending context initialized event to listener instance
of class com.atlassian.confluence.util.ConfluenceContextLoaderListener

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userAccessor' defined in class path resource [applicationContext.xml]:
Can't resolve reference to bean 'userAccessorTarget' while setting property 'target';
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userAccessorTarget' defined in class path
resource [applicationContext.xml]: Can't resolve reference to bean 'spacePermissionManager' while setting property 'spacePermissionManager';
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'spacePermissionManager' defined in class path resource [securityContext.xml]:
Can't resolve reference to bean 'spacePermissionManagerTarget' while setting property 'target';
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'spacePermissionManagerTarget' defined in class path resource [securityContext.xml]: Initialization of bean failed;
nested exception is org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [Cannot create PoolableConnectionFactory];
nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

...

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause:


java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1


ORA-12705: invalid or unknown NLS parameter value specified

One symptom of this problem is that Confluence may refuse to start after midday.

The workaround is to go to 'General Configuration' and set the default time format to "HH:mm".

Labels

database database Delete
oracle oracle Delete
install install Delete
oracle-setup oracle-setup Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Comments (7)

 

  1. Dec 14, 2006

    Jeff Guthrie says:

    Is there anywhere that the database schema of Confluence is documented, like JIR...

    Is there anywhere that the database schema of Confluence is documented, like JIRA's here?

  2. Dec 14, 2006

    David Chui says:

    Unfortunately, there is no such documentation about the Confluence database sche...

    Unfortunately, there is no such documentation about the Confluence database schema. However, you may use a database tool to extract an entity relationships diagram from the Confluence database tables. For example, you can use DbVisualizer for that.

  3. Aug 17, 2007

    Shane Witbeck says:

    From the Tomcat docs on setting up an Oracle datasource (the deprecated driver i...

    From the Tomcat docs on setting up an Oracle datasource (the deprecated driver is referenced above):
    For Oracle 9i onwards you should use oracle.jdbc.OracleDriverrather than oracle.jdbc.driver.OracleDriver as Oracle have stated that oracle.jdbc.driver.OracleDriver is deprecated and support for this driver class will be discontinued in the next major release.

  4. Oct 18, 2007

    Anonymous says:

    What edition of the Oracle database is compatible with Confluence, Enterpri...

    What edition of the Oracle database is compatible with Confluence, Enterprise Edition or Standard Edition?

  5. Apr 14, 2008

    Carter M. Snowden says:

    In upgrading from 2.5.4 to 2.8.0 (using Tomcat 5.5) I found it necessary to add....

    In upgrading from 2.5.4 to 2.8.0 (using Tomcat 5.5) I found it necessary to add..
    validationQuery="select 'validationQuery' from dual"
    ..to the Context section (in step 3 of 'Adding a datasource to Tomcat').

    Without that, things would fail with 'Cannot get a connection, pool exhausted" errors.

    1. Apr 15, 2008

      Mei Yan Chan says:

      Hi Carter, I've put forward a request to update the documentation at: http:/...

      Hi Carter,

      I've put forward a request to update the documentation at:

      Feel free to add your comment there. Thanks.

      Regards,
      Mei

  6. Jul 23

    Chris Hyzer says:

    Is it still the case that confluence for oracle has to be installed on its own o...

    Is it still the case that confluence for oracle has to be installed on its own oracle instance???  I have never heard of that and have used hibernate extensively.  Jira does not have that constraint, right?

Add Comment