Confluence 4.0 : Database Setup for Oracle
This page last changed on Sep 01, 2011 by edawson.
This guide covers deploying Confluence standalone or WAR distribution with an Oracle 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 InformationThis setup guide must be used in conjunction with the list of Known Issues For Oracle. Please review that page before continuing. Schema RequirementsConfluence can be deployed to a schema in any Oracle instance. Database CompatibilityPlease refer to Supported Platforms for information about supported database versions. If your version of Oracle is not supported, please upgrade to a supported version before installing Confluence. Check your database drivers, to see if you need an update.
Tip: search for the jar filename on the download site. Check that your version of Oracle does not have any known issues:
You may be also interested in the relevant JIRA documentation to check the compatibility of your Oracle server and driver. Deploying Confluence with 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:
Do not grant the database user the Adding a Datasource to Tomcat
Configuring Confluence Datasource AccessConfigure Confluence to use this datasource:
Running the 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. Oracle Configuration Tips24-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". RELATED TOPICS |
![]() |
Document generated by Confluence on Sep 19, 2011 02:46 |