How to install Oracle SQLPlus and Oracle Client in MAC OS


The How To has been extracted from the following link:

I just skipped some text and modified some paths to adapt it to oracle client release.


1. Download the files from the Oracle Site

Be sure to grab the following two files:

  • Instant Client Package – Basic
  • Instant Client Package – SQL*Plus

2. Extract the files and create the proper folder structure.

Open a Terminal window and unzip the downloaded files.

$ unzip -qq

$ unzip -qq

Note: The -qq flag will tell the unzip utility to run in quieter mode, preventing any output from being displayed on the screen.

By default, the archive will extract all these files to a single directory. Instead, we’ll create a nicely structured directory to keep these files in your user Applications folder.

$ mkdir -p /Applications/oracle/product/instantclient_64/

$ mkdir -p /Applications/oracle/product/instantclient_64/

$ mkdir -p /Applications/oracle/product/instantclient_64/

$ mkdir -p /Applications/oracle/product/instantclient_64/

$ mkdir -p /Applications/oracle/product/instantclient_64/

$ mkdir -p /Applications/oracle/product/instantclient_64/

Next, move the files over to these directories as follows:

$ cd instantclient_11_2

$ mv ojdbc* /Applications/oracle/product/instantclient_64/

$ mv x*.jar /Applications/oracle/product/instantclient_64/

$ mv glogin.sql /Applications/oracle/product/instantclient_64/

$ mv *dylib* /Applications/oracle/product/instantclient_64/

$ mv *README /Applications/oracle/product/instantclient_64/

$ mv * /Applications/oracle/product/instantclient_64/

3. Create a proper tnsnames.ora file to define proper connection strings

Copy or create a tnsnames.ora file to /Applications/oracle/product/instantclient_64/


Create the tnsnames.ora file with the vi editor, paste the following lines and save it.











    )  )

(You can better ask to a DBA to review the content of this file and ask her to provide you with a proper test connection)

4. Set up environment variables

Edit or create a file .bash_profile

$ cd /Users/UserName

$ vi ~/.bash_profile

if you haven’t created a .bash_profile before the file will be empty, otherwise just add the following lines to the end of the existing file.

export ORACLE_HOME=/Applications/oracle/product/instantclient_64/



To load this profile, run the following command:

$ source ~/.bash_profile

Assuming you have set up your tnsnames.ora file correctly, you should now be able to connect one of the databases as follows:

5. Start using SQLPlus

$ sqlplus username/password@database

6. Did you enjoy? That’s all folks.



Fixing command history for using SQLPlus line edition with arrow keys

If you have used the command-line SQLPlus in a Windows environment, you will probably be used to using the command history to execute previous SQL statements using the arrow keys. One thing you’ll notice in SQLPlus for the Mac is that this doesn’t work by default, if you hit the up key you’ll see a strange character sequence ^[[A rather than the previous command. Let’s go ahead and fix this now.

To do this, you’ll need to use rlwrap. You could download this from source and build it yourself, but I find it much easier to use the fantastic brew package manager for Mac OS X. Head over to and follow the instructions to install and set up Homebrew (it’s very easy). With Homebrew installed, you can now easily install rlwrap on your system with one command:

$ ruby -e “$(curl -fsSL”

$ brew install rlwrap

The final thing you need to do is tell your system to use rlwrap whenever you use SQL*Plus. To do that, you’ll need to edit your .bash_profile file again.

$ vi ~/.bash_profile

Add the following line to the end of the file.

alias sqlplus=’rlwrap sqlplus’

Now reload the .bash_profile:

$ source ~/.bash_profile

Now, when you launch SQL*Plus and try to use the arrow keys to access previous commands, it will work.

Apache server on Mac OS

Manage the Apache server

Terminal Commands

  • Starting:  $sudo apachectl start
  • Stopping: $sudo apachectl stop
  • Restarting: $sudo apachectl restart

Adding the Web Sharing option in Systems Preferences:

Configuring Sites folder

By default, Apache serves files that are in the folder location “/Library/WebServer/Documents”.
On a multiple users system, you can setup the web server to serve files for different users
using the URL “http://localhost/~tomeu.mir“.

1. create a folder Sites in /Users/tomeu.mir
$mkdir /Users/tomeu.mir/Sites

2. create a tomeu.mir.conf file in the apache server users folder:
$sudo vi /etc/apache2/users/tomeu.mir.conf

and copy and paste the following code to the conf file.

<Directory “/Users/tomeu.mir/Sites/”>
Options Indexes MultiViews
AllowOverride All
Order allow,deny
Allow from all

3. test it

create a test html file and place it in /Users/tomeu.mir/Sites/

$cd /Users/tomeu.mir/Sites/
$vi myTest.html

insert your html test code and save it.

<html><body><h1>My site works cojones</h1></body></html>

Go to your browser and type: http://localhost/~tomeu.mir/myTest.html