Anchor Top Top
| Column |
|---|
The database for ZephyrEnterprisewill be referenced as part of the installation of ZephyrEnterprise. It will need to be installed separately and prior to the installation of ZephyrEnterprise. These instructions will help you connect your ZephyrEnterpriseinstallation to an Oracle database. |
Supported Databases
...
Oracle
...
- Check whether your version of Oracle is supported above
- Download the JDBC and have this available on the application node where Zephyr Enterprise is being installed
- If you are 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 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
...
The following steps will need to be followed:
- Step 1: After installation, Set Collation and DB Parameters
- Step 2: Setup your database charset
- Step 3: Connect in SQL Developer
Anchor step1 step1
| step1 | |
| step1 |
Step 1: 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; |