datapatch failed with catconInit failed, exiting

start_processes: failed to open (Resource temporarily unavailable) pipe to SQL*Plus
catconInit failed, exiting 

Facing the issue with datapatch -verbose, once we executed the datapatch after successful completion of  Bundle patch on Oracle restart (standalone ASM using Grid 12.2.0.1) home. In sqlpatch_invocation.log file we found the message as like below 

start_processes: failed to open (Resource temporarily unavailable) pipe to SQL*Plus
catconInit failed, exiting

to fix this issue we did below workaround, 

Verified the cpu_count parameter,

show parameter cpu_count, if incase cpu_count is 48, alter that count to 4 .

alter system set cpu_count=4;

run the datapatch now, it will run successfully. Once completeion of datapatch set back the cpu_count to 48.

alter system set cpu_count=48;

for complete details check the DOC ID 2540548.1


0 $type={blogger}:

Post a Comment