Troubleshooting Oracle 19c RAC DB crash after ora-600 [kjblpgorm:!antilock] and start fail with Ora-600 [kfmdPriRegRclient04]

最近有个客户的oracle 19c 3nodes RAC 有一个节点意外crash ORA-600 kjblpgorm:!antilock, 启动时报ORA-600[kfmdPriRegRclient04]，并启动过程中重导致之前的幸存节点hang并且重启，Oracle 的基础版本bug 比较多，找我分析并临时解决了该问题，简单记录该问题。

, ,

阅读全文

How to disable DRM? Oracle 10G, 11G, 12C-19C

  • 2020/06/16
  • Cloud, ORACLE 9i-23ai
  • 4,040 views
  • How to disable DRM? Oracle 10G, 11G, 12C-19C已关闭评论

DRM is driven by the following
1.) _gc_affinity_time = Time in minutes at which statistics will be evaluated (default = 10 mins)
2.) _gc_affinity_limit = # of times a node accesses a file/object (default = 50)
3.) _gc_affinity_minimum = minimum # of times per minute a file/object is accessed before affinity kicks in
(default = 600 per minute per cpu )
4.) _lm_drm_disable = LEVEL disable drm in different level( default=0 )

阅读全文