...

Supported Databases

...

Oracle

• Check whether your version of Oracle is supported above
• • Oracle Database Versions.
    
    • 12c, 19c
  • JDBC Driver Versions. Download JDBC: Here
    
    • 12c - 12.1.0.2 (ojdbc7.jar)

Prerequisites

• • • 19c - 19c (ojdbc7.jar)

Prerequisites

• Download the JDBC and have this available on the application node where Zephyr is being installed
• If you are upgrading from Zephyr 4.8, a MySQL Database will already be present. For migrating from MySQL to Microsoft SQL Server, please review the database migration process.
• Have the Zephyr installer ready
• Have a fresh installation of Oracle ready
• Some of the instructions below will use Oracle SQL Developer to illustrate the steps, however, it is not required

Configure the Oracle Database

...

Step 1: After installation, Set Collation and DB Parameters:

Default The default collation is Binary for Oracle and the one that is supported. The following query can be used to validate the collation for the user(database)

...

Type: sqlplus
Enter USER Name: sys/sysdba
Enter Password: *******

Run the below commands for Oracle database parameters setup:
Oracle must be setup with AL32UTF8 parameter to support UTF-8 characters and before installation is done. To check your charset setting:

...

SELECT * FROM DBA_DATA_FILES;
ALTER DATABASE DATAFILE '<example>/u01/app/oracle/oradata/XE/system.dbf<example>' AUTOEXTEND ON MAXSIZE UNLIMITED;