[OCI] VMDB: "locale: Cannot set LC_CTYPE to default locale: No such file or directory" message shown at DB alert log
(Doc ID 2960010.1)
Last updated on OCTOBER 06, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
When DB instance started by SRVCTL, locale: "Cannot set LC_CTYPE to default locale: No such file or directory" message shown at DB alert log. the the patch information can not dumped as usual.
CJQ0 started with pid=65, OS id=63270
Completed: ALTER DATABASE OPEN /* db agent *//* {1:28606:3886} */
2023-06-17T14:41:25.888395+09:00
PDB0(3):Started service <DB Name>.paas.oracle.com/<DB Name>.paas.oracle.com/<DB Name>.paas.oracle.com
2023-06-17T14:41:27.424988+09:00
Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 2327
ORA-06512: at "SYS.DBMS_QOPATCH", line 854
ORA-06512: at "SYS.DBMS_QOPATCH", line 937
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_QOPATCH", line 932
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command $ORACLE_HOME/QOpatch/qopiprep.bat encountered error "locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Can"
ORA-06512: at "SYS.DBMS_QOPATCH", line 919
ORA-06512: at "SYS.DBMS_QOPATCH", line 2286
ORA-06512: at "SYS.DBMS_QOPATCH", line 817
ORA-06512: at "SYS.DBMS_QOPATCH", line 2309
===========================================================
Dumping current patch information
===========================================================
Unable to obtain current patch information due to error: 20001
===========================================================
Meanwhile the following two phenomenons observed:
1. the symptom was observed only that the instance was started by SRVCTL command, no same symptom found when the instance was started via SQL*Plus.
2. select * from OPATCH_XML_INV and select dbms_sqlpatch.verify_queryable_inventory from dual ran fine as following.
XML_INVENTORY
--------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <InventoryInstance> <ora
SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;
VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
OK
3. ISO-8859-15 Locale was installed at VMDB
an_ES.iso885915
ast_ES.iso885915
br_FR.iso885915@euro
ca_AD.iso885915
ca_ES.iso885915@euro
ca_FR.iso885915
ca_IT.iso885915
da_DK.iso885915
de_AT.iso885915@euro
de_BE.iso885915@euro
de_DE.iso885915@euro
de_LU.iso885915@euro
en_GB.iso885915
en_IE.iso885915@euro
en_US.iso885915
es_ES.iso885915@euro
et_EE.iso885915
eu_ES.iso885915@euro
fi_FI.iso885915@euro
fr_BE.iso885915@euro
fr_FR.iso885915@euro
fr_LU.iso885915@euro
ga_IE.iso885915@euro
gd_GB.iso885915
gl_ES.iso885915@euro
it_IT.iso885915@euro
mg_MG.iso885915
nl_BE.iso885915@euro
nl_NL.iso885915@euro
pt_PT.iso885915@euro
sv_FI.iso885915@euro
sv_SE.iso885915
wa_BE.iso885915@euro
Changes
the VMDB environment just was provisioned.
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 |
References |