I was planning to conduct an in-depth study on Oracle Data dictionary this evening, but when I was about to finish the research, I received a message from a friend in Beijing saying that their database generation had a problem, let me take a look at how to help solve this problem. I am very happy to help others, and I have also improved myself. I would like to record it at this moment, after writing this log, I will continue my research.
The trace log information is as follows:
Dbfs/oradata/admin/htdb/udump/htdb_ora_704518.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME =/oracle/product/10.2.0.5
System name: AIX
Node name: ECMora01
Release: 3
Version: 5
Machine: 00C05BB64C00
Instance name: htdb
Redo thread mounted by this instance: 1
Oracle process number: 206
Unix process pid: 704518, image: oracle @ ECMora01
* ** Service name :( SYS $ USERS) 2013-06-17 08:43:14. 002
* ** Session id: (1473.41629) 08:43:14. 002
* ** 2013-06-17 08:43:14. 001
Ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktrgcm_3], [], [], [], [], [], [], [], []
Current SQL statement for this session:
Select count (distinct id) from (select ve. workflowid | ''as id from v_executableworktask ve left join T_DATA_ITEM appt on appt. value = ve. BUSSINESSTYPE and appt. deleted = 0 and appt. cataid = 1101 where 1 = 1 and ve. globalID in ('P {2266580} ', 'O {411001700}', 'O {4110} ', 'G {201111992}') and ve. BUSINESSID in (select c. id FROM T_CONTRACT_CONTENT c where instr (C. GLOBALSN,: 1)> 0 union select e. id from T_CONTRACT_CONTENT C, CUECM. t_CONTRACT_DONE e where e. AFFAIRID = C. affairid and instr (C. GLOBALSN,: 2)> 0 union select l. relationid from T_CONTRACT_CONTENT C, T_APPROVE_LIST l where l. DENYSIGN = 0 and l. TARGETID = C. id and instr (C. GLOBALSN,: 3)> 0 union select f. id FROM t_contract_file f, T_CONTRACT_CONTENT c where f. contractId = C. id and instr (C. GLOBALSN,: 4)> 0 union select d. id FROM t_contract_dissension d, T_CONTRACT_CONTENT c where c. id = d. contractid and instr (C. GLOBALSN,: 5)> 0) union select t. pendingcode as id from (select tab1.pendingcode, tab1.type as businessTypeId, tab2.name businessTypeName, tab1.senddate as starttime, tab1.seandersen name, tab1.title from orders tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where tab1.flag = 0 and tab1.recieverid =: 6 and TAB1.BUSSINESSID in (select c. id FROM T_CONTRACT_CONTENT c where instr (C. GLOBALSN,: 7)> 0 union select e. id from T_CONTRACT_CONTENT C, CUECM. t_CONTRACT_DONE e where e. AFFAIRID = C. affairid and instr (C. GLOBALSN,: 8)> 0 union select l. relationid from T_CONTRACT_CONTENT C, T_APPROVE_LIST l where l. DENYSIGN = 0 and l. TARGETID = C. id and instr (C. GLOBALSN,: 9)> 0 union select f. id FROM t_contract_file f, T_CONTRACT_CONTENT c where f. contractId = C. id and instr (C. GLOBALSN,: 10)> 0 union select d. id FROM t_contract_dissension d, T_CONTRACT_CONTENT c where c. id = d. contractid and instr (C. GLOBALSN,: 11)> 0) t where 1 = 1)
----- Call Stack Trace -----
Calling call entry argument values in hex
Location type point (? Means dubious value)
----------------------------------------------------------------------------
Ksedst + 001c bl ksedst1 0FFFF5A20?
28844220058552A4?
Ksedmp + 0290 bl ksedst 1_c2b3d8?
Ksfdmp + 02d8 bl 03F4D8AC
Kgerinv + 00dc bl _ ptrgl
Kgeasnmierr + 004c bl kgerinv FFFFFFFFFFF6330? 1100096D8?
356A9A350C2D0000?
356A9B920C2D3E80?
356A9B920C2D3E80?
Ktrgcm + 1c44 bl kgeasnmierr 11019C288? 1103F0040?
2017f34564? 000000000?
000000C2D?
356A9A350C2D96D8?
000000000? 1100096D8?
Ktrget + 05c0 bl ktrgcm 110481450?
Kdirfr + 09fc bl ktrget 1058540E0? 2017001c2?
09E370001?
QerixFetchFastFullS bl kdirfr FFFFFFFFFFF7E50?
Can + 0958
QergiFetch + 02a8 bl 03F4D2BC
Rwsfcd + 0054 bl _ ptrgl
QerhjFetch + 00d0 bl 01FC340C
Rwsfcd + 0054 bl _ ptrgl
QeruaFetch + 013c bl 03F4D2BC
Qersofetch+ 0110 bl 01FC340C
Qervwfetch+ 0088 bl 03F4D2BC
Rwsfcd + 0054 bl _ ptrgl
Qerhjfetch+ 0674 bl 01FC340C
Rwsfcd + 0054 bl _ ptrgl
QerhjFetch + 00d0 bl 01FC340C
Rwsfcd + 0054 bl _ ptrgl
QeruaFetch + 013c bl 03F4D2BC
Qersofetch+ 0110 bl 01FC340C
Qervwfetch+ 0088 bl 03F4D2BC
Qergsfetch+ 0324 bl 03F4D2BC
Kpofrws + 019c bl _ ptrgl
Opifch2 + 13a4 bl 01FC633C
Opifch + 003c bl opifch2 700000cb1_ac6c? 000000000?
Fffffffff9e40?
Opiodr + 0b2c bl _ ptrgl
Ttcpip + 1020 bl _ ptrgl
Opitsk + 117c bl 01FC5F7C
Opiino + 09d0 bl opitsk 0FFFFD8F0? 000000000?
Opiodr + 0b2c bl _ ptrgl
Opidrv + 04a4 bl opiodr 3C102B1A18? 404C7E2A8?
Ffffffffff8b0? 0102B1A10?
Sou2o + 0090 bl opidrv 3C02A0E6BC? 440663000?
Ffffffffff8b0?
Opimai_real + 01bc bl 01FC1F54
Main + 0098 bl opimai_real 000000000? 000000000?
_ Start + 0098 bl main 000000000? 000000000?
The solution is as follows:
1)
Bug 14076510 ORA-600 [ktrgcm_3] in 10.2.0.5.3-10.2.0.5.7 This note gives a brief overview of bug 14076510.
The content was last updated on: 08-MAR-2013
Click here for details of each of the sections below.
Affects:
| Product (Component) |
Oracle Server (Rdbms) |
| Range of versions believed to be affected |
Versions >= 10.2.0.5 but BELOW 11.1 |
| Versions confirmed as being affected |
- 10.2.0.5.7 Database Patch Set Update
- 10.2.0.5.6 Database Patch Set Update
- 10.2.0.5.5 Database Patch Set Update
- 10.2.0.5.4 Database Patch Set Update
- 10.2.0.5.3 Database Patch Set Update
- 10.2.0.5
- 10.2.0.5 Patch 18 on Windows Platforms
- 10.2.0.5 Patch 17 on Windows Platforms
- 10.2.0.5 Patch 8 on Windows Platforms
|
| Platforms affected |
Generic (all / most platforms affected) |
Fixed:
| This issue is fixed in |
- 10.2.0.5.8 Database Patch Set Update
- 10.2.0.5 Patch 19 on Windows Platforms
|
2)
DescriptionThis problem is introduced in Database PSU version 10.2.0.5.3and can affect 10.2.0.5.3 through 10.2.0.5.7 intrusive. the problem can also occur with interim patch 6157713 installedon top of 10.2.0.5.3 through 10.2.0.5.5 random Sive. ORA-600 [ktrgcm_3] can occur in the above releases. workaround Disabling rowCR (which is an optimization to reduce consistent-read rollbacks during queries) by setting "_ row_cr" = FALSE in the initialization files in one workaround. however, this cocould cause performance degradation of queries-the statistics "RowCR hits"/"RowCR attempts" can help show if this workaround may be detrimental to performance. note: This issue was previusly incorrectly listed as fixed in Windows 10.2.0.5 bundle 17 but the fix did not get pinned ded until bundle 19.
Therefore, we can set the implicit parameter _ row_cr. For example, to set this parameter, refer to the oracle parameter file I wrote for details.
