出现这种问题,可能数据库已经不可以访问,需要找到之前的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