Skip to content

Latest commit

 

History

History
51 lines (30 loc) · 1.96 KB

README.md

File metadata and controls

51 lines (30 loc) · 1.96 KB
Raw

About this Docker Image

This Docker image contains the Oracle Instant Client 'Basic', 'SDK' and 'SQL*Plus' packages. It can be extended to run OCI, OCCI, and JDBC applications. It can also be extended to build and run scripting language drivers that use OCI such as Python's cx_Oracle, Node.js's node-oracledb, PHP's OCI8, and Ruby's ruby-oci8.

The SQL*Plus command-line query tool is also included, allowing quick ad-hoc SQL and PL/SQL execution.

About Oracle Instant Client

Oracle Instant Client is a repackaging of Oracle Database libraries, tools and header files usable to create and run applications that connect to a remote (or local) Oracle Database.

Required files

Download the Oracle Instant Client RPMs from OTN:

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

The following three RPMs are required:

  • oracle-instantclient<version>-basic-<version>-1.x86_64.rpm
  • oracle-instantclient<version>-devel-<version>-1.x86_64.rpm
  • oracle-instantclient<version>-sqlplus-<version>-1.x86_64.rpm

Building

Place the downloaded Oracle Instant Client RPMs (from the previous step) in the same directory as the Dockerfile and run:

docker build -t oracle/instantclient:<version> .

For example, to build an 18.3 Instance Client Docker Image, run:

docker build -t oracle/instantclient:18.3.0 .

Usage

You can run a container interactively to execute ad-hoc SQL and PL/SQL statements in SQL*Plus:

docker run -ti --rm oracle/instantclient:18.3.0 sqlplus hr/[email protected]/pdborcl

Adding Oracle Database Drivers

To extend the image with optional Oracle Database drivers, follow your desired driver installation steps. The Instant Client libraries are in /usr/lib/oracle/<version>/client64/lib and the Instant Client headers are in /usr/include/oracle/<version>/client64/.

The Instant Client libraries are in the default library search path.