PHP+IIS7配置OCI8鏈接Oracle 10G的方法

更新時(shí)間：2016年07月20日 21:05:51 投稿：mdxy-dxy

安裝很簡(jiǎn)單，主要是配置OCI8擴(kuò)展的時(shí)候需要配置幾個(gè)環(huán)境變量，網(wǎng)上下載的InstantClient傻瓜包是把環(huán)境變量配置在PATH里面的，那樣需要使用iisreset重啟IIS才能讀取到，而且全局的變量會(huì)影響系統(tǒng)內(nèi)其他Oracle軟件的行為，我建議是這樣的

1. 下載適用于Oracle10G的 Instant Client Package 32Bit,instantclient-basic-win32-10.2.0.5.zip，（如果你是64Bit系統(tǒng)，下載）,解壓。

2.如果不修改系統(tǒng)PATH，那么解壓出來(lái)的9個(gè)文件，全部放到php的bin目錄下，也就是含有php二進(jìn)制文件的那個(gè)目錄下，如果有潔癖，那就改個(gè)PATH。

3.在IIS的FASTCGI下面選擇環(huán)境變量編輯添加如下三個(gè)變量

復(fù)制代碼代碼如下:

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

ORACLE_HOME=\path\to\php-bin

TNS_ADMIN=\path\to\the-location-of-tnsnames.ora-file

4.在php.ini里面把php_oci8.dll擴(kuò)展啟用

5.結(jié)束掉老的php-cgi進(jìn)程重新訪問(wèn)就可以了

番外：

PHP官方對(duì)于Oracle的連接時(shí)候的一些變量有說(shuō)明，這里的環(huán)境變量，除了ORACLE_HOME之類的也不是必須的，官方都有對(duì)應(yīng)的寫法，可以看說(shuō)明

Common Oracle Environment Variables
NAME	PURPOSE
ORACLE_HOME	Contains the directory of the full Oracle Database software. Do not set this when using Oracle Instant Client as it is unnecessary and may cause installation problems.
ORACLE_SID	Contains the name of the database on the local machine to be connected to. There is no need to set this if you using Oracle Instant Client, or always pass the connection parameter tooci_connect().
LD_LIBRARY_PATH	Set this (or its platform equivalent, such as DYLD_LIBRARY_PATH, LIBPATH, or SHLIB_PATH) to the location of the Oracle libraries, for example $ORACLE_HOME/lib or/usr/lib/oracle/11.1/client/lib. This variable is not needed if the libraries are located by a different search mechanism, such as with ldconfig or with LD_PRELOAD.
NLS_LANG	This is the primary variable for setting the character set and globalization information used by the Oracle libraries.
ORA_SDTZ	Sets the Oracle session timezone.
TNS_ADMIN	Contains the directory where the Oracle Net Services configuration files such as tnsnames.ora and sqlnet.ora are kept. Not needed if the oci_connect() connection string uses the Easy Connect naming syntax such as localhost/XE. Not needed if the network configuration files are in one of the default locations such as $ORACLE_HOME/network/admin or /etc.

Less frequently used Oracle environment variables include TWO_TASK, ORA_TZFILE, and the various Oracle globalization settings like NLS* and the ORA_NLS_* variables.

oci_connect的時(shí)候，如果使用完整的TNS語(yǔ)法或者簡(jiǎn)略的寫法，比如8.8.8.8/abc的時(shí)候，TNS_ADMIN也不是必須的。具體的還是看官方文檔吧，不多說(shuō)了。

您可能感興趣的文章: