title: What to do about "no ocijdbc11 in java.library.path" SQL Developer error
body: <p>I am trying to get create a TNS connection in SQL Developer on my mac laptop (OS X 10.9.5).
  I get this error <code>no ocijdbc11 in java.library.path</code> I googled around and found out that I need to
  install oracle's instant client.  I found the instance client files here :</p>
  
  <p><a href="http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html">http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html</a></p>
  
  <p>The files are just zip files that you need to download and extract somewhere.
  Then I found the instructions that actually tell you what to do with the zip files here:</p>
  
  <p><a href="https://docs.oracle.com/cd/E11882_01/install.112/e38228/inst_task.htm#BABHEBIG">https://docs.oracle.com/cd/E11882_01/install.112/e38228/inst_task.htm#BABHEBIG</a></p>
  
  <p>The instructions say that :</p>
  
  <blockquote>
    <p>Set the <code>DYLD_LIBRARY_PATH</code> and the <code>NLS_LANG</code> environment variables
    to the full path of the <code>instantclient_11_2</code> directory. For example,
    if you unzipped the Instant Client zip file in the <code>/bin/oracle</code>
    directory, then set the <code>DYLD_LIBRARY_PATH</code> environment variable to
    <code>/bin/oracle/instantclient_11_2</code>.</p>
  </blockquote>
  
  <p>What the instructions do not tell me is HOW to set environment variables permanently and how to make the environment variables accessible to GUI tools like SQL developer.</p>
  
  <p>Has anyone gotten SQL Developer to work with instantclient?</p>