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)
- Oracle Database Verions:
...
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
...
After installation, Set Collation and DB Parameters:
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT * FROM DBA_DATA_FILES; ALTER DATABASE DATAFILE '<example>/u01/app/oracle/oradata/XE/system.dbf<example>' AUTOEXTEND ON MAXSIZE UNLIMITED; |