Writing the record to OS spillover file 数据库访问失败，日志写入OS file

出现这种问题，可能数据库已经不可以访问，需要找到之前的alert 信息 

由于ORA-4021，统一审计记录写入审计跟踪表失败。 

Oracle12cR2 两节点RAC集群，其中节点1报错Unified Audit record write to audit trail table failed due to ORA-4021. Writing the record to OS spillover file.

 

ORA-04021: 等待锁定对象 SYS.USER$ 时发生超时

 

可以MOS搜一下关于ORA 4021的BUG,虽然文档中描述是ADG，但我觉的非ADG环境也可能触发该BUG
Bug 28423598 - ORA-4021: ORA-4024: ROW CACHE ENQUEUE AGAINST DC_OBJECTS:OBJ$ on Active Data Guard (文档 ID 28423598.8)

Active Data Guard instance may hang, 
 FG process can report the following errors :
 
ORA-00604: error occurred at recursive SQL level 3
ORA-04024: self-deadlock detected while trying to mutex pin cursor ?
ORA-04021: timeout occurred while waiting to lock object 
 
Trace file of ORA-4021 shows 
 
kqrGetClusterLock: timeout po: 0xb2775a4b8 lock: 0xb27734dc0
----------------------------------------
  type=MULTI-INSTANCE 
  row cache parent object: cid=8(dc_objects) 
  name=OBJ$
  wat= mode=S req=S
  status=-/-/-/-/-/-/-/-/LOADING