TNS

[SummerBreezeDD]

SQL PLUS可以正常登陆：

SQL*Plus: Release 12.1.0.2.0 Production on 星期日 2月 11 12:51:27 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

请输入用户名: duan
输入口令:
上次成功登录时间: 星期日 2月 11 2018 12:40:16 +08:00

连接到:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options




监听服务启动报错：
C:\Users\SummerBreezeDD>lsnrctl start

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 11-2月 -2018 12:51:03

Copyright (c) 1991, 2014, Oracle. All rights reserved.

启动tnslsnr: 请稍候...

Unable to OpenSCManager: err=5
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误

同时DEVELOPER报错：


求助众大神帮忙。

[SummerBreezeDD]

检查了Listener和Tnsnames，内容分别如下： # listener.ora Network Configuration File: E:\Oacle\product\12.1.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\Oacle\product\12.1.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\Oacle\product\12.1.0\dbhome_1\bin\oraclr12.dll") ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\Oacle\product\12.1.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\Oacle\product\12.1.0\dbhome_1\bin\oraclr12.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MSI)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) # tnsnames.ora Network Configuration File: E:\Oacle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )