Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# iProcess Engine DB Schema Owner Name

Database Connection and Account Details Menu

## 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.

## Value

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.
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.) |

## Notes

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.

## Control File Keyword

IPEI_DBSONAME

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.