Oracle TNS Listener

    原來只裝了個 oracle 9i的client. 後來有需要把server也裝上. 完成後
發現怎麼也連不上, 並且services列表裡面找不到 OracleOraHome92TNSListener   :-$
    同事告知, 有先例. 給了我一個reg文件:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListener]
"Type"=dword:00000010
"Start"=dword:00000003
"ErrorControl"=dword:00000001
"DisplayName"="OracleOraHome92TNSListener"
"ObjectName"="LocalSystem"
"ImagePath"="f:\\oracle\\ora92\\BIN\\TNSLSNR"

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListener\Security]
"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,40,e9,a7,63,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,40,e9,a7,63,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\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListener\Enum]
"0"="Root\\LEGACY_ORACLEORAHOME92TNSLISTENER\\0000"
"Count"=dword:00000001
"NextInstance"=dword:00000001


將以上內容存為一個.reg文件並執行之.
需要注意的地方
1.
"ImagePath"="f:\\oracle\\ora92\\BIN\\TNSLSNR"  要改為你的oracle安裝路徑.
2.
用services.msc管理啟動OracleOraHome92TNSListener 時會出現"指定裝置例項控制碼與目前裝置無關"的提示. 但不影響使用.