Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2667280
  • 博文数量: 570
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 6259
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(570)

文章存档

2022年(64)

2021年(238)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

分类: Oracle

2021-06-25 21:44:23

实例宕机,提示大量ora-20错误,这个我会,不就是连接数多吗?应用干的

看看告警日志,

  1. 2021-06-21T01:14:24.831701+08:00
  2. NOTE: cleaning up empty system-created directory '+OCRDG/dbcluster/OCRBACKUP/backup01.ocr.265.1075742055'
  3. NOTE: cleaning up empty system-created directory '+OCRDG/dbcluster/OCRBACKUP/backup00.ocr.259.1075756459'
  4. NOTE: cleaning up empty system-created directory '+OCRDG/dbcluster/OCRBACKUP/16625263.267.1075770861'
  5. 2021-06-21T03:22:32.978113+08:00
  6. ORA-00020: maximum number of processes (1024) exceeded
  7. ORA-20 errors will not be written to the alert log for
  8. the next minute. Please look at trace files to see all
  9. the ORA-20 errors.
  10. Process MZ00 submission failed with error = 20
  11. 2021-06-21T03:22:55.574149+08:00
  12. Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_229943.trc (incident=57777):
  13. ORA-00603: ORACLE server session terminated by fatal error
  14. ORA-00020: maximum number of processes () exceeded
  15. Incident details in: /u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_57777/+ASM1_ora_229943_i57777.trc
  16. 2021-06-21T03:22:56.354968+08:00
  17. opiodr aborting process unknown ospid (229943) as a result of ORA-603
  18. 2021-06-21T03:22:56.396737+08:00
  19. Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_229941.trc (incident=57769):
  20. ORA-00603: ORACLE server session terminated by fatal error
  21. ORA-00020: maximum number of processes () exceeded
  22. Incident details in: /u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_57769/+ASM1_ora_229941_i57769.trc
  23. 2021-06-21T03:22:56.930931+08:00
  24. Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_229941.trc:
  25. ORA-17503: ksfdopn:2 Failed to open file +OCRDG/orapwasm
  26. ORA-00603: ORACLE server session terminated by fatal error
  27. ORA-00020: maximum number of processes () exceeded
  28. 2021-06-21T03:22:57.039063+08:00
找到一个trc

  1. Trace file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_229943.trc
  2. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  3. Version 19.9.0.0.0
  4. Build label: RDBMS_19.9.0.0.0DBRU_LINUX.X64_200930
  5. ORACLE_HOME: /u01/app/19.3.0/grid
  6. System name: Linux
  7. Node name: host
  8. Release: 3.10.0-957.el7.x86_64
  9. Version: #1 SMP Thu Oct 4 20:48:51 UTC 2018
  10. Machine: x86_64
  11. Instance name: +ASM1
  12. Redo thread mounted by this instance: 0
  13. Oracle process number: 1022
  14. Unix process pid: 229943, image: oracle@host (TNS V1-V3)
  15. *** 2021-06-21T03:22:55.574585+08:00
  16. *** SESSION ID:(1037.14999) 2021-06-21T03:22:55.574603+08:00
  17. *** CLIENT ID:() 2021-06-21T03:22:55.574607+08:00
  18. *** SERVICE NAME:() 2021-06-21T03:22:55.574610+08:00
  19. *** MODULE NAME:() 2021-06-21T03:22:55.574613+08:00
  20. *** ACTION NAME:() 2021-06-21T03:22:55.574615+08:00
  21. *** CLIENT DRIVER:() 2021-06-21T03:22:55.574618+08:00
  22. 2021-06-21T03:22:55.574435+08:00
  23. Incident 57777 created, dump file: /u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_57777/+ASM1_ora_229943_i57777.trc
  24. ORA-00603: ORACLE server session terminated by fatal error
  25. ORA-00020: maximum number of processes () exceeded

  26. kgefec: fatal error 20

的确是最大进程数,这里设置的是1024。
但是这是asm实例遇到的最大进程数,谁会连接到+ASM1上面呢?

此时实例2运行正常,+ASM2实例也有600多个asm_pp开头的进程,什么是pp进程,请参考

  1. 不讲武德的并行进程命名
  2. http://blog.chinaunix.net/uid-20687159-id-5844801.html
为什么asm有大量并行进程?
bug?

三板斧定位法:
select osuser,username,count(0) from v$session group by osuser,username;
select sid,sql_id,event,status,state,event,last_call_et from v$session;
select pname,program,machine from v$process where addr=(select paddr from v$session where sid=&sid);

发现一个用户执行过gv$视图查询,但是会话一直没断开。
后来应用关闭后,这些asm_pp自动消失。
再观察。

阅读(733) | 评论(0) | 转发(0) |
0

上一篇:这里的弯路18弯

下一篇:pctp tidb 题库

给主人留下些什么吧!~~