如下:其中步驟2."將系統的tnsnames.ora複製到該目錄下",你可能沒有做好。
win64下使用PL/SQL Developer連線Oracle:
"1. 下載32位Oracle InstantClient,並展開到某目錄,例如C:\instantclient-basic-nt-11.2.0.2.0;
"2. 將系統的tnsnames.ora複製到該目錄下;
"3. 在PLSQL Developer中設定Oracle_Home和OCI Library:
Tools郟references郞racle郈onnection:
Oracle_Home: C:\instantclient-basic-nt-11.2.0.2.0
OCI Library: C:\instantclient-basic-nt-11.2.0.2.0\oci.dll
"4. 在PLSQL Developer目錄下新建如下bat檔案,替換其快捷方式,啟動PLSQL Developer:
@echo off
set path=C:\instantclient-basic-nt-11.2.0.2.0
set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe
如下:其中步驟2."將系統的tnsnames.ora複製到該目錄下",你可能沒有做好。
win64下使用PL/SQL Developer連線Oracle:
"1. 下載32位Oracle InstantClient,並展開到某目錄,例如C:\instantclient-basic-nt-11.2.0.2.0;
"2. 將系統的tnsnames.ora複製到該目錄下;
"3. 在PLSQL Developer中設定Oracle_Home和OCI Library:
Tools郟references郞racle郈onnection:
Oracle_Home: C:\instantclient-basic-nt-11.2.0.2.0
OCI Library: C:\instantclient-basic-nt-11.2.0.2.0\oci.dll
"4. 在PLSQL Developer目錄下新建如下bat檔案,替換其快捷方式,啟動PLSQL Developer:
@echo off
set path=C:\instantclient-basic-nt-11.2.0.2.0
set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe