下了mac后oracle进不去,Mac 下Golang连接Oracle以及遇到的坑。。

###一、下载oci和oci sdk

下载instantclient-basic和instantclient-sdk

两个都解压后，将instantclient-sdk解压出的sdk包放到instantclient-basic出来的目录中

最后的目录结构如下：

再次执行如下

mv -rf instantclient_12_1 /usr/local #移动到该目录

cd /usr/local/instantclient_12_1

mv libclntsh.dylib.* libclntsh.dylib

ln libclntsh.dylib /usr/lib/libclntsh.dylib

ln libocci.dylib.* /usr/lib/libocci.dylib.*

ln libociei.dylib /usr/lib/libociei.dylib

ln libnnz11.dylib /usr/lib/libnnz11.dylib

设置环境变量

export PKG_CONFIG_PATH="/usr/lib/pkgconfig"

export DYLD_LIBRARY_PATH=/usr/local/instantclient_12_1

###二、修改oci8.pc文件

vi /usr/lib/pkgconfig/oci8.pc #如果不存在就创建

填入以下内容

# Package Information for pkg-config

prefix=/usr/local/instantclient_12_1/

libdir=${prefix}

includedir=${prefix}/sdk/include/

Name: OCI

Description: Oracle database engine

Version: 12.1

Libs: -L${libdir} -lclntsh

Libs.private:

Cflags: -I${includedir}

###三、配置oracel客户端配置 创建一个tnsnames.ora(可以放到任意目录)

同时向该文件写入以下内容：

MPM =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.111)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = mpm)

)

)

#SERVICE_NAME 为库名

配置环境变量

export TNS_ADMIN="/Users/tian/java/oracle" #tnsnames.ora文件所在的目录

相关连接