Oracle instant client,連線oracle資料庫的客戶端。配置如下:
然後在系統環境變數中配置Path,新增instantclient的路徑,即C:\oracle\instantclient_11_2; 增加環境變數: NLS_LANG=AMERICAN_AMERICA.ZHS16GBK TNS_ADMIN=C:\Oracle\instantclient_11_2 最後,在“TNS_ADMIN”的路徑下增加一個tnsnames.ora檔案,這個檔案可以直接從已安裝的Oracle的目錄中複製,或者使用如下示例: # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora # Generated by Oracle configuration tools. #sample ORCL_100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.100)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 配置完成後,啟動PLSQLDev,登入資料庫成功。
Oracle instant client,連線oracle資料庫的客戶端。配置如下:
然後在系統環境變數中配置Path,新增instantclient的路徑,即C:\oracle\instantclient_11_2; 增加環境變數: NLS_LANG=AMERICAN_AMERICA.ZHS16GBK TNS_ADMIN=C:\Oracle\instantclient_11_2 最後,在“TNS_ADMIN”的路徑下增加一個tnsnames.ora檔案,這個檔案可以直接從已安裝的Oracle的目錄中複製,或者使用如下示例: # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora # Generated by Oracle configuration tools. #sample ORCL_100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.100)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 配置完成後,啟動PLSQLDev,登入資料庫成功。