windows最佳化系統後oracle9i本地串連失敗
來源：互聯網
上載者：User
oracle|window|最佳化
我們使用的系統是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盤.如果不一樣的話,要將註冊表中的索引值修改成正確就可以的了.
