不安裝oracle用戶端,用plsql串連oracle,oracleplsql
1.1. Instant Client 下載
官網:
http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html
下載instantclient-basic包,將包解壓存放到本地,本測試為D:\JavaEEServer\instantclient_10_2
1.2. 配置sqlnet.ora
sqlnet.ora(位於instantclient-basic下) |
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) |
1.3. 配置tnsnames.ora
tnsnames.ora(位於instantclient-basic下) |
#neikong為oracle服務執行個體名,根據自己實際情況填寫 neikong = (DESCRIPTION = (ADDRESS_LIST = #172.16.3.153根據實際情況填寫,如需修改連接埠號碼也可修改 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.153 )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = neikong ) ) ) |
1.4. 配置環境變數
變數名 |
TNS_ADMIN |
變數值 |
D:\JavaEEServer\instantclient_10_2 |
1.5. 配置PL/SQLDeveloper
安裝PL/SQL Developer,並配置oracle的串連參數:開啟PL/SQL,Tools-->Preferences,配置Connection的Oracle Home和OCI library,如所示
1.6. 重新啟動,輸入使用者名稱和密碼測試