解决 - OracleOraDb11g_home1TNSListener服务启动后中止

今天遇到OracleOraDb11g_home1TNSListener服务启动不了的问题,百度了各类方法,总算结合出一个靠谱的步骤。spa

1. 配置Oracle的listener.ora文件code

安装路径下\product\11.2.0\dbhome_1\NETWORK\ADMIN目录下,其中listener修改成:blog

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机全名)(PORT = 1521)) ) )

安装路径下\product\11.2.0\dbhome_1\NETWORK\ADMIN目录下,其中tnsnames修改成:cmd

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机全名)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

2. 修改注册表 register( cmd --> regedit)it

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/services/OracleOraDb11g_home1TNSListener中的ImagePath改成:class

安装路径下\product\11.2.0\dbhome_1\BIN\TNSLSNR.EXE (以前后面的.EXE没有)

3. 配置环境变量变量

ORACLE_HOME:安装路径下\product\11.2.0\dbhome_1

4. 重启OracleServiceORCL服务,再启动OracleOraDb11g_home1TNSListener服务便可运行。百度