Oracle resource failover due to "ORA-00020: maximum number of processes (150) exceeded"

Solution Verified - Updated -

Issue

  • Oracle resource failover to other nodes, and below logs are seen:
  Dec 07 11:33:59 [7777] xxxxxxxx       crmd:     info:process_graph_event:    Detected action (2.122) xxxxxx-Oracle_monitor_120000.286=unknown error: failed

  Dec 07 11:34:03 [7774] xxxxxxxx       lrmd:     info: log_execute:    executing - rsc:xxxxxx-Oracle action:stop call_id:409
  Dec 07 11:34:03 [7777] xxxxxxxx       crmd:     info: process_lrm_event:  Operation xxxxxx-Oracle_monitor_120000: Cancelled (node=xxxxxxxx, call=286, confirmed=true)
  oracle(xxxxxx-Oracle)[19244]:  2016/12/07_11:34:03 WARNING: 'dbasql getipc' failed: ERROR:
  ORA-00020: maximum number of processes (150) exceeded

  ORA-24324: service handle not initialized
  ORA-01041: internal error. hostdef extension doesn't exist
  ORA-24323: value not allowed
  ORA-24324: service handle not initialized
  ORA-01041: internal error. hostdef extension doesn't exist
  ORA-24323: value not allowed
  ORA-24324: service handle not initialized
  ORA-01041: internal error. hostdef extension doesn't exist
  ORA-24323: value not allowed

Environment

  • Red Hat Enterprise Linux 6
  • Red Hat Enterprise Linux 7
  • Pacemaker

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content