今天遇到OracleOraDb11g_home1TNSListener服务启动不了的问题,百度了各种方法,总算结合出一个靠谱的步骤。
1. 配置Oracle的listener.ora文件
安装路径下\product\11.2.0\dbhome_1\NETWORK\ADMIN目录下,其中listener修改为:
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机全名)(PORT = 1521)) ) )
安装路径下\product\11.2.0\dbhome_1\NETWORK\ADMIN目录下,其中tnsnames修改为:
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 计算机全名)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
2. 修改注册表 register( cmd --> regedit)
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/services/OracleOraDb11g_home1TNSListener中的ImagePath改为:
安装路径下\product\11.2.0\dbhome_1\BIN\TNSLSNR.EXE (之前后面的.EXE没有)
3. 配置环境变量
ORACLE_HOME:安装路径下\product\11.2.0\dbhome_1
4. 重启OracleServiceORCL服务,再启动OracleOraDb11g_home1TNSListener服务即可运行。