Supported Databases

The following database types are supported for TIBCO iProcess Engine on Unix platforms:

Oracle Database
IBM DB2 Database

Oracle Database

The following table lists the versions of Oracle database that TIBCO iProcess Engine supports. Choose the appropriate version of Oracle client to use with a Oracle database server according to the operating system that you use.

Platform

Oracle Database (Server)

Required Oracle Client

Linux

Oracle 18c

Oracle 19c

19c or later

The exact Oracle version requirements depend on which of the following two types of database connections you intend to use:

a direct connection to the default database hosted on the computer where you will install or upgrade TIBCO iProcess Engine. For detailed information, see Direct Connection Requirements for Oracle.
a Transparent Network Substrate (TNS) connection, connected to either:
the default database hosted on the computer where you will install or upgrade TIBCO iProcess Engine, or to
a remote database, meaning a database that is either hosted on a remote computer, or a non-default database on the computer where you will install or upgrade iProcess Engine.

For more information, see TNS Connection Requirements for Oracle.

Note:

In some Oracle versions, Oracle files and directories are created with more restricted permissions compared to previous versions. If these default permissions are used, iProcess Engine does not have the necessary permissions to access the libraries that it needs in the $ORACLE_HOME directory, and so will fail to start.

To ensure that this problem does not occur, you need to modify the default permissions on the Oracle database server (for a direct connection) or client (for a TNS connection) home by running a changePerm.sh script.

If you run the installer as the root user, the installer may be able to run this script for you.

Direct Connection Requirements for Oracle

Direct Connection illustrates a direct connection from TIBCO iProcess Engine to the default Oracle database.

Figure 77: Direct Connection

When using a direct connection, you must set the ORACLE_HOME environment variable to the pathname of the Oracle Database.

TNS Connection Requirements for Oracle

When using a TNS connection, you must:

ensure that the remote Oracle database uses one of the Oracle Database releases specified in Required Oracle Database and Client Versions.
ensure that the correct Oracle Client release is installed on the computer where you will install or upgrade the iProcess Engine, as described in Required Oracle Database and Client Versions.

TNS Connection illustrates a TNS connection from TIBCO iProcess Engine to the default database.

Figure 78: TNS Connection

You need to:

set the ORACLE_HOME environment variable to the path name of the Oracle Client.
use the TNS name to connect the iProcess Engine to the Oracle Database. See Oracle Database Connection and Account Details Menu for details.

Required Oracle Database and Client Versions shows the required Oracle database and client versions when you use a TNS connection to the default database or to a remote database.

Required Oracle Database and Client Versions

Certified Database Release

Compatible Database Release

 

Client Release

Oracle 12c, 18c, 19c

12.2.0.x where x is 1 or higher

with

For Linux platform, the Oracle client must be 19c or later.

If you are using an Oracle version (Database or Client) that is:

earlier than the releases explicitly mentioned in the table above, you must upgrade to one of the specified releases.
later than the releases explicitly mentioned in the table above, contact TIBCO Support to confirm whether or not that release is supported by your iProcess Engine version.

Note 

You will need access to an Oracle Metalink account to be able to access the required patches and patch sets.

TIBCO iProcess Engine uses Oracle Call Interface (OCI) to access data in the Oracle database. For reasons of stability, TIBCO iProcess Engine is statically linked with the Oracle client libraries that provide the required OCI routines. Oracle only supports products that run against the same set of libraries they were built with. This means you must use particular Oracle Client versions, depending on the method you use to connect to the database.

If you are using Oracle Real Application Clusters (RAC), TIBCO recommends that you install the iProcess Engine on a machine that is not part of the RAC, and use a TNS connection to connect to the remote database.

IBM DB2 Database

The DB2 requirements depend on whether you intend to use a local or remote database with iProcess Engine:

A local database is a database that is hosted on the computer where you will install the iProcess Engine.

If you intend to use a local database:

You must have a DB2 Server installed on the computer where you will install or upgrade iProcess Engine.
The TCP/IP communications protocol must be enabled.
A remote database is a database that is hosted on a different computer to the one where you will install the iProcess Engine.

If you intend to use a remote database:

You must have a DB2 Runtime Client or Administration Client installed on the computer where you will install or upgrade the iProcess Engine.
The DB2 client must be configured to access the remote DB2 server using TCP/IP.

Note 

See your DB2 documentation for more information about how to install DB2 servers and clients, and how to configure communications between them.

The following table shows the required DB2 server and client versions.

Required DB2 Server and Client Versions

Platform

DB2 Version

Required Release Level

x64

DB2 Universal Database for Linux (Server and/or Client)

10.5, or 11.1