Add Oracle Instant Client

Exasol supports using the Oracle Instant Client to connect to an Oracle database. When using the instant client, use the IMPORT FROM ORA syntax. For more information, see IMPORT. By default, the database is configured to use the following path for the Oracle Instant Client:

/buckets/bfsdefault/default/drivers/oracle/

This topic describes how to upload the Oracle Instant Client to BucketFS.

Prerequisites

  • Download the Oracle Instant Client (instantclient-basic-linux.x64-12.1.0.2.0.zip) from the Oracle website. Version 12.1.0.2.0 is the only supported version.

  • The default bucket is available on port 2581 by default. Ensure that this port is open in your network settings.

  • Change the write password of the default bucket. For more information, see Change Bucket Password.

Procedure

The examples in this procedure are written using Bash on a Linux terminal. You can also use other interfaces and languages to execute the curl commands.

Placeholder values are styled as Bash variables, starting with the dollar sign ($) and using UPPERCASE characters. Replace the placeholders with your own values before executing the curl command.

Upload the zip file to the specified bucket path. For more information, see Access Files in BucketFS.

You must use an IP address of one of the database nodes, not the database access node.

For example:

curl -v -k -X PUT -T instantclient-basic-linux.x64-12.1.0.2.0.zip https://w:$WRITE_PW@$DATABASE_NODE_IP:2581/default/drivers/oracle/instantclient-basic-linux.x64-12.1.0.2.0.zip

Verification

To verify that the Oracle Instant Client is installed, perform an IMPORT statement using the IMPORT FROM ORA syntax. For example:

CREATE OR REPLACE CONNECTION OCI_ORACLE
    TO '192.168.99.103:1521/xe'
    USER 'system'
    IDENTIFIED BY 'oracle';
SELECT * FROM (
    IMPORT FROM ORA at OCI_ORACLE
    STATEMENT 'select ''Connection works'' from dual'
);

See Also