ORA-00600: [qerrmObnd1], [932], [ORA-00932: inconsistent datatypes
今天幫客戶巡檢資料庫,資料庫報以下錯誤:
ORA-00600: internal error code, arguments: [qerrmObnd1], [932], [ORA-00932: inconsistent datatypes: expected got
根據trace查出來的sql如下:
select to_char(bq.rk_rq,:"SYS_B_00") ZS_XM,:"SYS_B_01" ZS_PM,bq.bqrk_je BQRK_JE,to_char(bq.rk_rq,:"SYS_B_02") RK_RQ--,sq.bqrk_je SNTQ_JE,case when sq.bqrk_je>0 then (bq.bqrk_je-sq.bqrk_je)/sq.bqrk_je when sq.bqrk_je =0 then 1 end ZJL,bq.bqrk_je-nvl(sq.bqrk_je,0) ZJ_JE
,decode((select nsrnbm from t_dcfx_dcfxbg where nsrnbm = :"SYS_B_03" and bgssq_z = to_char(bq.rk_rq,:"SYS_B_04") ),:"SYS_B_05",:"SYS_B_06",:"SYS_B_07") fxbg
from
(select :"SYS_B_08" ZS_XM,:"SYS_B_09" ZS_PM,(sum(nvl(a.bqrkse,:"SYS_B_10")) -sum(nvl(a.bqtkse,:"SYS_B_11"))) BQRK_JE,trunc(a.sj,:"SYS_B_12") RK_RQ
from a
where
trunc(a.sj,:"SYS_B_13") = trunc(to_date(:"SYS_B_14",:"SYS_B_15"), :"SYS_B_16")
and a.nsrnbm =:"SYS_B_17" group by trunc(a.sj,:"SYS_B_18"))bq,
(select :"SYS_B_19" ZS_XM,:"SYS_B_20" ZS_PM,(sum(nvl(a.bqrkse,:"SYS_B_21")) -sum(nvl(a.bqtkse,:"SYS_B_22"))) BQRK_JE,trunc(a.sj,:"SYS_B_23") RK_RQ
from a
where
trunc(a.sj,:"SYS_B_24") = trunc(add_months(to_date(:"SYS_B_25",:"SYS_B_26"),-:"SYS_B_27"), :"SYS_B_28")
and a.nsrnbm =:"SYS_B_29" group by trunc(a.sj,:"SYS_B_30"))sq
where
bq.RK_RQ = add_months(SQ.RK_RQ,:"SYS_B_31")
根據查metalink,有可能是bug
檢查下資料庫引數為 cursor_sharing=SIMILAR 觸發這個bug
以下是metalink解釋
Bug 4254094 - OERI[qerrmObnd1][932] possible for queries over DB links | ||||
: | 4254094.8 | 型別: | PATCH | |
上次修訂日期: | 24-SEP-2008 | 狀態: | PUBLISHED |
Bug 4254094 OERI[qerrmObnd1][932] possible for queries over DB links
This note gives a brief overview of bug 4254094.
The content was last updated on: 03-APR-2008
Click for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions < 11 Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)
It is believed to be a in default behaviour thus:
Regression introduced in 9.2.0.6
Fixed:
This issue is fixed in
Symptoms: |
Related To: |
|
|
Description
This problem appears to have been introduced in 9.2.0.6 . When CURSOR_SHARING = FORCE or SIMILAR then SQL over database links which involves replaced date format mask information can result in ORA-600 [qerrmObnd1] and a dump in qerrmOdcl. Workaround: A workaround in 9.2.0.6 is to set the hidden parameter "_adjust_literal_replacement" = TRUE This enables the fix for .
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice. |
References
(This link will only work for PUBLISHED bugs)
Information on the sections in this article
解決方法:
改引數 cursor_sharing=exact
或新增隱含引數 "_adjust_literal_replacement" = TRUE
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-545692/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- EXP-00056: ORACLE error 932 encountered(ORA-00932: inconsistent datatypes)OracleError
- [ORACLE-ORA]EXP-56 ORA-00932 (Inconsistent Datatypes) EXP ID 339938.1Oracle
- inconsistent datatypes: expected - got CLOB錯誤一例Go
- eclipes MS932
- 文件筆記--Datatypes筆記
- Datatypes (1) : ROWID and UROWID
- 破解鬥地主1。0 (932字)
- Using Byte and Char with Character Datatypes
- Codeforces Round 932 (Div. 2)
- TabError: inconsistent use of tabs and spaces in indentationError
- spring aop The hierarchy of the type is inconsistentSpring
- cfRound932div2-CD題解
- OCR integrity results are inconsistent amongst the nodes.
- Codeforces Round 932 (Div. 2) ABCD
- 前端面試每日 3+1 —— 第932天前端面試
- [Elasticsearch Reference 2x] Mapping - Field datatypesElasticsearchAPP
- Codeforces Round 932 (Div. 2) DE 題解
- 並查集解mex_cf932_B. Informatics in MAC並查集ORMMac
- Oracle 10G中 EXP物件時報ORA-00932Oracle 10g物件
- Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistentHive
- 交易資訊被篡改 錯誤碼:CONTEXT_INCONSISTENTContext
- 翻譯:《實用的Python程式設計》02_01_DatatypesPython程式設計
- ERROR: The LVM time stamp for shared volume group: datavg is inconsistentErrorLVM
- ORA-29707: inconsistent value 2 for initialization parameter cluster_database_Database
- [20210723]Database link and user defined datatypes.txtDatabase
- ubuntu下hadoop0.20.2報錯/dfs/name is in an inconsistent stateUbuntuHadoop
- ORA-00600: [qksdsInitSample:2]
- ORA-00600錯誤分析
- ORA-00600: internal error codeError
- Warning: ORA-16792: configurable property value is inconsistent with member sett
- GO語言安裝air框架時遇到go: inconsistent vendoring問題GoAI框架
- Oracle 12c RMAN Performing Cross-Platform Transport of a PDB Using InconsistentOracleROSPlatform
- ORA-00600:: [ttcgcshnd-1], [0], [], [], [], [], [], []GC
- oracle錯誤之ORA-00600Oracle
- ORA-00600 [2103]的分析
- ORA-00600 [4194], [55]處理
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error