Oracle监听服务无法启动

时间:2021-04-23 08:40:28
安装好 Oracle后,启动Net Manager ,测试orcl失败,报错“ ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 ,需要修改监听文件。
修改前: # listener.oraNetworkConfigurationFile:D:\Soft\oracle10g\listener.ora# GeneratedbyOracle configurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=CLRExtProc)(ORACLE_HOME=D:\Oracle11g\product\11.2.0\dbhome_1)(PROGRAM=extproc)(ENVS="EXTPROC_DLLS=ONLY:D:\Oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll")))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.12.31)(PORT=1521))))ADR_BASE_LISTENER=D:\Oracle11g 修改后:# listener.oraNetworkConfigurationFile:D:\Soft\oracle10g\listener.ora# GeneratedbyOracle configurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=CLRExtProc)(ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1)(PROGRAM=extproc))(SID_DESC=(GLOBAL_DBNAME=ORCL)(ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1)(SID_NAME=ORCL)))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.12.31)(PORT=1521))))ADR_BASE_LISTENER=D:\app\Administrator这样修改之后貌似都没问题了。