ORA-12541:TNS no Listener 服务启动了,监听配置删除重新配置过,依然报错

lvsm2018 2016-05-23 10:38:17
RT,有遇到这种问题的大侠吗?急,求帮助
...全文
392 5 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
lvsm2018 2016-05-23
  • 打赏
  • 举报
回复
没人知道吗?
lvsm2018 2016-05-23
  • 打赏
  • 举报
回复
这是lintener.ora 内容 # listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-CDH6QPUBF7T)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = D:\app\Administrator
lvsm2018 2016-05-23
  • 打赏
  • 举报
回复
这是tnsnames.ora内容: # tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. JJ = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.199)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.199)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
ghx287524027 2016-05-23
  • 打赏
  • 举报
回复
将LISTENER 也按SID_LIST_LISTENER一样,加上一些配置信息。或者把listener放到SID_LIST_LISTENER前面试试
Z_B_Hrunqian 2016-05-23
  • 打赏
  • 举报
回复
有没有lsnrctl status查看下监听的状态,以及监听里面注册了哪些服务?

17,140

社区成员

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧