Fill out the fields, as described in the Database connection fields section below. Oracle is difficult to set up. This determines which sys role you are using. You must add the ‘ as sysdba ‘ or ‘ as sysoper ‘ option if you are logging in with the user ‘ sys ‘. If you are evaluating Confluence, we recommend that you start with an alternative database and only consider migrating to Oracle after approval from your DBA.

Uploader: Yoran
Date Added: 6 February 2015
File Size: 32.16 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 71320
Price: Free* [*Free Regsitration Required]

By default, the confluebce is “oracle”:. If you are connecting via a datasource, or if you are using a database whose driver is not bundled, you will need to download and install the drivers manually.

Not sure how to find your hostname, port and SID? We’ll help you migrate to the Microsoft driver in a later release.

The JDBC 41 driver will work under the 1. Here are the configuration properties for Tomcat’s standard data source resource factory org. You will need to make the driver available to your application server, as described orac,e the appropriate setup guide.


Related content No related content found. For more information please refer to the Confluence 5.

Start Confluence, and go to the Confluence Setup Wizard in your browser. Yes No It wasn’t accurate.

This page provides the download links for the JDBC drivers for all databases currently jvbc for Confluence. Related content No related content found.

That means that if you do run into any problems, Atlassian Support may require you to move back to the above fully- tested version for troubleshooting. To do this, you will need to set the “validationQuery” option on the database connection pool.

When a database server reboots, or there is a network failure, all the connections in the connection pool are broken and this normally requires a application server reboot. Database setup for Convluence.

Database JDBC Drivers – Atlassian Documentation

Database setup for Oracle. Powered by Confluence and Scroll Viewport. Check the prerequisites Check the following before you start: The command completed successfully. Open a command prompt and run config. The user’s password — used to authenticate with the Oracle server. You can also use the tnsnames style. We recommend that you use the bundled JDBC 4 driver. If you are connecting via a datasource, or if you are using a database whose driver is not bundled, you will need to download and install the drivers manually.


The Atlassian Community is here for you. HibernateException] is not allowed.

Administering Jira applications Support

The Confluence setup wizard will guide you through the process of connecting Confluence to your database. For a list of supported databases, see Supported Platforms.

Direct JDBC is the most common way to connect Confluence to your database and is the easiest method when it comes time to upgrade Confluence. Before you begin Check whether your version of Oracle is supported. If you want to use other drivers, you can download it from the PostgreSQL oeacle. Do not grant the user the select any table permission.

Yes No It wasn’t accurate. This guide covers how to configure a JNDI datasource connection to your database.