当前位置: 首页 > news >正文

oracle使用服务名链接报错ORA-12537: TNS:connection closed

数据库连接如下:

[oracle@rxrac02 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 1 15:41:30 2026Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing optionsSQL> SHOW PARAMETER service_names;NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      orcl
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@rxrac02 ~]$ sqlplus system/oracle@orclSQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 1 15:41:58 2026Copyright (c) 1982, 2013, Oracle.  All rights reserved.ERROR:
ORA-12537: TNS:connection closedEnter user-name: ^C^C

 

检查监听状态

[oracle@rxrac02 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 01-FEB-2026 15:43:00Copyright (c) 1991, 2013, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                01-FEB-2026 15:37:47
Uptime                    0 days 0 hr. 5 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rxrac02/listener/alert/log.xml
Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.112.112)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.112.114)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rxrac02 ~]$

 

报错google查询

文章如下:

https://doyensys.com/blogs/ora-12537-while-connecting-to-database/

 

检查oracle文件权限

 

rac集群两个节点更改oracle文件权限

[root@rxrac02 ~]# ls /u01/app/oracle/product/11.2.0/db_1/bin/oracle
/u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@rxrac02 ~]# ls -l /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwxrwsr-x 1 oracle asmadmin 239501488 2月   1 00:08 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@rxrac02 ~]# chmod 6751  /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@rxrac02 ~]# ls -l /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239501488 2月   1 00:08 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@rxrac02 ~]# ssh rxrac01
Last login: Sun Feb  1 15:32:55 2026 from rxrac02
[root@rxrac01 ~]# chmod 6751  /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@rxrac01 ~]#

发现oralce组权限多了一个w,修改后链接成功

[root@rxrac01 ~]# su - oracle
上一次登录:日 2月  1 15:27:46 CST 2026pts/0 上
[oracle@rxrac01 ~]$
[oracle@rxrac01 ~]$
[oracle@rxrac01 ~]$
[oracle@rxrac01 ~]$ sqlplus system/oracle@orclSQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 1 15:51:15 2026Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing optionsSQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@rxrac01 ~]$ sqlplus system/oracle@rac-scan:1521/orclSQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 1 15:51:31 2026Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing optionsSQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

 

http://www.jsqmd.com/news/329978/

相关文章:

  • 市场上排行前列的短视频矩阵厂商推荐,ai数字人矩阵/ai排名/矩阵/抖音短视频矩阵,短视频矩阵系统排行
  • Stable数组的使用
  • YOLO在Java中跑不起来?手把手教你解决CUDA兼容性问题(附GPU推理完整代码)
  • 计算机毕业设计springboot体育场馆在线预约系统 基于SpringBoot的高校体育馆场地预约平台 SpringBoot+MySQL的校园运动场馆智能预订系统
  • Flutter 三端应用实战:OpenHarmony “呼吸灯”——在焦虑时代守护每一次呼吸的数字禅修
  • 计算机毕业设计springboot二手房产交易平台 SpringBoot驱动的二手房租售一体化平台 基于SpringBoot的存量房交易与租赁撮合系统
  • Flutter 三端应用实战:OpenHarmony “专注时光盒”——在碎片洪流中守护心流的数字容器
  • 2025年市场岗位能力重构与跨领域转型路径分析 - 详解
  • 山间雾里-重庆
  • 飞牛fnOS高危漏洞实战分析与应急处置指南(2026最新版)
  • 别小看这些碎片,芬兰乌拉尔语族的分词技术竟有这么大学问
  • 算法入门打卡Day4___交换链表节点、删除倒数N个节点、链表相交、环形链表
  • 2026青少年数学网校实测|分龄选对不踩坑,学霸私藏清单曝光
  • 人民大学团队破解AI智能体“健忘症“
  • Flutter艺术探索-Flutter跨平台适配:Android/iOS/Web差异化处理
  • stm32毕业论文(毕设)必过选题思路
  • 研究团队发明了一套AI评审系统,让深度研究报告评测变得精准!
  • JAVA数据结构 DAY2-包装类和泛型
  • 毕业那年经济增速,决定你未来十年工资?
  • 阿里巴巴云团队用448K样本做出超越32倍参数模型的推理小天才
  • 深度测评9个降AI率平台,千笔助你高效降AIGC
  • 股市盈利三支柱:深耕、规则、仓位::股市的最大敌人,不是“市场”,而是“自己的认知盲区、对规则的忽视、对风险的漠视”
  • 北大联合阿里达摩院:让AI代码生成告别“只会跑不会快“的困境
  • ACPI!ACPIRootIrpStartDevice函数在ACPI!ACPIInitStartACPI函数后设置_SB的设备状态为Started
  • 2026青少年英语网校靠谱排名|实测4家!提分/启蒙/口语全覆盖
  • 实测30家|给宝妈的小学生数学网校参考,省心不踩坑
  • 2026年4-8岁儿童AI数学课程解析|科学测评+精准选课指南
  • 完整教程:PySide6 + QML - 多线程02 - QThread 生命周期与安全退出
  • 小学启蒙AI数学课怎么选?实测8大热门课,避坑指南+适配攻略
  • ue 购买 fbx 资产踩坑实录