Today we added Oracle Instant Client to the Oracle Cloud Infrastructure (OCI) yum mirrors. This makes developing Oracle Database-based apps on OCI a breeze. Previously, installing Oracle Instant Client required either registering a system with ULN or downloading from OTN, each with manual steps to accept license terms. Now you can simply use yum install directly from Oracle Linux running in OCI.

See this tutorial on the Oracle Developer blog for an example that connects a Node.js app running on an OCI instance to an Autonomous Transaction Processing (ATP) Database.

Getting Oracle Instant Client RPMs From Your Local OCI Yum Mirror

Grab the latest version of the repo defintion from the yum server local to your region as follows:

cd /etc/yum.repos.d
sudo mv public-yum-ol7.repo public-yum-ol7.repo.bak  
export REGION=`curl http://169.254.169.254/opc/v1/instance/ -s | jq -r '.region'| cut -d '-' -f 2`  
sudo -E wget http://yum-$REGION.oracle.com/yum-$REGION-ol7.repo

Enable the ol7_oci_included repo:

sudo yum-config-manager --enable ol7_oci_included

Behold!

$ yum list oracle-instantclient*
Loaded plugins: langpacks, ulninfo
Installed Packages
oracle-instantclient12.2-basic.x86_64                         12.2.0.1.0-1                     @ol7_oci_included
Available Packages
oracle-instantclient12.2-basiclite.x86_64                     12.2.0.1.0-1                     ol7_oci_included 
oracle-instantclient12.2-devel.x86_64                         12.2.0.1.0-1                     ol7_oci_included 
oracle-instantclient12.2-jdbc.x86_64                          12.2.0.1.0-1                     ol7_oci_included 
oracle-instantclient12.2-odbc.x86_64                          12.2.0.1.0-1                     ol7_oci_included 
oracle-instantclient12.2-precomp.x86_64                       12.2.0.1.0-1                     ol7_oci_included 
oracle-instantclient12.2-sqlplus.x86_64                       12.2.0.1.0-1                     ol7_oci_included 
oracle-instantclient12.2-tools.x86_64                         12.2.0.1.0-1                     ol7_oci_included 
oracle-instantclient18.3-basic.x86_64                         18.3.0.0.0-1                     ol7_oci_included 
oracle-instantclient18.3-basiclite.x86_64                     18.3.0.0.0-1                     ol7_oci_included 
oracle-instantclient18.3-devel.x86_64                         18.3.0.0.0-1                     ol7_oci_included 
oracle-instantclient18.3-jdbc.x86_64                          18.3.0.0.0-1                     ol7_oci_included 
oracle-instantclient18.3-odbc.x86_64                          18.3.0.0.0-1                     ol7_oci_included 
oracle-instantclient18.3-precomp.x86_64                       18.3.0.0.0-1                     ol7_oci_included 
oracle-instantclient18.3-sqlplus.x86_64                       18.3.0.0.0-1                     ol7_oci_included 
oracle-instantclient18.3-tools.x86_64                         18.3.0.0.0-1                     ol7_oci_included 
$

Try it Yourself

If you want to give this a try, read the end-to-end example here.