Oracle resource failover due to "ORA-00020: maximum number of processes (150) exceeded"
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.