数据库基本信息:
数据库版本:Oracle 12.1.0.2.210119
集群情况:RAC + RAC DataGuard
问题现象:
Alert.log 监控 突然频繁报ORA-12801,ORA-22921
Thu Jun 03 11:43:59 2021
Errors in file /u01/oracle/diag/rdbms/rac/rac2/trace/rac_m000_164106.trc:
ORA-12801: error signaled in parallel query server PPA7, instance node02.localdomain:rac2 (2)
ORA-22921: 输入缓冲区的长度小于所要求的数量
Trc内容:
*** SESSION ID:(6.34898) 2021-06-03 11:43:59.287
*** CLIENT ID:() 2021-06-03 11:43:59.287
*** SERVICE NAME:(SYS$BACKGROUND) 2021-06-03 11:43:59.287
*** MODULE NAME:(MMON_SLAVE) 2021-06-03 11:43:59.287
*** CLIENT DRIVER:() 2021-06-03 11:43:59.287
*** ACTION NAME:(Automatic Report Flush) 2021-06-03 11:43:59.287 <<<<<<<<<<<(Automatic Report Flush)
ORA-12801: error signaled in parallel query server PPA7, instance node02.localdomain:rac2 (