Linux安装Golang Oracle数据库驱动程序

Golang连接Oracle 需要安装Oracle Full Client或Instant Client

Oracle的Instant Client套件下载地址

1. #选择Instant Client for Linux x86-64下载包如下:
2. instantclient-basic-linux.x64-21.1.0.0.0.zip
3. instantclient-sqlplus-linux.x64-21.1.0.0.0.zip
4. instantclient-sdk-linux.x64-21.1.0.0.0.zip
6. #都解压到 instantclient_21_1 这个目录,直接解压会解压到instantclient_21_1目录
7. unzip instantclient-basic-linux.x64-21.1.0.0.0.zip
8. unzip instantclient-sdk-linux.x64-21.1.0.0.0.zip
9. unzip instantclient-sqlplus-linux.x64-21.1.0.0.0.zip
11. #打印instantclient_21_1目录的路径
12. pwd
13. /home/oracle/instantclient_21_1

安装pkg-config

CentOS自带了pkg-config,这里不在安装

1. #打印pkg-config版本
2. pkg-config --version

创建配置文件oci8.pc

vim /home/oracle/oci8.pc oci8.pc文件内容如下:

1. prefix=/home/oracle/instantclient_21_1
2. libdir=${prefix}
3. includedir=${prefix}/sdk/include/
5. glib_genmarshal=glib-genmarshal
6. gobject_query=gobject-query
7. glib_mkenums=glib-mkenums
9. Name: oci8
10. Description: oci8 library
11. Libs:-L${libdir}-lclntsh
12. Cflags:-I${includedir}
13. Version:21.1

配置环境变量

vim /etc/profile

在最后添加如下环境变量

1. # Oracle的OCI套件
2. export LD_LIBRARY_PATH=/home/oracle/instantclient_21_1
3. # oci8.pc文件所在路径
4. export PKG_CONFIG_PATH=/home/oracle
6. 使配置生效
7. source /etc/profile

运行Golang连接Oracle报错一:

1. # github.com/mattn/go-oci8
2. In file included from../github.com/mattn/go-oci8/c_helpers.go:3:0:
3. ./oci8.go.h:1:17: fatal error: oci.h:No such file or directory
4. #include<oci.h>
5. ^
6. compilation terminated.

是因为配置的环境变量,oci8.pc文件所在路径不对,找不到oci8.pc文件导致的 注意这个路径配置对 export PKGCONFIGPATH=/home/oracle

运行Golang连接Oracle报错二:

1. dyld:Librarynot loaded:@rpath/libclntsh.dylib.19.1
2. Referencedfrom:/var/folders/_f/n3km_s7j6_9f8qzpkf9w395h0000gn/T/go-build114883360/b001/exe/oracleoci8
3. Reason: image not found

添加软链接,解决报错

1. ln -s /home/oracle/instantclient_21_1/libclntsh.so.21.1/usr/lib/libclntsh.so
2. ln -s /home/oracle/instantclient_21_1/libocci.so.21.1/usr/lib/libocci.so
3. ln -s /home/oracle/instantclient_21_1/libociei.so /usr/lib/libociei.so
4. ln -s /home/oracle/instantclient_21_1/libnnz21.so /usr/lib/libnnz12.so

<audio controls="controls" style="display: none;"></audio>