本文共 1580 字，大约阅读时间需要 5 分钟。

00. 目录

01. 问题描述

第一次装Oracle和PLSQL Developer，在打开plsql登录后出现ORA-12541:TNS:no listener的错误

02. 问题分析

listener.ora配置文件中的host与Centos的不一致导致的。

03. 问题解决

3.1 修改配置文件listener.ora

[oracle@localhost ~]$ vim /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      # 此处的HOST改为0.0.0.0      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))    )  )ADR_BASE_LISTENER = /u01/app/oracle

3.2 修改配置文件tnsnames.ora

[oracle@localhost ~]$ gedit /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.LISTENER_ORCL =  #此处的HOST改为0.0.0.0  (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))ORCL =  (DESCRIPTION =    #此处的HOST改为0.0.0.0    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

3.3 重新启动lsnrctl

[oracle@localhost ~]$ lsnrctl stopLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-JUN-2020 20:57:01Copyright (c) 1991, 2009, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))The command completed successfully[oracle@localhost ~]$ [oracle@localhost ~]$ lsnrctl start

04. 结果验证

连接Ok.

05. 附录

5.1 【Tools】PLSQL Developer13.0.4注册和使用教程

参考：

转载地址：https://dengjin.blog.csdn.net/article/details/107050561 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！