Skip to main content
Solved

Oracle patch installation failing only in Prod Environment

Sachinthani Wanniarachchi
Do Gooder (Partner)
Forum|alt.badge.img+3

We are facing issues during the Oracle patch installation in Production Database. But we have successfully installed the Oracle patches to TEST and TRNG environments.

Error in file : sqlpatch_invocation.log

1SQL Patching tool version 12.2.0.1.0 Production on Thu Apr 15 20:39:23 2021
2Copyright (c) 2012, 2020, Oracle.  All rights reserved.
3
4Build label: RDBMS_12.2.0.1.0WINDBBP_WINDOWS.X64_191230.3
5Log file for this invocation: D:\app\cfgtoollogs\sqlpatch\sqlpatch_10136_2021_04_15_20_39_23\sqlpatch_invocation.log
6
7SQL Patching arguments:
8  verbose: 1
9  force: 0
10  skip_sql_state_check: 0
11  prereq: 0
12  upgrade_mode_only: 
13  oh: 
14  bundle_series: 
15  ignorable_errors: 
16  bootstrap: 
17  skip_bootstrap: 
18  skip_upgrade_check: 
19  userid: 
20  pdbs: 
21  noqi: 
22  app: 
23  binary_config: 
24  recomp_threshold: 300
25
26Connecting to database...OK
27catcon: ALL catcon-related output will be written to [D:\app\cfgtoollogs\sqlpatch\sqlpatch_10136_2021_04_15_20_39_23/sqlpatch_catcon__catcon_10136.lst]
28catcon: See [D:\app\cfgtoollogs\sqlpatch\sqlpatch_10136_2021_04_15_20_39_23/sqlpatch_catcon_*.log] files for output generated by scripts
29catcon: See [D:\app\cfgtoollogs\sqlpatch\sqlpatch_10136_2021_04_15_20_39_23/sqlpatch_catcon__*.lst] files for spool files, if any
30start_processes: failed to open (Resource temporarily unavailable) pipe to SQL*Plus
31
32catconInit failed, exiting
33
34Please refer to MOS Note 1609718.1 and/or the invocation log
35D:\app\cfgtoollogs\sqlpatch\sqlpatch_10136_2021_04_15_20_39_23\sqlpatch_invocation.log
36for information on how to resolve the above errors.
37
38SQL Patching tool complete on Thu Apr 15 20:39:26 2021

Any idea on what can be the root cause and a solution for this issue?

Best answer by Chathuranga Samarakoon

@Sachinthani Wanniarachchi  Below solution will solve your issue.

 

APPLIES TO;

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

SYMPTOMS

On : 12.1.0.2 version, Patching

datapatch -verbose fails with catconInit failed, exiting


start_processes: failed to open (Bad file descriptor) pipe to SQL*Plus

catconInit failed, exiting

 

CAUSE

The Catcon.pm will default to cpu_count*2. so this can be very high and it can exhaust process counts on the database.
 
See the following error:

start_processes: failed to open (Bad file descriptor) pipe to SQL*Plus

catconInit failed, exiting

 

SOLUTION

Validate the cpu_count via below command and put the value lower if it is high.

SQL> show parameter cpu

Temporarily set CPU_COUNT to a lower number.

ALTER SYSTEM SET CPU_COUNT = 4;

Perform datapatch and validate the status.

Once done you can set it back to the original number

ALTER SYSTEM SET CPU_COUNT = 48;


Refer this article from Oracle: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=33678735976502&id=2540548.1&_afrWindowMode=0&_adf.ctrl-state=c04wiz2da_4

View original
wanodya
Chathuranga Samarakoon
Yasas Kasthuriarachchi
Dinuk Amarasinghe
4 people like this
  • Chathuranga Samarakoon
    Chathuranga Samarakoon
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi
  • Dinuk Amarasinghe
    Dinuk Amarasinghe
  • Pulasithi Peiris
    Pulasithi Peiris
Did this topic help you find an answer to your question?
This topic has been closed for replies.

2 replies

Chathuranga Samarakoon
Hero (Partner)
Forum|alt.badge.img+12

@Sachinthani Wanniarachchi  Below solution will solve your issue.

 

APPLIES TO;

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

SYMPTOMS

On : 12.1.0.2 version, Patching

datapatch -verbose fails with catconInit failed, exiting


start_processes: failed to open (Bad file descriptor) pipe to SQL*Plus

catconInit failed, exiting

 

CAUSE

The Catcon.pm will default to cpu_count*2. so this can be very high and it can exhaust process counts on the database.
 
See the following error:

start_processes: failed to open (Bad file descriptor) pipe to SQL*Plus

catconInit failed, exiting

 

SOLUTION

Validate the cpu_count via below command and put the value lower if it is high.

SQL> show parameter cpu

Temporarily set CPU_COUNT to a lower number.

ALTER SYSTEM SET CPU_COUNT = 4;

Perform datapatch and validate the status.

Once done you can set it back to the original number

ALTER SYSTEM SET CPU_COUNT = 48;


Refer this article from Oracle: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=33678735976502&id=2540548.1&_afrWindowMode=0&_adf.ctrl-state=c04wiz2da_4

Chathuranga Samarakoon
Yasas Kasthuriarachchi
M
Sachinthani Wanniarachchi
3 people like this
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi
  • M
    Malith Alawaththa
  • Sachinthani Wanniarachchi
    Sachinthani Wanniarachchi
Sachinthani Wanniarachchi
Do Gooder (Partner)
Forum|alt.badge.img+3

Thank You @Chathuranga_S. With this input we were able to fixed the issue and Prod is now up and running with the Oracle patch.

wanodya
Chathuranga Samarakoon
Yasas Kasthuriarachchi
2 people like this
  • Chathuranga Samarakoon
    Chathuranga Samarakoon
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi
Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings