Configure Directory Provider - Oracle

Basic Tab

Option Description
Host Specifies either the IP address or the hostname of the database server.
Port Specifies the TCP port of the listener running on the database server. The default is 1521, which is the default port number when installing the Oracle database software.
User Defines the user id used to connect to the database.
Password Defines the password for the user id used to connect to the database. This password is case-insensitive.
SID Specifies the Oracle System Identifier that refers to the instance of the Oracle database running on the server.
Schema Optionally, specifies the name of the schema used.
Note: When using a schema, it is recommended that the schema name and user name be the same.
URL Defines the URL format to connect to the database.

Advanced Tab

Option Description
Tablespace Specifies the tablespace within the ALBPM database.
Temporary Tablespace Specifies the temporary tablespace within the ALBPM database.
Profile Specifies the profile for the ALBPM database. Profiles are as a way to limit which users can connect to the database.

Properties

This tab allows you to specify additional properties that are supported by the JDBC driver. Properties are defined using name/value pairs.

Runtime

The following runtime configuration properties can be defined for this database:
Option Description
Maximum Pool Size Specifies the maximum number of connections within the connection pool. Database connections are grouped together within a connection pool to improve performance.
Maximum connections per user Specifies the maximum number of connections within the connection pool for each user.
Connection Idle Time (minutes) Specifies how long a connection can be idle before it times out.
Minimum Pool Size Specifies the minimum number of connections with the connection pool.
Maximum Opened Cursors Specifies how many queries can be created for each connection.
These properties define the JDBC connection handling for ALBPM components when running outside a J2EE (for example, WebLogic Server). When running within a J2EE container, database connectivity information is supplied by the container itself.
Parent topic: ALBPM Configuration Wizard Reference