12.1以上
问题概述
2节点的alert中频繁出现ORA-12850 Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_376360.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Wed Jun 07 22:36:51 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_31022.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Wed Jun 07 22:42:54 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_52693.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Wed Jun 07 22:52:58 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_88603.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Wed Jun 07 23:08:04 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_145104.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Wed Jun 07 23:13:06 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_168451.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Wed Jun 07 23:27:12 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_217400.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Wed Jun 07 23:33:14 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_241972.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
...
Thu Jun 08 10:40:48 2023
Errors in file /u01/app/oracle/diag/rdbms/rac/rac2/trace/rac2_m001_328972.trc:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated问题原因
查看rac2_m001_376360.trc结合DBA_HIST_ACTIVE_SESS_HISTORY,可以看到会话(296.14377) 在执行dfffkcnqfystw时ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Dump of memory from 0x000000011E503DC0 to 0x000000011E519B04
11E503DC0 48544957 4E4F4D20 524F5449 5441445F [WITH MONITOR_DAT]
11E503DD0 53412041 45532820 5443454C 534E4920 [A AS (SELECT INS]
11E503DE0 44495F54 454B202C 4E202C59 28324C56 [T_ID, KEY, NVL2(]
11E503DF0 515F5850 44495343 554E202C 202C4C4C [PX_QCSID, NULL, ]
11E503E00 54415453 20295355 54415453 202C5355 [STATUS) STATUS, ]
11E503E10 53524946 45525F54 53455246 49545F48 [FIRST_REFRESH_TI]
11E503E20 202C454D 5453414C 4645525F 48534552 [ME, LAST_REFRESH]
11E503E30 4D49545F 52202C45 45524645 435F4853 [_TIME, REFRESH_C]
11E503E40 544E554F 5250202C 5345434F 414E5F53 [OUNT, PROCESS_NA]
11E503E50 202C454D 2C444953 4C515320 2C44495F [ME, SID, SQL_ID,]
11E503E60 4C515320 4558455F 54535F43 2C545241 [ SQL_EXEC_START,]
11E503E70 4C515320 4558455F 44495F43 4244202C [ SQL_EXEC_ID, DB]
...
查询mos,匹配High CPU Usage and/or Frequent Occurrences of ORA-12850 or ORA-12751 For Monitor Queries by MMON From 12.1 ( Doc ID 2102131.1 )，
解决方案
关闭自动捕获报告特性
alter system set "_report_capture_cycle_time"=0 scope=both;参考文档
High CPU Usage and/or Frequent Occurrences of ORA-12850 or ORA-12751 For Monitor Queries by MMON From 12.1 ( Doc ID 2102131.1 )
标签：rac2,Could,allocate,specified,12850,ORA From： https://blog.51cto.com/u_13482808/7052938