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.
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 $
If you want to give this a try, read the end-to-end example here.
On our external yum server, we only have Instant Client 18c for now. On the OCI mirrors we have 12.x and 18.x. Remember that 18.3 client will connect to Database 11.2 and newer. As for precomp, on the yum mirrors in OCI it's there, but unfortunately the license is not compatible with free use terms and conditions so we don't have it on yum.oracle.com