Oracle Instant Client Downloads for macOS (Intel x86)

For more information, see the Instant Client Home Page. For information on the tools and libraries provided for the Pro*C and Pro*COBOL precompilers, see the Precompiler Downloads page.
Client-server version interoperability is detailed in Doc ID 207303.1. For example, Oracle Call Interface 19 and 18 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.

Starting with the 19.16 release, only DMG files are available. The ZIP files available with previous release are not notarized.

Installation Steps

Downloads - Version 19.16.0.0.0

Download	Details
Basic Package	instantclient-basic-macos.x64-19.16.0.0.0dbru.dmg 85,282,660 bytes (checksum=3492761507) SHA256 725eeb7c00041e926b57c3db508ea7439a1935a37f480c0ac6d46eddc4205331 All files required to run OCI, OCCI, and JDBC-OCI applications. Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.
Basic Light Package	instantclient-basiclite-macos.x64-19.16.0.0.0dbru.dmg 41,444,900 bytes (checksum=3028230505) SHA256 6b5df6b0c9fe704990679609a50313f2123cae36171dafc954825879b8391eb0 Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support. Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.
SQL*Plus Package	instantclient-sqlplus-macos.x64-19.16.0.0.0dbru.dmg 1,283,325 bytes (checksum=1586769674) SHA256 d4a219be20b660dab6d5306280a2436e97c7e96e79efcfd3fc147a32441a697d The SQL*Plus command line tool for SQL and PL/SQL queries. Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.
Tools Package	instantclient-tools-macos.x64-19.16.0.0.0dbru.dmg 1,507,604 bytes (checksum=3504334717) SHA256 b3b8fa1465b32ccd5fe8ed7356e0b1683bce8a89591cd27157348fbbc1b8fc1a Includes Data Pump, SQL*Loader and Workload Replay Client. Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.
SDK Package	instantclient-sdk-macos.x64-19.16.0.0.0dbru.dmg 1,227,572 bytes (checksum=3290385342) SHA256 0cee3fc7cc427d9503707459b9add0cc146b80c3487940ab6231bdcab702a0eb Additional header files and an example makefile for developing Oracle applications with Instant Client. Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.
JDBC Supplement Package	instantclient-jdbc-macos.x64-19.16.0.0.0dbru.dmg 2,137,260 bytes (checksum=1528558661) SHA256 db7e6af1c89b38a32b09b15cd76812a32445de2189afa648b9f53d6cea20b258 Additional support for Internationalization under JDBC. Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.
ODBC Package	instantclient-odbc-macos.x64-19.16.0.0.0dbru.dmg 2,414,816 bytes (checksum=3383822076) SHA256 f7e78c2b74456547a150a498fa5900504d741204207aff44e7fcfa01255b3ba0 Additional libraries for enabling ODBC applications. Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.

Downloads - Version 18.1.0.0.0 (64-bit)

Download	Details
Basic Package	instantclient-basic-macos.x64-18.1.0.0.0.zip 71,982,447 bytes cksum - 1702106497 SHA256 fac3cdaaee7526f6c50ff167edb4ba7ab68efb763de24f65f63fb48cc1ba44c0 All files required to run OCI, OCCI, and JDBC-OCI applications. Instant Client 18.1 supports macOS Mojave and High Sierra.
Basic Light Package	instantclient-basiclite-macos.x64-18.1.0.0.0.zip 35,297,778 bytes cksum - 2930628103 SHA256 027eba2291c5372d8e5b54a455b61fe05c6a19f056aa4eecd1e941efb0b39239 Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support. Instant Client 18.1 supports macOS Mojave and High Sierra.
SQL*Plus Package	instantclient-sqlplus-macos.x64-18.1.0.0.0.zip 916,567 bytes cksum - 1531146804 SHA256 02e66dc52398fced75e7efcb6b4372afcf617f7d88344fb7f0f4bb2bed371f3b The SQL*Plus command line tool for SQL and PL/SQL queries. Instant Client 18.1 supports macOS Mojave and High Sierra.
Tools Package	instantclient-tools-macos.x64-18.1.0.0.0.zip 1,205,728 bytes cksum - 3871420477 SHA256 eb1286e7fbb0992e683af74371271f45646ab69ff645fa88342afcbd6468ca1d Includes Data Pump, SQL*Loader and Workload Replay Client. Instant Client 18.1 supports macOS Mojave and High Sierra.
SDK Package	instantclient-sdk-macos.x64-18.1.0.0.0-2.zip 925,639 bytes cksum - 1251767455 SHA256 98e6d797f1ce11e59b042b232f62380cec29ec7d5387b88a9e074b741c13e63a Additional header files and an example makefile for developing Oracle applications with Instant Client (Updated 5 March 2019). Instant Client 18.1 supports macOS Mojave and High Sierra.
JDBC Supplement Package	instantclient-jdbc-macos.x64-18.1.0.0.0.zip 1,572,899 bytes cksum - 3513377311 SHA256 e7b1e676be9a18a483449be1eaaee1c7f1805871d2abb218c18bdf3a710c8ddc Additional support for Internationalization under JDBC. Instant Client 18.1 supports macOS Mojave and High Sierra.
ODBC Package	instantclient-odbc-macos.x64-18.1.0.0.0.zip 1,998,707 bytes cksum - 3748565934 SHA256 5d0cdd7f9dd2e27affbc9b36ef9fc48e329713ecd36905fdd089366e365ae8a2 Additional libraries for enabling ODBC applications. Instant Client 18.1 supports macOS Mojave and High Sierra.

Downloads - Version 12.2.0.1.0 (64-bit) Updated 15-Jan-2018

Download	Details
Basic Package	instantclient-basic-macos.x64-12.2.0.1.0-2.zip 68,160,048 bytes cksum - 2145539248 SHA256 3ed3102e5a24f0da638694191edb34933309fb472eb1df21ad5c86eedac3ebb9 All files required to run OCI, OCCI, and JDBC-OCI applications. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.
Basic Light Package	instantclient-basiclite-macos.x64-12.2.0.1.0-2.zip 32,101,235 bytes cksum - 1597579561 SHA256 2997f753b61f8b445a241e99412c132feb76cf246dcca2e7837fe82b15c1efb8 Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.
SQL*Plus Package	instantclient-sqlplus-macos.x64-12.2.0.1.0-2.zip 905,985 bytes cksum - 3193372887 SHA256 d147cbb5b2a954fdcb4b642df4f0bd1153fd56e0f56e7fa301601b4f7e2abe0e The SQL*Plus command line tool for SQL and PL/SQL queries. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.
Tools Package	instantclient-tools-macos.x64-12.2.0.1.0-2.zip 1,188,607 bytes cksum - 4234197225 SHA256 dfd2d9a2721d2e2a90d8053a8e4c9d0c9a68e8d47c9c99e1b80e8fa1c2edb99c Includes Data Pump, SQL*Loader and Workload Replay Client. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.
SDK Package	instantclient-sdk-macos.x64-12.2.0.1.0-2.zip 673,883 bytes cksum - 3731483473 SHA256 e0befca9c4e71ebc9f444957ffa70f01aeeec5976ea27c40406471b04c34848b Additional header files and an example makefile for developing Oracle applications with Instant Client. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.
JDBC Supplement Package	instantclient-jdbc-macos.x64-12.2.0.1.0-2.zip 1,570,334 bytes cksum - 1705103068 SHA256 5d91aaa6c66e5570ebac608e60aa1470433da9dc8cc4d8038bc803676276bffd Additional support for Internationalization under JDBC. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.
ODBC Package	instantclient-odbc-macos.x64-12.2.0.1.0-2.zip 1,962,870 bytes cksum - 3397148646 SHA256 1805c1ab6c8c5e8df7bdcc35d7f2b94c329ecf4dff9bde55d5f9b159ecd8b64e Additional libraries for enabling ODBC applications. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.

Download - Version 12.1.0.2 (64-bit) Updated 5-Jul-2017

Download	Details
Basic Package	instantclient-basic-macos.x64-12.1.0.2.0.zip 63,591,161 bytes cksum - 2819753276 SHA256 71aa366c961166fb070eb6ee9e5905358c61d5ede9dffd5fb073301d32cbd20c All files required to run OCI, OCCI, and JDBC-OCI applications. Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.
Basic Light Package	instantclient-basiclite-macos.x64-12.1.0.2.0.zip 31,539,594 bytes cksum - 1112518720 SHA256 c39d498fa6eb08d46014283a3a79bcaf63060cdbd0f58f97322da012350d4c39 Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support. Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.
JDBC Supplement Package	instantclient-jdbc-macos.x64-12.1.0.2.0.zip 143,238 bytes cksum - 988652685 SHA256 6da4e94a45e659eb189adc92462b2ce1408386df3adf09c895a191a5cf593352 Additional support for XA, Internationalization, and RowSet operations under JDBC. Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.
SQL*Plus Package	instantclient-sqlplus-macos.x64-12.1.0.2.0.zip 871,943 bytes cksum - 1242636584 SHA256 a663937e2e32c237bb03df1bda835f2a29bc311683087f2d82eac3a8ea569f81 Additional libraries and executable for running SQL*Plus with Instant Client. Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.
ODBC Package	instantclient-odbc-macos.x64-12.1.0.2.0.zip 1,865,942 bytes cksum - 2249115520 SHA256 0bdd11783f160bc0dcb6d842a3fed211d016b41d36f2eeca873592b2bec0b3fa Additional libraries for enabling ODBC applications. Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.
SDK Package	instantclient-sdk-macos.x64-12.1.0.2.0.zip 664,114 bytes cksum - 670890418 SHA256 950153e53e1c163c51ef34eb8eb9b60b7f0da21120a86f7070c0baff44ef4ab9 Additional header files and an example makefile for developing Oracle applications with Instant Client. Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.
WRC Package	instantclient-tools-macos.x64-12.1.0.2.0.zip 236,151 bytes cksum - 3773150080 SHA256 8b23c0343b1f6ae971b70af989770628483f40db689409ca3aad849ee587e181 Workload Replay Client used to replay workload for RAT's DB Replay Feature. Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.

Downloads - Version 12.1.0.2 (32-bit) Updated 4-Jan-17

Downloads	Details
Basic Package	instantclient-basic-macos.x32-12.1.0.2.0.zip 64,143,856 bytes cksum - 3075410801 SHA256 07f382b6bf144f792ba6d85ab32299ba93248d2ef38763d44b30f8c254ec6d9a All files required to run OCI, OCCI, and JDBC-OCI applications
Basic Light Package	instantclient-basiclite-macos.x32-12.1.0.2.0.zip 32,093,291 bytes cksum - 1437280362 SHA256 0e62de31ceaf854c4f9997be58cda74fd3c527de917f1890b73078200c0b9fc9 Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support
JDBC Supplement Package	instantclient-jdbc-macos.x32-12.1.0.2.0.zip 143,295 bytes cksum - 2965858677 SHA256 5d17ed02c5bcdf6f2710d8d9902fa62fa906dbb0017e6745a98f90e8412f2ed9 Additional support for XA, Internationalization, and RowSet operations under JDBC
SQL*Plus Package	instantclient-sqlplus-macos.x32-12.1.0.2.0.zip 892,440 bytes cksum - 1535728498 SHA256 5fcbdbbbf5556366875b8d70dfbe18990828c8f7123754eb6b6ce9604e5cd393 Additional libraries and executable for running SQL*Plus with Instant Client
ODBC Package	instantclient-odbc-macos.x32-12.1.0.2.0.zip 1,883,055 bytes cksum - 1502599121 SHA256 68ae1782a5e3ec17acf700a320d4373b02542777b223ecd686e395432d6098bc Additional libraries for enabling ODBC applications
SDK Package	instantclient-sdk-macos.x32-12.1.0.2.0.zip 664,121 bytes cksum - 2233654893 SHA256 dd604874584fb051d2a406b47fd9e4203f95d50d09872c4b000687aadad5d287 Additional header files and an example makefile for developing Oracle applications with Instant Client
WRC Package	instantclient-tools-macos.x32-12.1.0.2.0.zip 258,686 bytes cksum - 2882512306 SHA256 7c9b58c416e54f5b19746128f36e03387b7f31f4bb756acfe3881dbedf79f09f Workload Replay Client used to replay workload for RAT's DB Replay Feature

Downloads - Version 11.2.0.4.0 (64-bit)

Download	Details
Basic Package	instantclient-basic-macos.x64-11.2.0.4.0.zip 62,794,903 bytes SHA256 6c079713ab0a65193f7bfcbad6c90e7806fa6634a3828052f8428e1533bb89d3 All files required to run OCI, OCCI, and JDBC-OCI applications. Instant Client 11.2 supports macOS X Lion, Mountain Lion and Mavericks.
Basic Light Package	instantclient-basiclite-macos.x64-11.2.0.4.0.zip 26,034,836 bytes SHA256 d51c5fb67d1213c9b3c6301c6f73fe1bef45f78197e1bae7804df4c0abb468a7 Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support Instant Client 11.2 supports macOS X Lion, Mountain Lion and Mavericks.
JDBC Supplement Package	instantclient-jdbc-macos.x64-11.2.0.4.0.zip 1,560,298 bytes SHA256 4a08adc509b1363fe27ff0491a9a3e8ce8b98552a5446728204300e7d1dd1b3d Additional support for XA, Internationalization, and RowSet operations under JDBC. Instant Client 11.2 supports macOS X Lion, Mountain Lion and Mavericks.
SQL*Plus Package	instantclient-sqlplus-macos.x64-11.2.0.4.0.zip 884,608 bytes SHA256 127d2baaa4c72d8591af829f00dea5e2a77c0e272ce8fc091dd853e9406845b9 Additional libraries and executable for running SQL*Plus with Instant Client. Instant Client 11.2 supports macOS X Lion, Mountain Lion and Mavericks.
SDK Package	instantclient-sdk-macos.x64-11.2.0.4.0.zip 651,903 bytes SHA256 aead0663c206a811cf1f61d3b2a533ff81e6e6109dd31544ad850a7ef6eb5d19 Additional header files and an example makefile for developing Oracle applications with Instant Client. Instant Client 11.2 supports macOS X Lion, Mountain Lion and Mavericks.
WRC Package	instantclient-tools-macos.x64-11.2.0.4.0.zip 235,951 bytes SHA256 a570e8e504bfcd9fabda64431e59dc0316752594f2b2d05f96d6c06575d06865 Workload Replay Client used to replay workload for RAT's DB Replay Feature. Instant Client 11.2 supports macOS X Lion, Mountain Lion and Mavericks.

Downloads - Version 11.2.0.4.0 (32-bit)

Download	Details
Basic Package	instantclient-basic-macos.x32-11.2.0.4.0.zip 58,425,231 bytes SHA256 c1d59a284d7ed8a65fc38c1df08b4ab632aebeb27420f7892e38e0725f1325b4 All files required to run OCI, OCCI, and JDBC-OCI applications.
Basic Light Package	instantclient-basiclite-macos.x32-11.2.0.4.0.zip 23,003,182 bytes SHA256 2bc3261d70c768ace46c72d5c6d5ae4f75b58a3db62549f9ec081f7114aa73af Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support.
JDBC Supplement Package	instantclient-jdbc-macos.x32-11.2.0.4.0.zip 11,078 bytes SHA256 b8f3316f5c5aaae2e16fab484c9d78a7be9e3b65ab22a44c981b08f4dfc0bb2e Additional support for XA, Internationalization, and RowSet operations under JDBC.
SQL*Plus Package	instantclient-sqlplus-macos.x32-11.2.0.4.0.zip 800,263 bytes SHA256 795a3b1339dd7aec817533c42f4e797e9a11205712b1a812f878ab8fd30916b9 Additional libraries and executable for running SQL*Plus with Instant Client.
SDK Package	instantclient-sdk-macos.x32-11.2.0.4.0.zip 651,903 bytes SHA256 4d4af789e471ea393ec019c16a3731abea9d384cdde8fce562f34406e79c6d13 Additional header files and an example makefile for developing Oracle applications with Instant Client.
WRC Package	instantclient-tools-macos.x32-11.2.0.4.0.zip 197,708 bytes SHA256 f4246013736230b8cdba6e797290d113459b1dd604389fd460dd48b043ba00ec Workload Replay Client used to replay workload for RAT's DB Replay Feature.

Downloads - Version 10.2.0.4 (64-bit)

Download	Details
Basic Package	instantclient-basic-10.2.0.4.0-macosx-x64.zip 35,013,419 bytes SHA256 ae0fc5b2148f58d4f3ed0f3d10fc2add50be33d1ac2f360fadb5be8eca28a4a7 All files required to run OCI, OCCI, and JDBC-OCI applications.
Basic Light Package	instantclient-basiclite-10.2.0.4.0-macosx-x64.zip 11,877,594 bytes SHA256 e511d047e9b9512bcf4e929e7193eaac550963eaf87255dd2e466c8512662b63 Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only).
JDBC Supplement Package	instantclient-jdbc-10.2.0.4.0-macosx-x64.zip 1,493,189 bytes SHA256 522d34cfd40d2fad9e7ecd3ba7baaac7631038734263b070112d53044b34817e Additional support for XA, Internationalization, and RowSet operations under JDBC.
SQL*Plus Package	instantclient-sqlplus-10.2.0.4.0-macosx-x64.zip 746,094 bytes SHA256 80eeaef1527de120ba7a06fb03aa25b8f993c6e71109a250eee6d21ce00296a0 Additional libraries and executable for running SQL*Plus with Instant Client.
SDK Package	instantclient-sdk-10.2.0.4.0-macosx-x64.zip 603,530 bytes SHA256 0373694ee8842cdc997616f1606091fe772c0799ad66757b2cfff73e3fae2b3d Additional header files and an example makefile for developing Oracle applications with Instant Client.

Downloads - Version 10.2.0.4 (32-bit)

Download	Details
Basic Package	instantclient-basic-10.2.0.4.0-macosx-x86.zip 34,109,360 bytes SHA256 fdf84169bf5161c043dd805b74ac65f4e0d212a6af85fb41f862c8b5950b1ba0 All files required to run OCI, OCCI, and JDBC-OCI applications.
Basic Light Package	instantclient-basiclite-10.2.0.4.0-macosx-x86.zip 10,975,530 bytes SHA256 5162986906b5fe32dfb53ce068502e36310a23c60445654de7bbf5ee23f3979f Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only).
JDBC Supplement Package	instantclient-jdbc-10.2.0.4.0-macosx-x86.zip 1,490,104 bytes SHA256 48dd3a5bd76644161fa203416c58c58d32db538ffc156d76f2be72d472c27ead Additional support for XA, Internationalization, and RowSet operations under JDBC.
SQL*Plus Package	instantclient-sqlplus-10.2.0.4.0-macosx-x86.zip 711,801 bytes SHA256 444f76935e973c131d1706026a38188e67040dda034512c002ee6e7615123944 Additional libraries and executable for running SQL*Plus with Instant Client.
SDK Package	instantclient-sdk-10.2.0.4.0-macosx-x86.zip 603,526 bytes SHA256 8d099b4f934e7d2bac7f182da4e2c4850501d18affeb0fde27d5ce2a9a4c6697 Additional header files and an example makefile for developing Oracle applications with Instant Client.

Installing Instant Client 19.16 on macOS

Instant Client 19.16 supports macOS High Sierra, Mojave, Catalina, Big Sur and Monterey.

In Finder, double click on all desired Instant Client .dmg packages to mount them. All installations require the Basic or Basic Light package.
Open a terminal window and change directory to one of the packages, for example:

cd /Volumes/instantclient-basic-macos.x64-19.16.0.0.0dbru

Run the install_ic.sh script:

$ ./install_ic.sh

This copies the contents of all currently mounted Instant Client .dmg packages to /User/$USER/Downloads/instantclient_19_16

In Finder, eject the mounted Instant Client packages
If you intend to co-locate optional Oracle configuration files such as tnsnames.ora, sqlnet.ora, ldap.ora, or oraaccess.xml with Instant Client, put them in the instantclient_19_16/network/admin subdirectory. This is the default Oracle configuration directory for applications linked with this Instant Client.

Alternatively, Oracle configuration files can be put in another, accessible directory. Then set the environment variable TNS_ADMIN to that directory name.
To use binaries such as sqlplus from the SQL*Plus package, unzip the package to the same directory as the Basic package and then update your PATH environment variable, for example:

export PATH=~/Downloads/instantclient_19_16:$PATH

Run SQL*Plus and connect using your database credentials and connection string: sqlplus hr/welcome@localhost/orclpdb
Refer to your application's installation instructions for how to use Instant Client with that application.

Installing Instant Client 18.1 on macOS

Instant Client 18.1 supports macOS Mojave and High Sierra.

Download the desired Instant Client ZIP files. All installations require the Basic or Basic Light package.
Unzip the packages into a single directory such as ~/instantclient_18_1 that is accessible to your application. For example:

cd ~unzip instantclient-basic-macos.x64-18.1.0.0.0.zip

Add links to ~/lib or /usr/local/lib to enable applications to find the libraries. For example, OCI based applications could do:

mkdir ~/libln -s ~/instantclient_18_1/libclntsh.dylib ~/lib/

Alternatively, copy the required libraries. For example, to use OCI applications:

mkdir ~/libcp /opt/oracle/instantclient_18_1/libclntsh.dylib.18.1 ~/lib/cp /opt/oracle/instantclient_18_1/libclntshcore.dylib.18.1 ~/lib/cp /opt/oracle/instantclient_18_1/libons.dylib ~/lib/cp /opt/oracle/instantclient_18_1/libnnz18.dylib ~/lib/cp /opt/oracle/instantclient_18_1/libociei.dylib ~/lib/ln -s ~/lib/libclntsh.dylib.18.1 ~/lib/libclntsh.dylib

Note: Custom OCI applications, such as those that bundle Instant Client, may want to link with -rpath set to the directory containing Instant Client 18.1 instead of relying on libraries being in ~/lib.

If you intend to co-locate optional Oracle configuration files such as tnsnames.ora, sqlnet.ora, ldap.ora, or oraaccess.xml with Instant Client, put them in the instantclient_18_1/network/admin subdirectory. This is the default Oracle configuration directory for applications linked with this Instant Client.

Alternatively, Oracle configuration files can be put in another, accessible directory. Then set the environment variable TNS_ADMIN to that directory name.

To use binaries such as sqlplus from the SQL*Plus package, unzip the package to the same directory as the Basic package and then update your PATH environment variable, for example:

export PATH=~/instantclient_18_1:$PATH

Run SQL*Plus and connect using your database credentials and connection string:

sqlplus hr/welcome@localhost/orclpdb

Installing Instant Client 12.2 on macOS

Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan.

Download the desired Instant Client ZIP files. All installations require the Basic or Basic Light package.
Unzip the packages into a single directory such as ~/instantclient_12_2 that is accessible to your application. For example:

cd ~unzip instantclient-basic-macos.x64-12.2.0.1.0.zip

Add links to ~/lib or /usr/local/lib to enable applications to find the libraries. For example, OCI based applications could do:

mkdir ~/libln -s ~/instantclient_12_2/libclntsh.dylib ~/lib/ln -s ~/instantclient_12_2/libclntsh.dylib.12.1 ~/lib/

Alternatively, copy the required libraries. For example, to use OCI applications:

mkdir ~/libcp /opt/oracle/instantclient_12_2/libclntsh.dylib.12.1 ~/lib/cp /opt/oracle/instantclient_12_2/libclntshcore.dylib.12.1 ~/lib/cp /opt/oracle/instantclient_12_2/libons.dylib ~/lib/cp /opt/oracle/instantclient_12_2/libnnz12.dylib ~/lib/cp /opt/oracle/instantclient_12_2/libociei.dylib ~/lib/ln -s ~/lib/libclntsh.dylib.12.1 ~/lib/libclntsh.dylib

Note: Custom OCI applications, such as those that bundle Instant Client, may want to link with -rpath set to the directory containing Instant Client 12.2 instead of relying on libraries being in ~/lib.

If you intend to co-locate optional Oracle configuration files such as tnsnames.ora, sqlnet.ora, ldap.ora, or oraaccess.xml with Instant Client, then create a network/admin subdirectory. For example:

mkdir -p ~/instantclient_12_2/network/admin

This is the default Oracle configuration directory for applications linked with this Instant Client.

Alternatively, Oracle configuration files can be put in another, accessible directory. Then set the environment variable TNS_ADMIN to that directory name.

To use binaries such as sqlplus from the SQL*Plus package, unzip the package to the same directory as the Basic package and then update your PATH environment variable, for example:

export PATH=~/instantclient_12_2:$PATH

Run SQL*Plus and connect using your database credentials and connection string:

sqlplus hr/welcome@localhost/orclpdb

Installing Instant Client 12.1 on macOS

Instant Client 12.1 supports macOS El Capitan, Yosemite and Mavericks.

Download the desired Instant Client ZIP files. All installations require the Basic or Basic Light package.
Unzip the packages into a single directory such as "~/instantclient_12_1". For example, to use SQL*Plus:

cd ~unzip instantclient-basic-macos.x64-12.1.0.2.0.zip

Create the appropriate libclntsh.dylib link for the version of Instant Client. For example:

cd ~/instantclient_12_1ln -s libclntsh.dylib.12.1 libclntsh.dylib

OCCI programs will additionally need:

ln -s libocci.dylib.12.1 libocci.dylib

Add links to ~/lib or /usr/local/lib to enable applications to find the libraries. For example, OCI based applications could do:

mkdir ~/libln -s ~/instantclient_12_1/libclntsh.dylib ~/lib/ln -s ~/instantclient_12_1/libclntsh.dylib.12.1 ~/lib/

Alternatively, copy the required libraries. For example, to use OCI applications:

mkdir ~/libcp /opt/oracle/instantclient_12_1/libclntsh.dylib.12.1 ~/lib/cp /opt/oracle/instantclient_12_1/libclntshcore.dylib.12.1 ~/lib/cp /opt/oracle/instantclient_12_1/libons.dylib ~/lib/cp /opt/oracle/instantclient_12_1/libnnz12.dylib ~/lib/cp /opt/oracle/instantclient_12_1/libociei.dylib ~/lib/

Note: Custom OCI applications, such as those that bundle Instant Client, may want to link with -rpath set to the directory containing Instant Client 12.1 instead of relying on libraries being in ~/lib.

To be able to run SQL*Plus, update PATH. For example:

export PATH=~/instantclient_12_1:$PATH

Run SQL*Plus and connect using your database credentials and connection string:

sqlplus hr/welcome@localhost/orclpdb

Installing Instant Client 11.2 on macOS

Instant Client 11.2 supports macOS X Lion, Mountain Lion and Mavericks.

Download the desired Instant Client ZIP files. All installations require the Basic or Basic Light package.
Unzip the packages into a single directory such as "~/instantclient_11_2". For example, to use SQL*Plus:

cd ~unzip instantclient-basic-macos.x64-11.2.0.4.0.zipunzip instantclient-sqlplus-macos.x64-11.2.0.4.0.zip

cd ~/instantclient_11_2ln -s libclntsh.dylib.11.1 libclntsh.dylib

Note: OCCI programs will additionally need:

ln -s libocci.dylib.11.1 libocci.dylib

Add links to "~/lib" for required Basic package libraries. For example, to use OCI programs (including SQL*Plus, Python's cx_Oracle, PHP's OCI8, Node.js's node-oracledb, and Ruby's ruby-oci8 driver):

mkdir ~/libln -s ~/instantclient_11_2/{libclntsh.dylib.11.1,libnnz11.dylib,\libociei.dylib} ~/lib/

To be able to run SQL*Plus, add its libraries to "~/lib", and update PATH. For example:

ln -s ~/instantclient_11_2/{libsqlplus.dylib,libsqlplusic.dylib} ~/lib/export PATH=~/instantclient_11_2:$PATH

Run SQL*Plus and connect using your database credentials and connection string:

sqlplus hr/welcome@localhost/orclpdb