Guide

You need to prepare something before actually can use this library.

First go to oracle instant client download page http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, click the link which name is operating system you used.

Then download 3 files from opened link.

• instant client basic
• instant client sqlplus
• instant client sdk

After that follow tutorial below.

---

Guide for OSX

Create new folder /Application/oracle, put these three files on it, and extract it as one folder. Then basic, sqlplus, and sdk.

Then run this commands.bbbb

cd /Application/oracle
unzip instantclient-basic-macos.x64-11.2.0.4.0.zip
unzip instantclient-sqlplus-macos.x64-11.2.0.4.0.zip
unzip instantclient-sdk-macos.x64-11.2.0.4.0.zip

Go to the extracted folder then create symbolic link for some libs.

cd instantclient_11_2
ln -s libclntsh.dylib.11.1 libclntsh.dylib
ln -s libocci.dylib.11.1 libocci.dylib

Export the path as variable ORACLE_HOME and on $PATH. You can put it on ~/.profile.

export ORACLE_HOME=/Applications/oracle/instantclient_11_2
export PATH=$PATH:$ORACLE_HOME

Now create new file called tnsnames.ora, put it on $ORACLE_HOME/network/admin. Create the folder first, if it does not exist. Fill the file with your tns configuration.

MY=(DESCRIPTION=
        (ADDRESS_LIST=
            (ADDRESS=
                (PROTOCOL=TCP)
                (HOST=192.168.0.1)
                (PORT=1521)
            )
        )
        (CONNECT_DATA=
            (SID=ORCL)
            (SERVER=DEDICATED)
            (SERVICE_NAME=orcl.my.local)
        )
    )

Try to run sqlplus command, it should work.

source ~/.profile
sqlplus scott/tiger@MY

Now we need to prepare some things to make go-oci8 worked.

Set variable DYLD_LIBRARY_PATH with value is $ORACLE_HOME. This variable required by go-oci8.

export DYLD_LIBRARY_PATH=$ORACLE_HOME:$DYLD_LIBRARY_PATH

Create new file oci8.pc, place it at $ORACLE_HOME/pkg. Create the folder if it does not exists. Then fill the file with these codes.

orainc=/Applications/oracle/instantclient_11_2/sdk/include
oralib=/Applications/oracle/instantclient_11_2

Name: oci8
Description: Oracle Instant Client
Version: 12.1
Cflags: -I${orainc}
Libs: -L${oralib} -lclntsh

The orainc should refer to $ORACLE_HOME/sdk/include, and the oralib should refer to $ORACLE_HOME itself.

After that, export the pkg folder.

export PKG_CONFIG_PATH=$ORACLE_HOME/pkg

Now try it sample code of go-oci8.

source ~/.profile
go get github.com/mattn/go-oci8
cd github.com/mattn/go-oci8/_example
go run oracle.go

---

Guide for Linux (ubuntu 14.04)

For install and setup oracle please follow this link http://blog.whitehorses.nl/2014/03/18/installing-java-oracle-11g-r2-express-edition-and-sql-developer-on-ubuntu-64-bit/

After success install oracle on your operation system, below is oci8 setup in order to use the go-oci8 library. Install PECL, Build Essential, Unzip, and the AIO Library

apt-get install build-essential unzip libaio1

Create new folder /opt/oracle.

mkdir /opt/oracle

Move basic, and sdk files from download directory.

mv instantclient-* /opt/oracle/

Navigate to oracle directory.

cd /opt/oracle/

Unzip it as one folder.

unzip instantclient-*

Rename the created directory.

mv instantclient_11_2 instantclient

Navigate to instant client direcotry and create the following soft links

ln -s libclntsh.so.11.2 libclntsh.so
ln -s libocci.so.11.2 libocci.so

cd to /opt Set the permission on oracle directory.

chown -R root:www-data oracle/

Add instant client to the ld config files

sudo sh -c "echo '/opt/oracle/instantclient' >> /etc/ld.so.conf.d/oracle-instantclient"

pdate the Dynamic Linker Run-Time Bindings

ldconfig

Install pkg-config if not installed

sudo apt-get install pkg-config

If you already set LD_LIBRARY_PATH before like this on ~/.bashrc.

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Change it to your instant client path.

export LD_LIBRARY_PATH=/opt/oracle/instantclient:$LD_LIBRARY_PATH
source ~/.bashrc

Create oci8.pc file in /usr/lib/pkgconfig and add below

sudo touch /usr/lib/pkgconfig/oci8.pc
sudo nano /usr/lib/pkgconfig/oci8.pc

# Package Information for pkg-config
prefix=/opt/oracle/instantclient
libdir=${prefix}
includedir=${prefix}/sdk/include/

Name: oci8
Description: oci8 library
Version: 12.1
Libs: -L${libdir} -lclntsh
Cflags: -I${includedir}

if have link error,check if instantclient package can be used for your system version and check pkg-config if correct.