Choose your language

Choose your login

Contact us

Configuring Oracle (and Oracle Express Edition)

This page applies to:

Oracle is a high-end database solution that provides a very robust and scalable data storage solution. And with the release of Oracle Express Edition, it is available at no cost, but it does have some limitations that should not impact PaperCut NG/MF installations.

PaperCut NG/MF supports Oracle versions 9.2 and higher. Oracle 8 (and earlier) are not supported because they did not support the TIMESTAMP datatype required by PaperCut NG/MF.

Database driver

PaperCut NG/MF does not ship with a driver for Oracle because Oracle does not allow us to redistribute the driver. Also, the recommended driver depends on the version of Oracle used. You can obtain these drivers from the Oracle website as described below.

 

To download the required version of the driver:

  1. Visit the Oracle web site here: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

  2. Select the appropriate Oracle version.

    The required file to download differs depending on the Oracle version.

  3. Download the relevant ojdbc.jar for your Oracle Database version.

  4. Copy the downloaded file into the [app-path]\server\lib-ext directory.

  5. Restart the service PaperCut Application Server. This allows PaperCut to find and load the driver.

Once the driver is installed into PaperCut NG/MF, you can follow the standard upsizing procedure. For more information, see Upsize to an external database (RDBMS) .

What’s next?

If you’re in the process of migrating to the external database for the first time, head over to continue with the steps (Step 5: Change the PaperCut NG/MF connection details) from our Upsize to an external database (RDBMS) article.

If you’ve already migrated (and changed the connection details as documented in Upsize to an external DB ) and are looking to confirm that the PaperCut Application Server is pointing to the external database successfully, you can check this using the system information in the PaperCut admin interface.

Navigate to the About tab > System info > Database, and you’ll see the type of database server listed. Database: Internal indicates that the App Server is still using the Internal ‘derby’ database, whereas Database: Oracle indicates it’s using an Oracle DB Server.

Comments