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 laterOracle 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
couldn't set locale correctly
couldn't set locale correctly
couldn't set locale correctly
couldn't set locale correctly
or
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 |