Oracle Client 配置串連資料庫

1.下載

從http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html下載

Instant Client Package – Basic包( 標註:All files required to run OCI, OCCI, and JDBC-OCI applications)這裡下載的是Version 11.1.0.7

2.本地儲存Oracle Client Package:

建立檔案夾,比如oracle_client,將下載的檔案加壓縮到此檔案夾裡.(筆者目錄: D:\oracle_client\instantclient_10_2)

3.在目前的目錄下,建立立兩個檔案，sqlnet.ora和tnsnames.ora然後再手動設定sqlnet.ora和tnsnames.ora

比如這裡是:

sqlnet.ora檔案內容:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

 

tnsnames.ora檔案內容(斜體表示需要替換的內容):

orcl=

(DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

)

 

4.配置環境變數

變數名: TNS_ADMIN

變數值: D:\oracle_client\instantclient_10_2

否則出現:ORA-12154: TNS:could not resolve the connect identifier specified錯誤

 
解決中文亂碼問題
環境變數中新加：

變數名：NLS_LANG

變數值：AMERICAN_AMERICA.ZHS16GBK

 

如果之前安裝了Oracle 又卸載,會遺留NLS_LANG=NA的索引值.輸入RegEdit開啟註冊表HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE.在右面找到NLS_LANG=NA並刪除掉

否則會報ORA-12705: Cannot access NLS data files or invalid 錯誤.

 

5.安裝pl/sql軟體(過程略)

6.配置pl/sql的Oracle串連參數:

選擇pl/sql的工具/喜好設定(too/ preference/)裡的串連,在右面設定Oracle主目錄名(即安裝目錄)和OCI庫.

Oracle主目錄名: D:\oracle_client\instantclient_10_2

OCI庫: D:\oracle_client\instantclient_10_2\oci.dll

7.登陸pl/sql測試成功