Versions Compared

Version Old Version 1 New Version Current
Changes made by

Daniel (Deactivated)

Kevin Pham (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
Top
Top

Column

This section applies specifically to the Zephyr Enterprise being able to connect to an external database. The information below is generally used to ensure that system administrators can connect their Zephyr Enterprise to an Oracle database.


The Database for Zephyr Enterprise

...

Data Center will be referenced as part of the installation of Zephyr Enterprise

...

Data Center. It will need to be installed separately and prior to the installation of Zephyr Enterprise

...

Data Center. These instructions will help you connect your Zephyr Enterprise

...

Data Center installation to 

...

an Oracle

...

database.

Supported Databases

...

Oracle

    • Oracle Database Verions:
      • 11g
      • 12c
    • JDBC Driver Versions: Download JDBC here
      • 11g - 10.2.0.2 (ojdbc14.jar)
      • 12c - 12.1.0.2 (ojdbc7.jar)

...


Prerequisites

...

  • Check whether your version of Oracle is supported above
  • Download the JDBC and have this available on the application node where Zephyr Enterprise DataCenter Data Center is being installed
  • If you are Upgrading upgrading from Zephyr Enterprise 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 Enterprise DataCenter Data Center 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

...

The following steps will need to be followed:

Anchor
step1
step1

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

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)

...

Code Block
languagesql
themeEmacs
SELECT * FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET%';

...

Anchor
step2
step2

Step 2: Setup your database charset:

  1. shutdown immediate;
  2. startup restrict;
  3. select name from v$database;

  4. view code below:

    Code Block
    languagesql
    themeEmacs
    ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;


  5. view code below:

    Code Block
    languagesql
    themeEmacs
    SELECT value FROM NLS_DATABASE_PARAMETERS WHERE parameter=’NLS_CHARACTERSET’;


  6. shutdown immediate;
  7. startup;

Anchor
step3
step3

Step 3: Connect in SQL Developer:

Run Below Command for User creation:

...

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

  

  

Back to Top ^