我們使用的系統是windows2000,經過優化后,oracle數據庫出現了問題,本地客戶端不能連接.但遠程連接是沒有問題的.
經過檢查,原來是oracle的tnslistener服務沒有起動.用"服務"起動,或者net start 起動均失敗,檢查結果是注冊表中
的tnslistener的執行文件路徑已經被刪除了.所以我們只要從其它安裝oracle服務器的電腦上將部分注冊表文件導出,
然后導入到本機就ok了.
下面是我本機的導入的注冊表內容.
----------
windows registry editor version 5.00
[hkey_local_machine ystem/controlset001 ervices/oracleorahome92tnslistener]
"type"=dword:00000010
"start"=dword:00000002
"errorcontrol"=dword:00000001
"imagepath"=hex(2):44,00,3a,00,5c,00,6f,00,72,00,61,00,63,00,6c,00,65,00,5c,00,/
6f,00,72,00,61,00,39,00,32,00,5c,00,42,00,49,00,4e,00,5c,00,54,00,4e,00,53,/
00,4c,00,53,00,4e,00,52,00,20,00,00,00
"displayname"="oracleorahome92tnslistener"
"objectname"="localsystem"
[hkey_local_machine ystem/controlset001 ervices/oracleorahome92tnslistener ecurity]
"security"=hex:01,00,14,80,a0,00,00,00,ac,00,00,00,14,00,00,00,30,00,00,00,02,/
00,1c,00,01,00,00,00,02,80,14,00,ff,01,0f,00,01,01,00,00,00,00,00,01,00,00,/
00,00,02,00,70,00,04,00,00,00,00,00,18,00,fd,01,02,00,01,01,00,00,00,00,00,/
05,12,00,00,00,00,00,00,00,00,00,1c,00,ff,01,0f,00,01,02,00,00,00,00,00,05,/
20,00,00,00,20,02,00,00,00,00,00,00,00,00,18,00,8d,01,02,00,01,01,00,00,00,/
00,00,05,0b,00,00,00,20,02,00,00,00,00,1c,00,fd,01,02,00,01,02,00,00,00,00,/
00,05,20,00,00,00,23,02,00,00,00,00,00,00,01,01,00,00,00,00,00,05,12,00,00,/
00,01,01,00,00,00,00,00,05,12,00,00,00
[hkey_local_machine ystem/controlset001 ervices/oracleorahome92tnslistener/enum]
"0"="root//legacy_oracleorahome92tnslistener//0000"
"count"=dword:00000001
"nextinstance"=dword:00000001
----------
將上面的內容拷貝到.txt文件中,然后將.txt改成.reg文件,雙擊該文件即可.
注意:我oracle執行文件安裝在d盤.如果不一樣的話,要將注冊表中的鍵值修改成正確就可以的了.
