# mac 安装oracle-client遇到的问题，适合M芯片

官网下载

oracle官网下载client 地址:
https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html

一定要下载此版本：instantclient-basic-macos.x64-11.2.0.4.0.zip

1、先解压instantclient-basic-macos.x64-11.2.0.4.0.zip
解压命令：
unzip instantclient-basic-macos.x64-11.2.0.4.0.zip
2、解压后会在"访达-个人"新增一个instantclient_11_2目录

3、在"访达-个人"里新建/opt/orcle/目录，并将上步解压后的文件夹复制在orcle目录里。

四、.bash_profile配置文件

cd ~
vim .bash_profile
export ORACLE_HOME=/Users/zhouyajie/opt/orcle/instantclient_12_1
export PATH=$PATH:$ORACLE_HOME
export DYLD_LIBRARY_PATH=$ORACL{E}_{H}OME:$DYLD_LIBRARY_PATH
source ~/.bash_profile

或者
cd ~
vim .bash_profile
DYLD_LIBRARY_PATH=“/opt/orcle/instantclient_11_2”
export DYLD_LIBRARY_PATH
export ORACLE_HOME=$DYL{D}_{L}IBRAR{Y}_{P}ATHexportPATH=$PATH:$ORACLE_HOME

echo source ~/.bash_profile >> ~/.zshrc
source .zshrc

五、最重要的一步骤

1.创建mkdir ~/lib （文件夹创建在访达-个人里了）
2. cp ~/opt/orcle/instantclient_11_2/lib* ~/lib

问题解决：

1.ORA-00000: DPI-1047: Cannot locate a 64-bit Oracle Client library: “dlopen(/Users/个人用户/opt/orcle/instantclient_19_16/lib/libclntsh.dylib, 1): __dyld section not supported in /Users/个人用户//opt/orcle/instantclient_19_16/libnnz19.dylib”. See https://oracle.github.io/odpi/doc/installation.html#macos for help
此问题是版本和系统不一致导致，重新下载别的版本试一试

2.ORA-24408: could not generate unique server group name

解决此问题需要增加/etc/hosts 文件里的映射
例如 127.0.0.1 主机名（在系统偏好设置-共享中可查看）

3.DPI-1047: Cannot locate a 64-bit Oracle Client library: “dlopen(libclntsh.dylib, 1): image not found”. See https://oracle.github.io/odpi/doc/installation.html#macos for help

解决此问题1.环境变量未设置正确，

4.ORA-00000: DPI-1047: Cannot locate a 64-bit Oracle Client library: “dlopen(libclntsh.dylib, 1): __dyld section not supported in /usr/local/lib/instantclient_19_16/libnnz19.dylib”. See https://oracle.github.io/odpi/doc/installation.html#macos for help
解决此问题：上述第五步未拷贝正确

参考：https://blog.csdn.net/weixin_45715405/article/details/121930736