Confluence 2.6 : Database Setup for Oracle
This page last changed on Jun 18, 2007 by mryall.
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 setup by an Oracle database administrator. If you are not a DBA, you should not attempt this guide. Oracle has a history of being extremely difficult to setup. 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 InformationThis setup guide must be used in conjunction with the list of Known Issues For Oracle. Please review that page before continuing. Schema RequirementsConfluence 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 IncompatibilitiesOrcale 9i and later are supported, please upgrade any older versions prior to installing Confluence.
Please check that your version of Oracle does not have any known issues:
Deploying Against OracleComplete the instructions for installing Confluence standalone, then return to this document instead of proceeding to the Confluence Setup Guide. Database PreparationTailor these instructions to your particular database version:
Adding a Datasource to Tomcat
Configure Confluence Datasource AccessConfleunce must be configured to use this datasource:
Confluence Setup WizardNow Confluence is ready to attempt to connect to Oracle:
Confluence should now deploy using the Oracle database specified. Please read this comment on Oracle database optimisation. Generic Oracle Configuration TipsWebsphere and OracleIf 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 8iWe 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". |
![]() |
Document generated by Confluence on Oct 10, 2007 18:49 |