windows遠程連結oracle

標籤：

首先下載oracle用戶端

解壓在E:\oracleClient\instantclient_11_2該路徑下。進入到instantclient_11_2下建立目錄 NETWORK，然後再NETWORK下建立目錄ADMIN。在ADMIN目錄下建立tnsnames.ora檔案，在該tnsnames.ora檔案中添加 :

ECSTDBY =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ecstdby)    )  )          TEST =                           (DESCRIPTION =           (ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.1)(PORT = 1521))           (CONNECT_DATA =             (SERVER = DEDICATED)             (SERVICE_NAME = orcl)           )         )  

 192.168.0.11--為資料庫所在機器ip

 

環境變數的配置

在環境變數添加TNS_ADMIN，值為tnsnames.ora所在路徑。

如F:\oracleClient\instantclient_11_2\NETWORK\ADMIN\tnsnames.ora

 

設定ORACLE的語言，添加環境變數NLS_LANG，值為AMERICAN_AMERICA.AL32UTF8  

如果出現亂碼可用SIMPLIFIED CHINESE_CHINA.ZHS16GBK

下載並安裝PLSQL Developer

 

安裝完成後進入PLSQL Developer，選擇tools->preferences->connection

 

Oracle Home             

 

F:\oracleClient\instantclient_11_2

 

OCI library

 

F:\oracleClient\instantclient_11_2\oci.dll

 

 儲存,就可以使用了

 

windows遠程連結oracle