linux数据库no tns,ORA-12541: TNS:no listener

今天启用Rman 连接数据库报错 ORA-12541: TNS:no listener，开始怀疑监听没有开启于是 lsnrctl status 查看[oracle@linux ~]$ lsnrctl status listenerLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUL-2010 12:55:27Copyright..

忧伤的狂人

676人浏览 · 2021-05-09 07:56:25

忧伤的狂人 · 2021-05-09 07:56:25 发布

今天启用Rman 连接数据库报错 ORA-12541: TNS:no listener，开始怀疑监听没有开启于是 lsnrctl status 查看

[oracle@linux ~]$ lsnrctl status listener

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUL-2010 12:55:27

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.109)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 04-JUL-2010 11:52:45

Uptime 0 days 1 hr. 2 min. 41 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.109)(PORT=1521)))

Services Summary...

Service "orcl" has 2 instance(s).

Instance "orcl", status UNKNOWN, has 2 handler(s) for this service...

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orcl_XPT" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

但是再次连接依然报错

[oracle@linux ~]$ rman target

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jul 4 12:32:52 2010

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-12541: TNS:no listener

于是查看 $ORACLE_HOME/network/admin/listner.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = orcl)

(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

(SID_NAME = orcl)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.109)(PORT = 1521))

)

查看 tnsname.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

经仔细查看没有错误于是想到netca的配置问题，进入Linux 开启图形界面

选中本地net服务名配置，重新配置net服务名 orcl --&gttcp协议--&gt主机名--是，进行测试--&gt以system用户连接--&gt配置完成

再次以 rman target 登录

[oracle@linux ~]$ rman target

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jul 4 13:05:06 2010

connected to target database: ORCL (DBID=1250979061)

登录成功

腾讯云开发者社区

腾讯云面向开发者汇聚海量精品云计算使用和开发经验，营造开放的云计算技术生态圈。

更多推荐

Springboot+MySQL 实现从数据库获取数据展示到前端

1.运行效果效果图如下：2.创建数据库表数据库名为"springboot",数据库表名为"user"，数据库表里面放了5条数据，字段分别为：“id”，“name”，“age”，“email”。3.新建SpringBoot项目1、选择Spring Initial...

腾讯云开发者社区

数据库实验二数据库的简单查询和连接查询实验

– l）用Transact-SQL语句表示下列操作．在学生选课库中实现其数据查询操作．– ①求数学系学生的学号和姓名。select sno,sname from student where sdept='MA';– ②求选修了课程的学生学号。select distinct sno from sc;– ③求选修C1课程的学生学号和成绩，并要求对查询结果按成绩降序排列，如果成绩相同则按学号升序排列。s

腾讯云开发者社区

Spring Boot Mybatis数据库datasource多数据源配置

application.yaml文件配置spring:datasource:db1:driver-class-name: com.mysql.cj.jdbc.Driverjdbc-url: jdbc:mysql://192.168.0.1:3306/ellassay_dev?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBe