Do not grant the user the select any table permission. The JDBC 41 driver will work under the 1. Not sure how to find your hostname, port and SID? Navigate to the Database tab and set Database type to Oracle. Database setup for MySQL. The Confluence setup wizard will guide you through the process of connecting Confluence to your database.

Uploader: Vujin
Date Added: 23 March 2010
File Size: 17.43 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 20069
Price: Free* [*Free Regsitration Required]

Once logged in, you can type arbitrary SQL commands. However, later versions are technically not supported. The database URL is entered in this format: All our testing is done on that version. Database setup for Oracle.

Related content No related content found.

Connecting Jira applications to Oracle – Atlassian Documentation

By default, the user is “oracle”:. Service “XE” has 1 instance s. At this point, you should:. Yes No It wasn’t accurate. Here are the configuration properties for Tomcat’s standard data source resource factory org. The Atlassian Confluehce is here for you.


For more information please refer to the Confluence 5. If you do not already have an operational Oracle database server, pracle the installation package from the Oracle download page and follow the instructions in the Oracle documentation.

Xonfluence to licensing constraints, we are not able to bundle MySQL or Oracle database drivers with Confluence, so you will need to manually download and install the driver listed below before you can set up Confluence. Administering Jira applications 7.

Confluence Support

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 MySQL.

With this type of connection, Confluence asks the application server Tomcat for your database connection information. That permission can cause problems with other schemas. We recommend that you use the bundled JDBC 4 driver. Configure the connection pool and other properties. For a list of supported databases, see Supported Platforms.

If you forget to do these steps, Confluence will not start up after upgrade and you’ll see the following error:. Not sure how to find your hostname, port and SID?


Administering Jira applications Support

The JDBC 41 driver will work under the 1. We recommend you use the bundled jTDS driver. The command completed successfully. Both Password This is the password for your dedicated database user.

Direct JDBC is the most common confluene to connect Confluence to your database and is the easiest method when it comes time to upgrade Confluence. You’ll need an experienced Oracle database administrator DBA to set up and maintain your database. This is the username of your dedicated database user. Powered by Confluence and Scroll Viewport. Open a console and execute config. If you didn’t change the confuence when you installed Oracle, it will default to