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:
This topic describes how to upload the Oracle Instant Client to BucketFS.
Download the Oracle Instant Client (instantclient-basic-linux.x64-220.127.116.11.0.zip) from the Oracle website. Version 18.104.22.168.0 is the only supported version.
The default bucket is available on port 2581 by default. Ensure that
the security group contains an inbound rule with this port. For more information see Authorize inbound traffic to your linux instances.
Change the write password of the default bucket. For more information, see Change Bucket Password.
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.
curl -v -k -X PUT -T instantclient-basic-linux.x64-22.214.171.124.0.zip https://w:$WRITE_PW@$DATABASE_NODE_IP:2581/default/drivers/oracle/instantclient-basic-linux.x64-126.96.36.199.0.zip
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
IDENTIFIED BY 'oracle';