Skip to main content

Install SQL*Plus 12.2 on a Mac

Published: 2019-06-07 | Lastmod: 2019-06-12

  1. Navigate to Oracle downloads, accept the license agreement, and login. If you don’t already have an Oracle account, you’ll need to create one
  2. Download these zip files:
    1. instantclient-basic-macos.x64-12.2.0.1.0-2.zip
    2. instantclient-sqlplus-macos.x64-12.2.0.1.0-2.zip
  3. Run mkdir -p ~/bin/instantclient_12_2
  4. Unzip the contents of both zip files directly into ~/bin/instantclient_12_2. The file listing should look like:

    $ find . | sort
    .
    ./BASIC_README
    ./SQLPLUS_README
    ./adrci
    ./genezi
    ./glogin.sql
    ./libclntsh.dylib
    ./libclntsh.dylib.12.1
    ./libclntshcore.dylib.12.1
    ./libnnz12.dylib
    ./libocci.dylib
    ./libocci.dylib.12.1
    ./libociei.dylib
    ./libocijdbc12.dylib
    ./libons.dylib
    ./liboramysql12.dylib
    ./libsqlplus.dylib
    ./libsqlplusic.dylib
    ./ojdbc8.jar
    ./sqlplus
    ./uidrvci
    ./xstreams.jar
    
  5. Add this line to your ~/.bash_profile

    export PATH="$PATH:$HOME/bin/instantclient_12_2"
    
  6. Run source ~/.bash_profile

  7. Run sqlplus -V to confirm it’s installed