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)