个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2021-06-25 21:44:23
实例宕机，提示大量ora-20错误，这个我会，不就是连接数多吗？应用干的
看看告警日志，
找到一个trc
看看告警日志，
- 2021-06-21t01:14:24.831701 08:00
- note: cleaning up empty system-created directory ' ocrdg/dbcluster/ocrbackup/backup01.ocr.265.1075742055'
- note: cleaning up empty system-created directory ' ocrdg/dbcluster/ocrbackup/backup00.ocr.259.1075756459'
- note: cleaning up empty system-created directory ' ocrdg/dbcluster/ocrbackup/16625263.267.1075770861'
- 2021-06-21t03:22:32.978113 08:00
- ora-00020: maximum number of processes (1024) exceeded
- ora-20 errors will not be written to the alert log for
- the next minute. please look at trace files to see all
- the ora-20 errors.
- process mz00 submission failed with error = 20
- 2021-06-21t03:22:55.574149 08:00
- errors in file /u01/app/grid/diag/asm/ asm/ asm1/trace/ asm1_ora_229943.trc (incident=57777):
- ora-00603: oracle server session terminated by fatal error
- ora-00020: maximum number of processes () exceeded
- incident details in: /u01/app/grid/diag/asm/ asm/ asm1/incident/incdir_57777/ asm1_ora_229943_i57777.trc
- 2021-06-21t03:22:56.354968 08:00
- opiodr aborting process unknown ospid (229943) as a result of ora-603
- 2021-06-21t03:22:56.396737 08:00
- errors in file /u01/app/grid/diag/asm/ asm/ asm1/trace/ asm1_ora_229941.trc (incident=57769):
- ora-00603: oracle server session terminated by fatal error
- ora-00020: maximum number of processes () exceeded
- incident details in: /u01/app/grid/diag/asm/ asm/ asm1/incident/incdir_57769/ asm1_ora_229941_i57769.trc
- 2021-06-21t03:22:56.930931 08:00
- errors in file /u01/app/grid/diag/asm/ asm/ asm1/trace/ asm1_ora_229941.trc:
- ora-17503: ksfdopn:2 failed to open file ocrdg/orapwasm
- ora-00603: oracle server session terminated by fatal error
- ora-00020: maximum number of processes () exceeded
- 2021-06-21t03:22:57.039063 08:00
- trace file /u01/app/grid/diag/asm/ asm/ asm1/trace/ asm1_ora_229943.trc
- oracle database 19c enterprise edition release 19.0.0.0.0 - production
- version 19.9.0.0.0
- build label: rdbms_19.9.0.0.0dbru_linux.x64_200930
- oracle_home: /u01/app/19.3.0/grid
- system name: linux
- node name: host
- release: 3.10.0-957.el7.x86_64
- version: #1 smp thu oct 4 20:48:51 utc 2018
- machine: x86_64
- instance name: asm1
-
redo thread mounted by this instance: 0
- oracle process number: 1022
- unix process pid: 229943, image: oracle@host (tns v1-v3)
- *** 2021-06-21t03:22:55.574585 08:00
- *** session id:(1037.14999) 2021-06-21t03:22:55.574603 08:00
- *** client id:() 2021-06-21t03:22:55.574607 08:00
- *** service name:() 2021-06-21t03:22:55.574610 08:00
- *** module name:() 2021-06-21t03:22:55.574613 08:00
- *** action name:() 2021-06-21t03:22:55.574615 08:00
- *** client driver:() 2021-06-21t03:22:55.574618 08:00
- 2021-06-21t03:22:55.574435 08:00
- incident 57777 created, dump file: /u01/app/grid/diag/asm/ asm/ asm1/incident/incdir_57777/ asm1_ora_229943_i57777.trc
- ora-00603: oracle server session terminated by fatal error
- ora-00020: maximum number of processes () exceeded
-
-
kgefec: fatal error 20
的确是最大进程数，这里设置的是1024。
但是这是asm实例遇到的最大进程数，谁会连接到 asm1上面呢？
此时实例2运行正常， asm2实例也有600多个asm_pp开头的进程，什么是pp进程，请参考
为什么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自动消失。
再观察。
但是这是asm实例遇到的最大进程数，谁会连接到 asm1上面呢？
此时实例2运行正常， asm2实例也有600多个asm_pp开头的进程，什么是pp进程，请参考
-
不讲武德的并行进程命名
- http://blog.chinaunix.net/uid-20687159-id-5844801.html
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自动消失。
再观察。
给主人留下些什么吧！~~