iProcess Engine DB Schema Owner Name

Description

The name of the Oracle user (for Oracle users) or the UNIX account (for DB2 users) that owns the iProcess Engine database schema.

Note	For Oracle users, you can either create this account before you run the installer, let the installer create it for you, or create it after you have run the installer. See How Do I Decide Which Oracle Database Creation Method to Use.

Installation Type		New Installation	Upgrade Installation
Value	Oracle	An Oracle account name that: —is between 1 and 20 characters long. —contains only lowercase, alphanumeric, and underscore (_) characters. —has a leading alphanumeric character.	The name of the existing iProcess Engine database schema owner, taken from the second entry (after the first backslash character) on line 9 of the `$SWDIR/etc/staffpms` file. You cannot change this value.
Value	DB2	A UNIX account name that: —is between 1 and 8 characters long. —contains only alphanumeric and underscore (_) characters. —has a leading alphanumeric character. —is a member of the `DB2 SYSADM_GROUP OS` group.
Default Value		`swpro`
Node Cluster		If you are installing a slave server, the account name used must be the same name used on the master server. (Conversely, if you are installing separate instances of iPE in the same database then the schema owners must be different.)

The Oracle account name used must have the following permission grants:

• connect

• resource

• create table

• create view

• AQ_ADMINISTRATOR_ROLE

• query rewrite

• execute on dbms_aqadm

• execute on dbms_aq

Warning

If you create this Oracle account before running the installer (see Creating Oracle Accounts and Tablespaces), you must also associate the account with the data tablespace (see Data Tablespace Name) and temporary tablespace (see Temporary Tablespace Name) to be used by the iProcess Engine.

If the account name you specify does not already exist, you are prompted to create it when you continue from the Oracle Database Connection and Account Details Menu. For example:

iProcess Engine DB Schema Owner (swpro001) does not exist.
Create user (Y/N - default N): Y

If you enter:

• Y, the user is flagged for creation and the new username is displayed in the menu.

• N, the old name is shown.

Note	The account is not actually created until the installer performs the installation. See step 7 in Installing TIBCO iProcess Engine in Console Mode.

Did you find this helpful?

Yes No