[FishEye Knowledge Base]
To switch to an Oracle database, install Oracle and follow the steps below. When they are used together, FishEye and Crucible share the same external database.
Please note that during the migration of database servers, the FishEye/Crucible instance will not be available to users or to external API clients.
Oracle support for FishEye/Crucible and Crucible was introduced in version 2.5.0. In order to migrate to Oracle, your instance must be currently running at least version 2.5. If you are running an older version, then you will be required to first upgrade FishEye/Crucible and then migrate.
.jarfile from the Oracle website (http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html) and copy the
.jarfile to your
FISHEYE_INST/libdirectory (create the
lib/directory if it doesn't already exist). Move the existing JDBC
.jarfile to another location (and back it up). Restart FishEye/Crucible to have it pick up the new driver.
AL32UTF8encoding otherwise you may see encoding issues in the product.
Ensure the database user has CREATE TABLE, CREATE SEQUENCE and CREATE TRIGGER permissions in addition to the read/write permissions to the database.
In order to migrate to a different database backend, you must create a backup of sql data, configure the database and finally import the data via a backup restoration process. This can be done from either the FishEye/Crucible administration console, which streamlines the process, or via the command line tool which FishEye/Crucible provides.
Databasepage in FishEye/Crucible's Administration console.
To log in to the Admin area, you can either:
HOSTNAMEis the name of the server on which you installed Fisheye.
Once logged in as an administrator you can also get to the Admin area by clicking the 'cog' menu in the FishEye/Crucible header, and choosing Administration.
Oraclefrom the database type
Test Connectionto validate the values
.jarfile in the classpath (by placing the
FISHEYE_INST/lib). Also, ensure that the database user can log in to the database from the machine that FishEye/Crucible is running on and that all the required privileges are present.
sqldata from the FishEye/Crucible instance. Information on how to create a backup can be found at Backing up and restoring FishEye data \ Backing up and restoring Crucible data
Run the following command from the
<FishEye installation directory>/bin directory