This section contains information that is specific to the database type Oracle.
...
When selecting the Oracle database type, you can configure the following properties using the Properties tab in the Database profile:
oracle.pool.connectionwaittimeoutoracle.pool.inactivitytimeoutoracle.pool.maxlimitoracle.pool.minlimitoracle.pool.propertycheckintervaloracle.pool.refreshonsqlerrororacle.net.encryption_clientoracle.net.encryption_types_clientoracle.net.crypto_checksum_clientoracle.net.crypto_checksum_types_client
Preparations
A database driver is required to connect to an Oracle database. This driver must be stored in the Platform Container. Follow these if Oracle was not set up during the installation of the Platform Container:
...
The Advanced Connection Setup is used for Oracle RAC Configurations.
To make enable the Connection String text area and the and Notification Service text field appearfields, select the Advanced Connection Setup radio button. The Username, Password and Database Type fields will remain.
If is If is installed with the Oracle database, the Oracle RAC functionality Fast Connection Failover (FCF) is available. supports The system supports FCF, thus the behavior from perspective from its perspective is that there will normally be some exceptions generated during RAC instance failover. When FCF is configured,
detects a lost connection, clears the database connection pool and reinitializes the connection pool.
During an RAC instance failover, you might experience exceptions, for example, when database transactions such as updates and inserts are done. Database exceptions are logged in the systemthe system.
The Platform and Execution Contexts support the failover behavior. However, note that neither database collection nor forwarding agents support FCF. These agents have a different type of database connection pool implementation.
...
| Setting | Description |
|---|---|
Connection String | In the text field, a connection string can be entered. The connection string can contain a SID or a service name. The string added underlying system will not be modified by the underlying systemmodify the string added. If a connection string is longer than the text area space a vertical scroll bar will be displayed to enable viewing and editing of the connection string. |
Notification Service | Enter the Configuration that enables the Oracle Notification Service daemon (ONS) to establish a Fast Connection Failover (FCF). The ONS string that you enter should at least specify the agent ONS configuration attribute, that which is made up of a comma-separated list of host:port pairs. The hosts and ports represent the remote ONS daemons that are available on the RAC agents. For further information see the Installation guidelines of Oracle Oracle RAC in the Installation Instructions. |
| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||