使用 github.com/mattn/go-oci8 库连接oralce,以下主要记录环境配置过程
1.首先安装oracle客户端:
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
rpm -ivh 依次安装,默认安装路径: /usr/lib/oracle/11.2/client64
2.查找pkg-config所在目录,一般在/usr/bin下,个人习惯使用/usr/local/bin,没有的话需要下载安装 https://pkg-config.freedesktop.org/releases/pkg-config-0.29.2.tar.gz
3.新建oci8.pc,以支持连接oracle,文件和pkg-config同目录,主要标识了客户端所在目录和oracle版本:
prefix=/usr
includedir=${prefix}/lib/oracle/11.2/client64
libdir=${prefix}/lib/oracle/11.2/client64/lib
Name: oci8
Description: Oracle Instant Client
Version: 11.2
Cflags: -I${includedir}
Libs: -L${libdir} -lclntsh
4.编辑/etc/profile
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export PKG_CONFIG_PATH=/usr/local/bin
5.source /etc/profie使配置生效即可