Ora-00600 Internal Error Code 17147
Contents |
Fundamentals Oracle Errors Performance Tuning ASM Datafiles & Tablespaces Exadata ORA-00600: internal error code, arguments: [17074] Bug 9795214 - Library ora-00600: internal error code, arguments Cache Memory Corruption / OERI[17074] may result in Instance crash [ID
My Oracle Support
9795214.8] I have Oracle 11.2.0.1 Enterprise Edition Installed on 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 mem
at line 145 to execute a command: call CY_ALL_GAOJINSHUCHU('2014-02-18') The error report: SQL ORA-00600: error: internal error code, 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 number for Oracle program exceptions. This indicates that a http://www.dbas-oracle.com/2011/06/ora-00600-internal-error-code-arguments.html 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 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 http://www.programering.com/a/MjN5QTNwATI.html 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 parameter cursor_sharing NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cursor_sharing string EXACT SQL> alter system set cursor_sharing=similar scope=both; The system has been changed. SQL> show parameter cursor_sharing NAME TYPE VALUE -------------------------
Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services https://community.hpe.com/t5/System-Administration/memory-single-bit-errors/td-p/3724128 Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private Cloud Information Governance Information Management IT Service Management Operations Management Server Management Software as a Service (SaaS) Software-Defined Data Center Storage Management All internal error Software Servers Rack Servers Tower Servers Blade Servers Density Optimized Mission Critical Servers Servers for Cloud Server Management All Servers Storage All-flash and Hybrid Storage Midrange and Enterprise Storage Entry Storage Systems Data Availability, Protection and Retention Software Defined Storage Management and Orchestration Storage Networking All Storage Networking Switches Routers Access Points and internal error code Controllers Wireless LAN Campus and Branch Networking Data Center Networking Wide Area Network Software Defined Networking Network Functions Virtualization Network Management All Networking About UsSupportClearType to search2086159Solutions Transform to a Hybrid Infrastructure Protect Your Digital Enterprise Empower the Data-Driven Organization Enable Workplace Productivity Cloud Security Big Data Mobility Infrastructure Internet of Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private Cloud Information Governance Information Management IT Service Management Operations Management Server Management Software as a Service (SaaS) Software-Defined Data Center Storage Management All Software Servers Rack Servers Tower Servers Blade Servers Density Optimized Mission Critical Servers Servers for Cloud Server Management All Servers Storage All-flash and Hybrid Storage Midrange and Enterprise Stora