我們使用的系統(tǒng)是windows2000,經(jīng)過優(yōu)化后,Oracle數(shù)據(jù)庫出現(xiàn)了問題,本地客戶端不能連接.但遠程連接是沒有問題的.經(jīng)過檢查,原來是oracle的TNSListener服務(wù)沒有起動.用'服務(wù)'起動,或者net start 起動均失敗,檢查結(jié)果是注冊表中 的TNSListener的執(zhí)行文件路徑已經(jīng)被刪除了.所以我們只要從其它安裝oracle服務(wù)器的電腦上將部分注冊表文件導(dǎo)出,然后導(dǎo)入到本機就OK了.下面是我本機的導(dǎo)入的注冊表內(nèi)容.----------Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE YSTEMControlSet001 ervicesOracleOraHome92TNSListener]'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 YSTEMControlSet001 ervicesOracleOraHome92TNSListener 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 YSTEMControlSet001 ervicesOracleOraHome92TNSListenerEnum]'0'='RootLEGACY_ORACLEORAHOME92TNSLISTENER000''Count'=dword:00000001'NextInstance'=dword:00000001----------將上面的內(nèi)容拷貝到.txt文件中,然后將.txt改成.reg文件,雙擊該文件即可.注重:我oracle執(zhí)行文件安裝在D盤.假如不一樣的話,要將注冊表中的鍵值修改成正確就可以的了.