linux go 连接oracle,Ubuntu14下golang连接oracle11g (OCI12.1方式)

最近业务需求连接oracle,把过程记录下来，给大家分享，已测试通过

1、下载及安装oracle instantclient12.1：

$ sudo alien -i oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

$ sudo alien -i oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm

$ sudo alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm

2、修改PATH环境变量：

$ vim ~/.profile

在文件地最后添加:

export ORACLE_HOME=/usr/lib/oracle/12.1/client64

export PATH=$PATH:$ORACLE_HOME/bin

export PKG_CONFIG_PATH=$ORACLE_HOME/lib/pkg-config

保存.profile

运行：source ~/.profile

3.设置oracle共享库:

$ sudo vim /etc/ld.so.conf

添加新行:

/usr/lib/oracle/12.1/client64/lib

$ sudo ldconfig

4.安装 libaio1.so

$ sudo apt-get install libaio1

5.设置编译环境几路径

$ sudo mkdir /usr/lib/oracle/12.1/client64/lib/pkg-config

$ sudo vim /usr/lib/oracle/12.1/client64/lib/pkg-config/oci8.pc

oci8.pc输入以下内容：

prefix=/usr

includedir=${prefix}/include/oracle/12.1/client64

libdir=${prefix}/lib/oracle/12.1/client64/lib

Name: oci12

Description: Oracle Instant Client

Version: 12.1

Cflags: -I${includedir}

Libs: -L${libdir} -lclntsh

6.安装golang for oci包

go get github.com/mattn/go-oci8

(完)