Oracle Database Connection Details

To establish the connection successfully, you must configure the Oracle database instance.

The Oracle database connector dialog contains the following fields:

Field	Description
Name	Unique name for the Oracle database connector.
Description	A brief description of the connection.
Host	The IP address or URL of the server that hosts the Oracle database.
Port	Port number on the server. Note: By default, a Flogo Connector for Oracle Database cluster is configured with port 1521.
User	Username to connect to Oracle Database.
Password	Password to connect to Oracle Database.
Database Instance	Select the type of database instances as SID or Service Name. Default: SID
Database Instance value	Specify the value for SID or Service Name.
Maximum Open Connection	Sets the maximum number of open connections to the database. If the number of Maximum Idle Connections is greater than 0 and the Maximum Open Connections is less than the Maximum Idle Connections, then the Maximum Idle Connections is reduced to match the Maximum Open Connections value. Default: 50
Maximum Idle Connection	Sets the maximum number of connections in the idle connection pool. If the Maximum Open Connections is greater than 0 but less than the Maximum Idle Connections, then the Maximum Idle Connections is reduced to match the Maximum Open Connections value. Default: 10 If the value is less than or equal to 0, then no idle connections are retained.
Maximum Connection Lifetime	Sets the maximum amount of time for which a connection can be reused. Expired connections are closed before reuse. Default: 180s Valid time units: ns, us (or µs), ms, s, m, h. Example: 60s, 60m, 6h45m.