ORA-12541:TNS:无监听

最新推荐文章于 2024-01-12 16:43:40 发布

sqlaowen

最新推荐文章于 2024-01-12 16:43:40 发布

阅读量475

点赞数 1

分类专栏： oracle

本文链接：https://blog.csdn.net/sqlaowen/article/details/52537185

版权

oracle 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">新安装oracle 11g, 重启机器后使用pl sql 连接提示ORA-12541:TNS:无监听, 而使用spl plus可以正常连接(说明服务运行正常...)</span>

百度, google 搜索解决方法都是重新配置监听程序, 结果重启还是ORA-12541:TNS:无监听
经过努力问题最终得到解决, 找到安装目录以下文件,将下面代码标红的换为机器名即可

\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

# listener.ora Network Configuration File: C:\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 = C:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = <strong><span style="color:#ff6666;">机器名</span></strong>)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\Administrator

\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <span style="font-family: Arial, Helvetica, sans-serif; "><strong><span style="color:#ff6666;">机器名</span></strong></span><span style="font-family: Arial, Helvetica, sans-serif;">)(PORT = 1521))</span>
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )