Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from: [https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html](https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html) The installation is quite simple but we need to rememeber that, in order to have a functional client for a DBA we would need to download three packages at least: * Basic Package – All files required to run OCI, OCCI, and JDBC-OCI applications * SQLPlus Package – The SQLPlus command line tool for SQL and PL/SQL queries * Tools Package – Includes Data Pump, SQL*Loader and Workload Replay Client After that, the installation goes as: $ mkdir instantclient $ unzip /Users/radu.parvu/Downloads/instantclient-basic-macos.x64-18.1.0.0.0.zip.download/ $ unzip /Users/radu.parvu/Downloads/instantclient-sqlplus-macos.x64-18.1.0.0.0.zip $ unzip /Users/radu.parvu/Downloads/instantclient-tools-macos.x64-18.1.0.0.0.zip $ cd instantclient_18_1/ $ pwd /Users/radu.parvu/opt/instantclient/instantclient_18_1 $ mkdir -p network/admin Add to the PATH in the .bash_profile: export PATH=$PATH:/Users/radu.parvu/opt/instantclient/instantclient_18_1 set the environment variable TNS_ADMIN: export TNS_ADMIN=/Users/radu.parvu/opt/instantclient/instantclient_18_1/network/admin

Read More →