The 3DOrchestrate deployment utility has two modes of operation for Oracle databases:
- Oracle
In this default mode the deployment utility handles most of the database configuration for you. If the Oracle database is located on the same machine as the 3DOrchestrate Distribution Server, the deployment utility can start and stop the database server software. If the database is on a different machine on your network, you can provide the Oracle SYS as SYSDBA
password to allow the deployment utility to create the schema user, create the database tables, and configure the schema.
If the Oracle database is located on a different machine on your network, the machine on which you install the 3DOrchestrate Distribution Server must have the Oracle client—specifically, the SQLPLUS utility and the Oracle JDBC driver file are needed.
- Oracle Pre-Configured
- In this mode you configure the database schema by hand before running the deployment utility. You do not need to give the Oracle
SYS as SYSDBA
password in the deployment utility.
You choose the database configuration mode in the General Settings tab of the deployment utility.
The Oracle database character set must be set to AL32UTF8
and NLS_NCHAR_CHARACTERSET
must be set to AL16UTF16
. If Oracle is installed on Linux, it should be installed as the same (non-root) user that is used to install the 3DOrchestrate Distribution Server; this allows the deployment utility to create a tablespace.