Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.