Oracle Configuration Options

You can use your existing Oracle database with the 3DOrchestrate Distribution Server.

The 3DOrchestrate Distribution Server application can use the same Oracle database/instance as the 3DSpace Service; however, they must have separate database user accounts for the different schemas. The 3DOrchestrate Distribution Server application can also use a local Oracle database that is on the same machine.

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.