...
Note | ||
---|---|---|
| ||
In a High Availability environment, each cluster node connects to the same database. |
Anchor | ||||
---|---|---|---|---|
|
Database Permissions
In order to install or perform upgrades of Universal Controller, the database user configured for the Controller will require DDL (Data Definition Language) permission in the database during the install or upgrade.
...
Anchor | ||||
---|---|---|---|---|
|
MySQL
Note | ||
---|---|---|
| ||
MySQL versions 5.7.x and 8.0.x are supported. |
...
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html
Anchor | ||||
---|---|---|---|---|
|
Microsoft SQL Server
Note | ||
---|---|---|
| ||
Microsoft SQL Server versions 2014, 2016, 2017, and 2019 are supported. |
...
Note | ||
---|---|---|
| ||
Universal Controller automatically appends the When set to false, the Unicode translation property specifies that prepared parameters for character data are sent as ASCII or Multi-byte Character Set (MBCS) instead of Unicode. jdbc:sqlserver://localhost:1433;databaseName=uc;sendStringParametersAsUnicode=false |
Anchor | ||||
---|---|---|---|---|
|
Oracle
Note | ||
---|---|---|
| ||
Oracle versions 19c and 21c are supported. |
...
Step 1 | Download and install Oracle as per the Oracle documentation. |
---|---|
Step 2 | Create the Controller database. You can use any legal name, but we recommend the name uc. |
Step 3 | Make a note of the userid and password to be used later when installing the Controller. |
If PDB (Pluggable Database) is being used for the Oracle Controller database, the JDBC URL should be used in EZCONNECT format and point to the PDB service, not the database SID.
For example:
jdbc:oracle:thin:@//dbhost:1521/pdbuc.userdomain
Oracle Options
The following enhancements can be made to your Oracle database.
...