安裝PLSQL Developer 連接運(yùn)程Oracle 數(shù)據(jù)庫

PLSQL Developer 包含兩個(gè)部分一個(gè)是PLSQL Developer可視化界面，一個(gè)是instantclient客戶端

解壓縮包，壓縮包下面包含上面兩個(gè)內(nèi)容

圖1

在安裝目錄下，新建三個(gè)文件夾，用來放：客戶端環(huán)境，可視化界面安裝包，可視化界面安裝的目錄

圖2

在安裝包里面找到plsqldev906.exe雙擊進(jìn)行安裝

配置環(huán)境變量：

NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

TNS_ADMIN = E:\PLSQLDeveloper\SetUPOci\PLSQL\instantclient_11_2\network\admin

TNS_ADMIN是tnsnames.ora? 的父級(jí)目錄，為了能夠找數(shù)據(jù)庫；network\admin\tnsnames.ora文件是客戶端環(huán)境里面的文件，需要自己配置，下載的壓縮包沒有

tnsnames.ora文件里面的內(nèi)容

XKJ_101 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.101)(PORT = 1521))

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVER = DEDICATED)

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

XKJ_103 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.103)(PORT = 1521))

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVER = DEDICATED)

? ? ? (SERVICE_NAME = xkj103)

? ? )

? )

222.222.222.222 =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = 222.222.222.222)(PORT = 1521))

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVER = DEDICATED)

? ? ? (SERVICE_NAME = orcl)

? ? )

? )

圖3

圖4

在可視化界面里面進(jìn)行客戶端環(huán)境的配置引入

該路徑為oci.dll 的路徑E:\PLSQLDeveloper\SetUPOci\PLSQL\instantclient_11_2\oci.dll

圖5

圖6