00. 目录
文章目录
00. 目录01. 问题描述02. 问题分析03. 问题解决04. 结果验证05. 附录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- 20:57:01Copyright (c) 1991, , 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注册和使用教程
参考:/dengjin4042056/article/details/107029452