Oracle Database Connection and Account Details Menu

The Oracle Database Connection and Account Details menu is shown :

Installing TIBCO iProcess Engine version 11.8.0
 
ORACLE Database Connection and Account Details
 
1 ) Oracle DB TNS Identifier                 : 
2 ) Oracle DB Administrator Name             : system
3 ) Oracle DB Administrator Password         : 
4 ) iProcess Engine DB Schema Owner Name     : swpro
5 ) iProcess Engine DB Schema Owner Password : staffpro1
6 ) iProcess Engine DB User Name             : swuser
7 ) iProcess Engine DB User Password         : swuser1
8 ) Support Unicode Encoding                 : N
9 ) Data Tablespace Name                     : STAFFWAR
10) Temporary Tablespace Name                : TEMP
11) Schema Sizing Configuration              : Small
 
Enter number of item to edit, (C)ontinue, (B)ack or (Q)uit:

Configuration Items in the Oracle Database Connection and Account Details Menu lists the configuration items in the iProcess Email Plug-in Configuration Menu.

Configuration Items in the Oracle Database Connection and Account Details Menu

Item

Description

Oracle DB TNS Identifier

The TNS identifier of the Oracle instance that the iProcess Engine will connect to.

Oracle DB Administrator Name

The Oracle username that the iProcess Engine should use when it needs to connect to the database as a DBA.

Oracle DB Administrator Password

The password for the Oracle DBA account.

iProcess Engine DB Schema Owner Name

The name of the Oracle user that owns the iProcess Engine database schema.

Note: If you are using Oracle 12c, you must specify the name with the prefix, c##. For example, c##swpro.

iProcess Engine DB Schema Owner Password

The password for the iProcess Engine database schema owner.

iProcess Engine DB User Name

The name of the user that the iProcess Engine uses to access the iProcess Engine database schema. This user has the REFERENCES, SELECT, DELETE, and UPDATE permissions.

Note: If you are using Oracle 12c, you must specify the name with the prefix, c##. For example, c##swuser.

iProcess Engine DB User Password

The password for the iProcess Engine database user.

Support Unicode Encoding

Whether the iProcess database should support UTF-8 encoding.

Data Tablespace Name

The tablespace in which to create the iProcess Engine database schema.

Note: This menu item is only displayed if you are installing a new iProcess Engine. It is not displayed if you are upgrading an existing installation.

Temporary Tablespace Name

The temporary tablespace associated with the iProcess Engine database schema and users.

Note: This menu item is only displayed if you are installing a new iProcess Engine. It is not displayed if you are upgrading an existing installation.

Temporary Tablespace Name

The tablesizes configuration file to be used to size the iProcess Engine database schema.

Note: This menu item is only displayed if you are installing a new iProcess Engine. It is not displayed if you are upgrading an existing installation.

Edit the configuration items if needed and then enter C. For more information, see Checking DB Connectivity and Users.