今天遇到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服务便可运行。百度