Due to the changes in the DB service after the release of TIBCO Cloud Integration 3.9.1, the user must supplement the Oracle driver in the following scenarios:

1 Deploying a new application that uses the TIBCO Flogo Connector for Oracle Database
2 Need to re-push an existing application that uses the TIBCO Flogo Connector for Oracle Database
Note: An existing application can continue to run without any problems unless the user needs to re-push the application.

Product: TIBCO Flogo Connector for Oracle Database Version:1.2.0 OS: TIBCO Cloud Integration

Steps to supplement the Oracle driver:
Note: Oracle client libraries supported for supplementing the connector are as follows:
- Oracle 21.x

1. Go to Oracle Website > Instant Client for Linux x86-64 (64-bit) > Version 21.11.0.0.0 and download the Basic Package compressed folder.

2. Similarly, go to Oracle Website > Instant Client for Linux x86-64 (64-bit) > Version 21.11.0.0.0 and download the ODBC Package compressed folder.
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.

3. Extract the downloaded Basic Package and ODBC Package compressed folders.

4. Merge the extracted ODBC Package folder with the instantclient_21_11 folder extracted from Basic Package.
Note: TIBCO recommends extracting the folders on a Linux system to preserve the symbolic links.

5. Rename the merged instantclient_21_11 folder to oracle.

6. Compress the oracle folder.
Note: Use the following command to preserve the symbolic links:
          zip --symlinks -r oracle.zip oracle
Caution: If the Oracle client libraries contain symbolic links, ensure that you unzip, rename, and again zip the client libraries to preserve the symbolic links.

7. Disable Flogo DB Services.

8. Supplement the connector. You can supplement the connector using one of the following ways:
      Supplementing from CLI
            a. Create a folder with the name OracleDatabase in a tmp folder and place oracle.zip in the OracleDatabase folder. This creates a folder structure as follows:
               tmp
                    tibcli
                    OracleDatabase
                              oracle.zip
            b. Open a terminal window and change the working directory to the Oracle Database folder.
            c. Run the following command.
                Use the following command to supplement the Oracle database connector:
                     ../tibcli flogoconnector supplement OracleDatabase
   
      Supplementing from the Web UI
            For details about supplementing the connector using the Web UI, see the Supplementing Plug-ins and Connectors topic in the TIBCO Cloud Integration documentation.

9. Enable Flogo DB Services.

10. If there is an existing Oracle connection, it is necessary to open the Oracle connection and click the connect button to re-establish the connection.

Steps that need to take after the release of TIBCO Cloud Integration 3.9.1