macOS Sierra + Homebrew + PHP 7 + OCI8安装

摘要：中间两个符号链接如果不建立，会加载失败，提示找不到对应的文件。后面两个符号链接如果不建立，今后在执行的过程中函数会抛异常。如果今后依然遇到其他失败的信息，则以此类推，将目录下的文件都在下建立符号链接即可。

先这样安装PHP：

brew install php71 --with-gmp --with-homebrew-curl --with-homebrew-libxml2 --with-imap --with-pear

然后去Oracle官网下载InstantClient相关的三个包，一个是Basic，一个是SQLPlus，还有一个是SDK：

instantclient-basic-macos.x64-11.2.0.3.0
instantclient-sqlplus-macos.x64-11.2.0.3.0
instantclient-sdk-macos.x64-11.2.0.3.0

下载后把这三个包里的内容都解压放到一个目录下，假设是/usr/local/instantclient，然后建立几个符号链接，之后的编译和最后生成的oci8.so文件会用到：

ln -s /usr/local/instantclient/libclntsh.dylib.11.1 /usr/local/instantclient/libclntsh.dylib
ln -s /usr/local/instantclient/libclntsh.dylib.11.1 /usr/local/lib/
ln -s /usr/local/instantclient/libnnz11.dylib /usr/local/lib/
ln -s /usr/local/instantclient/libocci.dylib.11.1 /usr/local/lib/
ln -s /usr/local/instantclient/libociei.dylib /usr/local/lib/

注意：其中第一个符号链接如果不建立，编译的时候会出错。中间两个符号链接如果不建立，oci8.so会加载失败，提示找不到对应的dylib文件。后面两个符号链接如果不建立，今后在执行PHP的过程中oci_connect()函数会抛异常。如果今后依然遇到其他失败的信息，则以此类推，将instantclient目录下的dylib文件都在/usr/local/lib下建立符号链接即可。如果想简单粗暴一些，那也可以把instantclient下的dylib文件都拷贝到/usr/local/lib下

然后安装OCI8：

pecl install oci8

在提示输入instantclient目录位置的地方，输入instantclient,/usr/local/instantclient，像这样：

downloading oci8-2.1.3.tgz ...
Starting to download oci8-2.1.3.tgz (191,920 bytes)
.........................................done: 191,920 bytes
10 source files, building
running: phpize
Configuring for:
PHP Api Version:         20160303
Zend Module Api No:      20160303
Zend Extension Api No:   320160303
Please provide the path to the ORACLE_HOME directory. Use "instantclient,/path/to/instant/client/lib" if you"re compiling with Oracle Instant Client [autodetect] : instantclient,/usr/locall/instantclient

然后pecl就会编译并安装oci8.so文件。最后可能会遇到这个错误：

Build process completed successfully
Installing "/usr/local/Cellar/php71/7.1.1_12/lib/php/extensions/no-debug-non-zts-20160303/oci8.so"

Fatal error: Uncaught Error: Call to a member function getFilelist() on null in /usr/local/Cellar/php71/7.1.1_12/lib/php/PEAR/Command/Install.php:747
Stack trace:
#0 /usr/local/Cellar/php71/7.1.1_12/lib/php/PEAR/Command/Common.php(270): PEAR_Command_Install->doInstall("install", Array, Array)
#1 /usr/local/Cellar/php71/7.1.1_12/lib/php/pearcmd.php(316): PEAR_Command_Common->run("install", Array, Array)
#2 /usr/local/Cellar/php71/7.1.1_12/lib/php/peclcmd.php(31): require_once("/usr/local/Cell...")
#3 {main}
  thrown in /usr/local/Cellar/php71/7.1.1_12/lib/php/PEAR/Command/Install.php on line 747

不去管它，在/usr/local/etc/php/71/conf.d/目录下手工建一个ext-oci8.ini文件：

[oci8]
extension="/usr/local/Cellar/php71/7.1.1_12/lib/php/extensions/no-debug-non-zts-20160303/oci8.so"

注意：extension后面一定要写pecl安装的oci8.so文件所在的绝对路径，我之前写了相对路径，加载失败

然后执行php -i | grep oci8来验证是否安装成功：

hongliang@macmini2012 ~ $ php -i | grep oci8
/usr/local/etc/php/7.1/conf.d/ext-oci8.ini,
oci8
oci8.connection_class => no value => no value
oci8.default_prefetch => 100 => 100
oci8.events => Off => Off
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => Off => Off
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20

然后重启php-fpm：

brew services restart php71

然后随便写一个php文件，输出phpinfo()内容，如果看到oci8相关的参数，那就说明安装成功了

另外，如果访问Oracle数据发生could not generate unique server group name错误，则：

sudo vi /etc/hosts

然后加入：

127.0.0.1 hostname

Oracle要求本机的hostname必须可以正确指向127.0.0.1本机IP。如果不确定本机hostname是多少，则在命令行里敲hostname就可以了