Preparing Oracle Database for Installation
This page describes how to use codeBeamer 8.0 or higher with an Oracle 12c database. To use this document you must be familiar with the Oracle database and with the database administration.
For the installation/migration you will need Oracle DBA permissions. IMPORTANT: Backup your data! Before doing anything, backup your existing database. Also ensure that nobody uses the database during migration, as this may result loss of data.
Prepare new Oracle Schema
It must be ensured that codeBeamer is not running.
Edit the configuration file: <cb-installation-dir>/config/configuration.properties
database.driver=oracle.jdbc.driver.OracleDriver
database.connectionURL=jdbc:oracle:thin:@//localhost:1521/ORCLCDB
database.username=user
database.password=pass
database.passwordStorageType=PLAIN
Start codeBeamer.
The database tables will be automatically created upon the first start of codeBeamer, so this first startup will take significantly longer than subsequent startups.
Upgrading an existing codeBeamer ORACLE database to a newer codeBeamer version
You must only configure the new codeBeamer installation to access the existing ORACLE database (see above). All necessary database upgrades are automatically executed when you start the new codeBeamer instance for the first time.
To migrate a codeBeamer schema from one ORACLE instance to another, export the schema from the old instance and import at the new instance. Then (re-)configure codeBeamer to access the new instance.
IMPORTANT: Backup your data! Before doing anything, backup your existing database. Also ensure that nobody uses the database during migration, as this may result in loss of data.
If you're upgrading an existing database, make sure the old codeBeamer installation is shut down.
After the upgrade, you cannot easily go back to the old codeBeamer version, because that will most probably not run with the upgraded database. The only safe way to revert the upgrade is to restore the old database from a backup.
When upgrading to version 10.0.x and above: Please make sure you execute the following command; it is necessary for data migration procedure, otherwise upgrading procedure will fail!
GRANT EXECUTE ON SYS.DBMS_CRYPTO TO {codeBeamer Database User}