My Oracle Support Banner

datapatch Fails With KUP-04095 Error Qopiprep.bat Couldn't Set Locale Correctly (Doc ID 2392742.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
All Platforms

Symptoms

SYMPTOM 1:

Datapatch fails with below error in the qopatch_log.log

KUP-04095: preprocessor command <ORACLE_HOME>/QOpatch/qopiprep.bat encountered error "couldn't set locale correctly
couldn't set locale correctly
couldn't set locale correctly
couldn't set locale correctly
couldn't set locale correctly

or

KUP-04095: preprocessor command <ORACLE_HOME>/QOpatch/qopiprep.bat encountered error "
Warning! One or more of your selected locales are not available.
Please invoke the commands "locale" and "locale -a" to verify your
selections and the availabl"

 

SYMPTOM 2:

Datapatch fails with below error.

oracle@test1> ./datapatch -verbose
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US"
are supported and installed on your system.
perl: warning: Falling back to a fallback locale ("en_US").
SQL Patching tool version 12.2.0.1.0 Production on Fri May 31 11:34:34 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.

Log file for this invocation: <ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_10670_2019_05_31_11_34_34/sqlpatch_invocation.log

Connecting to database...OK
Bootstrapping registry and package to current versions...done

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
and/or check the invocation log
/usr/oracle/cfgtoollogs/sqlpatch/sqlpatch_10670_2019_05_31_11_34_34/sqlpatch_invocation.log
for the complete error.
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
<ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_10670_2019_05_31_11_34_34/sqlpatch_invocation.log
for information on how to resolve the above errors.

 

OR

 

SQL> select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command
$ORACLE_HOME/QOpatch/qopiprep.bat encountered error
"en_US.utf8: unknown locale"

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.