作者專注于Java、架構、Linux、小程式、爬蟲、自動化等技術。 工作期間含淚整理出一些資料,微信搜尋【程式員高手之路】,回複 【java】【黑客】【爬蟲】【小程式】【面試】等關鍵字免費擷取資料。
目錄
前言
step1 複制network檔案
step2 修改配置檔案
2.1 修改oracle資料庫檔案
2.2 修改oracle資料庫檔案
2.3 修改用戶端檔案
step3 配置OCI
step4 環境變量配置
step5 重新開機電腦(有時候不需要重新開機)
step6 登入plsql!!!
前言
先贊後看,此生必賺!
每次安裝Oracle以後,都會出現使用plsql連接配接不上的問題!多次重新開機電腦、重裝系統的磨人經曆之後,
有木有想說句 TMD 平複一下心情?
先别罵!今天看到這篇文章算是你我之幸!希望能幫助廣大技術人員減少一些時間,順利進行連接配接!
注:也可以用plsql連接配接遠端資料庫(隻要有oracle的network\admin\tnsnames.ora就行)。
首先下載下傳64位oracle以及32位輕量級用戶端(注意版本的對應,我用的是11g的oracle和11.2的用戶端):
點選進入oracle下載下傳頁面 點選進入用戶端下載下傳頁面
以下步驟請自行更改路徑,不然,出錯了别怪我哦:
step1 複制network檔案
oracle安裝到某路徑下,安裝步驟很簡單,網上可以搜到!
用戶端随便解壓到一個路徑,我的是放在D:\app\shuhao\instantclient_11_2了。
然後把oracle中的D:\app\shuhao\product\11.2.0\dbhome_1裡面的整個network檔案夾複制,
粘貼到用戶端檔案夾D:\app\shuhao\instantclient_11_2下面,如下圖所示:
step2 修改配置檔案
2.1 修改oracle資料庫檔案
D:\app\shuhao\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora檔案内容,添加一個SID_DESC:
# listener.ora Network Configuration File: D:\app\shuhao\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\shuhao\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\shuhao\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
#下面的SID_DESC是新增加的内容,注意修改ORACLE_HOME路徑
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\app\shuhao\product\11.2.0\dbhome_1)
(GLOBAL_DBNAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\shuhao
2.2 修改oracle資料庫檔案
D:\app\shuhao\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora檔案内容,源檔案沒有做改動:
# tnsnames.ora Network Configuration File: D:\app\shuhao\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
2.3 修改用戶端檔案
D:\app\shuhao\instantclient_11_2\network\admin\tnsnames.ora檔案内容:
# tnsnames.ora Network Configuration File: D:\app\shuhao\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
#新增 @ 辨別符,用于區分本地與遠端oracle
[email protected] =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.164)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
step3 配置OCI
不登入plsql,直接按Cancel,進入後在Tools--->Preferences---->Connection中配置OCI為32位用戶端的OCI
D:\app\shuhao\instantclient_11_2\oci.dll
step4 環境變量配置
添加前2個系統變量:
1. 變量名:TNS_ADMIN
變量值:D:\app\shuhao\instantclient_11_2\network\admin
2. 變量名:NLS_LANG
變量值:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3. Path中配置加入:
D:\app\shuhao\product\11.2.0\dbhome_1\BIN;D:\app\shuhao\instantclient_11_2;
step5 重新開機電腦(有時候不需要重新開機)
啟動oracle服務與監聽,這個就不需要描述了。
step6 登入plsql!!!
當看到Database下拉框中有本地的ORCL以及遠端的[email protected]就算成功了!!!
OK, GAME OVER !
更多内容,請關注公衆号:程式員高手之路
在公衆号回複:Oracle資源 即可免費擷取Oracle視訊教程!