Oracle用戶端的安裝

標籤：

首先Orcale的安裝應該是很簡單的，安裝不好只是部熟悉，在其中遇見的一些問題記錄下來，如果以後忘記了還可以看看。

首先最大的問題是安裝用戶端的時候要安裝32位的，不管你的作業系統是32位還是64位的。

然後安裝好後需要配置一些配置資訊 E:\app\John\product\11.2.0\client_1\NETWORK\ADMIN 找到這個目錄下的tnsnames.ora 檔案

 tnsnames.ora Network Configuration File: D:\app\wang\product\11.1.0\client_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORA_6.175 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.59.6.175)(PORT = 1521))    )    (CONNECT_DATA =      (SID = ORCL)    )  )orcl_192.168.200.146 =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.146)(PORT = 1521))     )     (CONNECT_DATA =       (SID = orcl)     )   )ORA_6.226 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.59.6.226)(PORT = 1521))    )    (CONNECT_DATA =      (SID = ORCL)    )  )ORA_175 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.59.6.175)(PORT = 1521))    )    (CONNECT_DATA =      (SID = orclcs)    )  )ORCL_110 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    )    (CONNECT_DATA =      (SID = orcl110)    )  )ZBDBRAC =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.59.6.227)(PORT = 1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.59.6.228)(PORT = 1521))      (LOAD_BALANCE = yes)    )    (CONNECT_DATA =      (SERVICE_NAME = zbdbrac)    )  )

　　像這樣配置 將Host改成你需要已連線的服務器地址。

Oracle用戶端的安裝