Oracle DB Administrator Name
Database Connection and Account Details Menu
Description
The Oracle username that the iProcess Engine should use when it needs to connect to the database as a database administrator (DBA).
Value
|
Installation Type |
New Installation |
Upgrade Installation |
|
Value |
An Oracle account name that: —has DBA-level access to the Oracle database. —is between 1 and 30 characters long. —contains only lowercase, alphanumeric, and underscore ( —has a leading alphanumeric character. |
Either: —the current Oracle DBA account name, or —no value (that is, leave the field blank) |
|
Default Value |
system |
N/A |
|
Node Cluster |
If you are installing a slave server, the name used must connect to the same database as the master server. |
If you are upgrading a slave server, the name used must connect to the same database as the master server. |
Notes
The account used must have the necessary permissions to create tablespaces and users in the Oracle instance, that is, it must either have the DBA role assigned or it must have access to the Oracle Data Dictionary.
If you are upgrading, you only need to supply the Oracle DBA name (and password) if you want the installer to perform certain checks to validate that it can upgrade the iProcess Engine database schema. The installer performs these checks when you enter C on the Oracle Database Connection and Account Details Menu, and needs DBA-level access to check the following items:
| • | TAF (see Setting up Oracle Transparent Application Failover (TAF)). |
| • | OPEN_CURSORS value (see Configuring Oracle OPEN_CURSORS). |
| • | Advanced Queuing configuration (see Disabling Oracle Flashback Query). |
If you do not need the installer to check these items, or you do not have access to the Oracle DBA name and/or password, you can leave this field blank. (Make sure that you have checked these items manually before running the installer.) The upgrade can still continue but these checks will be skipped.