OracleOraHome92TNSListener無法啟動
作者:duanlangjun
OracleOraHome92TNSListener無法啟動
打開注冊表（regedit）找到
HKEY_LOCAL_MACHINE/SYSTEM/CurrentContorlSet/
Services/OracleOraHome92TNSListener找到后單擊
在右側里面單擊右鍵，新建一個（可擴充字符串值）
起名字為 ImagePath 在 數值數據 中寫入
C:\oracle\ora92\BIN\TNSLSNR 后退出注冊表，
重新啟動即可。
還有一種造成本地oracle無法啟動的原因是安裝時的主機名與當前主機名不同，也就是說安裝完oracle后更改了主機名造成。
將配置文件中的主機名修改成 localhost 或 127.0.0.1就可以永久解決主機名造成的無法啟動。
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
我補充的一些資料
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"=hex(2):43,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,00,00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListener\Enum]
"0"="Root\\LEGACY_ORACLEORAHOME92TNSLISTENER\\0000"
"Count"=dword:00000001
"NextInstance"=dword:00000001
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListener\Security]
"Security"=hex:01,00,14,80,90,00,00,00,9c,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,60,00,04,00,00,00,00,00,14,00,fd,01,02,00,01,01,00,00,00,00,00,\
? 05,12,00,00,00,00,00,18,00,ff,01,0f,00,01,02,00,00,00,00,00,05,20,00,00,00,\
? 20,02,00,00,00,00,14,00,8d,01,02,00,01,01,00,00,00,00,00,05,0b,00,00,00,00,\
? 00,18,00,fd,01,02,00,01,02,00,00,00,00,00,05,20,00,00,00,23,02,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
注冊表文件
另外配置文件
位置
C:\oracle\ora92\network\ADMIN
查看 host 主機就是你的本機的名字 你可以改成你的ip 127.0.0.1
listener.ora
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
? (DESCRIPTION_LIST =
??? (DESCRIPTION =
????? (ADDRESS_LIST =
??????? (ADDRESS = (PROTOCOL = TCP)(HOST = MICROSOF-363)(PORT = 1521))
????? )
????? (ADDRESS_LIST =
??????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
????? )
??? )
? )
SID_LIST_LISTENER =
? (SID_LIST =
??? (SID_DESC =
????? (SID_NAME = PLSExtProc)
????? (ORACLE_HOME = C:\oracle\ora92)
????? (PROGRAM = extproc)
??? )
? )
另外一個文件直接關系到服務
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
DEV =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.89.206)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVICE_NAME = idmpdev)
??? )
? )
THINK =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVICE_NAME = think)
??? )
? )
INST1_HTTP =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = MICROSOF-365DB3)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVER = SHARED)
????? (SERVICE_NAME = MODOSE)
????? (PRESENTATION =
http://hrservice/)
??? )
? )
EXTPROC_CONNECTION_DATA =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
??? )
??? (CONNECT_DATA =
????? (SID = PLSExtProc)
????? (PRESENTATION = RO)
??? )
? )
oracle 輔助工具。。
Net Manager (2)
Net Configuration Assistant (2)
?