Download Instant Client for macOS
http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst
| Alexs-MBP:Downloads alexlima$ pwd | |
| /Users/alexlima/Downloads | |
| Alexs-MBP:Downloads alexlima$ ls -lrt in* | |
| -rw-r–r–@ 1 alexlima staff 68160048 Jan 25 11:13 instantclient-basic-macos.x64-12.2.0.1.0-2.zip | |
| -rw-r–r–@ 1 alexlima staff 905985 Jan 25 11:14 instantclient-sqlplus-macos.x64-12.2.0.1.0-2.zip | |
| -rw-r–r–@ 1 alexlima staff 673883 Jan 25 11:14 instantclient-sdk-macos.x64-12.2.0.1.0-2.zip | |
| # Unzip basic libraries | |
| Alexs-MBP:Downloads alexlima$ unzip instantclient-basic-macos.x64-12.2.0.1.0-2.zip | |
| Archive: instantclient-basic-macos.x64-12.2.0.1.0-2.zip | |
| inflating: instantclient_12_2/BASIC_README | |
| inflating: instantclient_12_2/adrci | |
| inflating: instantclient_12_2/genezi | |
| linking: instantclient_12_2/libclntsh.dylib -> libclntsh.dylib.12.1 | |
| inflating: instantclient_12_2/libclntsh.dylib.12.1 | |
| inflating: instantclient_12_2/libclntshcore.dylib.12.1 | |
| inflating: instantclient_12_2/libnnz12.dylib | |
| linking: instantclient_12_2/libocci.dylib -> libocci.dylib.12.1 | |
| inflating: instantclient_12_2/libocci.dylib.12.1 | |
| inflating: instantclient_12_2/libociei.dylib | |
| inflating: instantclient_12_2/libocijdbc12.dylib | |
| inflating: instantclient_12_2/libons.dylib | |
| inflating: instantclient_12_2/liboramysql12.dylib | |
| inflating: instantclient_12_2/ojdbc8.jar | |
| inflating: instantclient_12_2/uidrvci | |
| inflating: instantclient_12_2/xstreams.jar | |
| finishing deferred symbolic links: | |
| instantclient_12_2/libclntsh.dylib -> libclntsh.dylib.12.1 | |
| instantclient_12_2/libocci.dylib -> libocci.dylib.12.1 | |
| # Unzip sqlplus libraries | |
| Alexs-MBP:Downloads alexlima$ unzip -j instantclient-sqlplus-macos.x64-12.2.0.1.0-2.zip | |
| Archive: instantclient-sqlplus-macos.x64-12.2.0.1.0-2.zip | |
| inflating: SQLPLUS_README | |
| inflating: glogin.sql | |
| inflating: libsqlplus.dylib | |
| inflating: libsqlplusic.dylib | |
| inflating: sqlplus | |
| Alexs-MBP:Downloads alexlima$ ls -lrt | |
| -rw-r–r–@ 1 alexlima staff 68160048 Jan 25 11:13 instantclient-basic-macos.x64-12.2.0.1.0-2.zip | |
| -rw-r–r–@ 1 alexlima staff 905985 Jan 25 11:14 instantclient-sqlplus-macos.x64-12.2.0.1.0-2.zip | |
| -rw-r–r–@ 1 alexlima staff 673883 Jan 25 11:14 instantclient-sdk-macos.x64-12.2.0.1.0-2.zip | |
| drwxr-xr-x@ 18 alexlima staff 576 Jan 25 14:31 instantclient_12_2 | |
| # Move installation to user root folder | |
| Alexs-MBP:Downloads alexlima$ mv instantclient_12_2/ ../ | |
| Alexs-MBP:Downloads alexlima$ mkdir -p ~/instantclient_12_2/network/admin | |
| # Create symbolic links to /usr/local/lib | |
| Alexs-MBP:Downloads alexlima$ ln -s ~/instantclient_12_2/libclntsh.dylib /usr/local/lib/ | |
| Alexs-MBP:Downloads alexlima$ sudo ln -s ~/instantclient_12_2/libclntsh.dylib /usr/local/lib/ | |
| Alexs-MBP:Downloads alexlima$ sudo ln -s ~/instantclient_12_2/libclntsh.dylib.12.1 /usr/local/lib/ | |
| # Create system variables | |
| Alexs-MBP:Downloads alexlima$ export PATH=~/instantclient_12_2:$PATH | |
| Alexs-MBP:Downloads alexlima$ export TNS_ADMIN=/Users/alexlima/instantclient_12_2/network/admin | |
| Alexs-MBP:Downloads alexlima$ cd $TNS_ADMIN | |
| Alexs-MBP:Downloads alexlima$ vi tnsnames.ora | |
| ORCL = | |
| (DESCRIPTION = | |
| (ADDRESS_LIST = | |
| (ADDRESS = (PROTOCOL = TCP)(HOST = oradb1)(PORT = 1521)) | |
| ) | |
| (CONNECT_DATA = | |
| (SERVICE_NAME = orcl) | |
| ) | |
| ) | |
| # Connect to a remote database with sqlplus | |
| Alexs-MBP:admin alexlima$ sqlplus alima/xxxxx@orcl | |
| SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 25 14:41:23 2018 | |
| Copyright (c) 1982, 2017, Oracle. All rights reserved. | |
| Last Successful login time: Thu Jan 25 2018 14:28:33 -07:00 | |
| Connected to: | |
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production | |
| With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options | |
| SQL> | |
| # Add variables to .bash_profile | |
| export SQLPATH=/Users/alexlima/Dropbox/BIAS_FTE/Training/AOT/scripts | |
| export TNS_ADMIN=/Users/alexlima/instantclient_12_2/network/admin | |
| export PATH=~/instantclient_12_2:$PATH | |
| DONE.. | |
Cool,
for me its says sql command not found after these steps any idea?