Ora-00600 Internal Error Code Arguments 17147
Contents |
Fundamentals Oracle Errors Performance Tuning ASM Datafiles & Tablespaces Exadata ORA-00600: internal error code, arguments: [17074] Bug 9795214 - Library Cache Memory Corruption / OERI[17074] may result in
Ora 00600 Internal Error Code Arguments 2141
Instance crash [ID 9795214.8] I have Oracle 11.2.0.1 Enterprise Edition Installed on oracle support Red Hat Enterprise Linux Server release 5.4 (Tikanga) 64 bit machine. It's my production environment. Suddenly Database goes down, In alert log files "ORA-00600: internal error code, arguments: [17074]" message was written. Error message is like: Errors in file /test01/diag/rdbms/test01/test01/trace/test01_mman_27018.trc (incident=211313): ORA-00600: internal error code, arguments: [17074], [0x75F3F9FD0], [0x7AC0E9C80], [6], [], [], [], [], [], [], [], [] Incident details in: /test01/diag/rdbms/test01/test01/incident/incdir_211313/test01_mman_27018_i211313.trc Errors in file /test01/diag/rdbms/test01/test01/trace/test01_mman_27018.trc: ORA-00600: internal error code, arguments: [17074], [0x75F3F9FD0], [0x7AC0E9C80], [6], [], [], [], [], [], [], [], [] MMAN (ospid: 27018): terminating the instance due to error 822 Instance terminated by MMAN, pid = 27018 On investigation i found this bug ........ This note gives a brief overview of bug 9795214. Affects: Product (Component)Oracle Server (Rdbms) Range of versions believed to be affected Versions >= 11.1 but BELOW 12.1 Versions confirmed as being affected 11.2.0.2 11.2.0.1 11.1.0.7 Platforms affectedGeneric (all / most platforms affected) Fixed: This issue is fixed in 12.1 (Future Release) 11.1.0.7.7 Patch Set Update 11.2.0.1 Patch 8 on Windows Platforms 11.1.0.7 Patch 38 on Windows Platforms Symptoms: Related To: Instance May Crash Memory Corruption Mutex Contention ORA-822 ORA-600 [17074] ORA-600 [kglhpd-bad-free] Dump in or under KGHISPIR (None Specified) Description ORA-600 [17074] may occur in some rare circumstances, potentially causing an instance crash From 11g onwards library cache latches are replaced by the mutex (short for mutual exclusion) concurrent programming algorithm. This issue is a mutex race condition where conflicting updates on a library cache memory chunk result in ORA-600 [17074]. This issue is intermittent and rare due to the precise timing required for the contending memory chunk access. This error results in process failure. Where the process is a critical background process this will result in an instance crash.
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Jan 11, 2013 7:14 AM by 837700 ORA-00600: internal error code, arguments: [17182], [0x1106559F0], [], [], 810723 May 2, 2012 5:41 http://www.dbas-oracle.com/2011/06/ora-00600-internal-error-code-arguments.html PM Refresh MatView causing ORA ORA-00600: internal error code, arguments: [17182], [0x1106559F0], [], [], error. Database Version: 11.1.0.6, IBM AIX system when run: dbms_mview.refresh('mart.mv_cust_header','?') , it fails with the above error. Fixed few times by dropping and rebuldibng the MatView but it is not resolved. The issue is with production system. Any help on this will be greatly appreciated. https://community.oracle.com/thread/2385536 Thanks, Junr DBA I have the same question Show 0 Likes(0) 2964Views Tags: none (add) ora-00600Content tagged with ora-00600 This content has been marked as final. Show 5 replies 1. Re: ORA-00600: internal error code, arguments: [17182], [0x1106559F0], [], [], sb92075 May 2, 2012 5:45 PM (in response to 810723) Junr DBA wrote: Refresh MatView causing ORA ORA-00600: internal error code, arguments: [17182], [0x1106559F0], [], [], error. Database Version: 11.1.0.6, IBM AIX system when run: dbms_mview.refresh('mart.mv_cust_header','?') , it fails with the above error. Fixed few times by dropping and rebuldibng the MatView but it is not resolved. The issue is with production system. Any help on this will be greatly appreciated. Thanks, Junr DBAORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support 1 person found this helpful Like Show 0 Likes(0) Actions 2. Re: ORA-00600: internal error code, arguments: [17182], [0x1106559F0], [], [], 810723 May 2, 2012 6:06 PM (in response to sb92075) Thanks. Is it bug in 11.1.0.6 version? Thanks, Junr Dba Like Show 0 Likes(0) Actions 3. Re: ORA-00600: i
at line 145 to execute a command: call CY_ALL_GAOJINSHUCHU('2014-02-18') The error report: SQL ORA-00600: error: internal error code, http://www.programering.com/a/MjN5QTNwATI.html parameters: [qcsfbdnp:1], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: in "SCOTT.CY_ALL_GAOJINSHUCHU", line 1214 00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]" *Cause: This is the generic internal error internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. *Action: Report as a bug - the first argument is the internal error number merge into ( select ttime,thour,sum_flag,mo,fault_type, CURRENT_INDEX_VALUE as INDEX_VALUE,CH_RAT from CY_PROP_REASON internal error code where ttime=YESTORDAY and RESON_ATTRIBUTE='KPI' --and mo='FR3SAL3' ) cp using ( select wm_concat(ttime) as WM_CONCAT_TTIME,thour,sum_flag,mo,max(FAULT_TYPE) as max_fault_type, avg(CURRENT_INDEX_VALUE) as INDEX_AVG_VALUE --,wm_concat(fault_description) as fault_description from( select ttime,thour,sum_flag,mo,fault_type,fault_description,CURRENT_INDEX_VALUE from CY_PROP_REASON where ttime in (YESTORDAY,TWO_DAYS_AGO,THREE_DAYS_AGO) and RESON_ATTRIBUTE='KPI' --and mo='FR3SAL3' order by ttime,thour,sum_flag,mo ) group by thour,sum_flag,mo ) cpsum on ( cp.thour=cpsum.thour and cp.sum_flag=cpsum.sum_flag and cp.mo=cpsum.mo and cp.fault_type=cpsum.max_fault_type ) when matched then update set cp.CH_RAT=decode(cpsum.INDEX_AVG_VALUE-cp.INDEX_VALUE, 0,'0.0%', null,null, decode(cpsum.INDEX_AVG_VALUE,0,'0.0%', to_char((cpsum.INDEX_AVG_VALUE-cp.INDEX_VALUE)*100/cpsum.INDEX_AVG_VALUE,'99990.99')||'%' ) ); Microsoft Windows version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Administrator>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Friday, February 21 14:56:50 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Not connected to the SP2-0640 SQL> conn sys/fsyd@192.168.1.108:1521/fsyd as sysdba The connected. The session has changed. SQL> show param