Ora-00600 Internal Error 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 Instance crash [ID ora-00600: internal error code, arguments 9795214.8] I have Oracle 11.2.0.1 Enterprise Edition Installed on Red Hat Enterprise Linux ora 00600 internal error code arguments 2141 Server release 5.4 (Tikanga) 64 bit machine. It's my production environment. Suddenly Database goes down, In alert log files "ORA-00600:
Ora 00600 Internal Error Code Arguments 19004
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], [], [], [], [], [], [],
Ora-06512
[], [] 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 oracle support 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. There is no persistent corruption associated with this failure Error arguments: 1 - 17074 error number 2 - Pointer to the heap where th
getting insufficient privileges error:SQL> create database link ASCP_TO_PROD connect to apps_ro identified by apps_ro using 'PROD';ORA-01031: insufficient privileges while creating a database linkFix:SQL> alter session set current_schema = APPS_RO;Session altered.SQL> create database link ASCP_TO_PROD connect to apps_ro identified by apps_ro using 'PROD';Database link created. Posted by Santu Gadu at 11:37 PM No comments: User wants to query objects without prefix Problem:We have granted user DUMMY with select on all tables and views of APPS schema. But the user wants to access the tables http://www.dbas-oracle.com/2011/06/ora-00600-internal-error-code-arguments.html of APPS schema without using prefix.SQL> select count(*) from fnd_user;ORA-00942: table or view does not existFix:Create a trigger for schema to set current_schema at session level to apps and user need not use the prefix anymore.SQL> conn apps/appsSQL> CREATE OR REPLACE TRIGGER dummy_logon_trg AFTER logon ON DUMMY.SCHEMA DECLARE BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET CURRENT_SCHEMA =APPS'; END; /SQL> conn http://bindaasdba.blogspot.com/2012_03_01_archive.html dummy/dummySQL> select count(*) from fnd_user; COUNT(*)---------- 43 Posted by Santu Gadu at 11:22 PM No comments: Monday, March 26, 2012 Gather Schema Statistics failing after upgrading DB to 11.2.0.2 Problem:After upgrading the database to 11.2.0.2, Gather Schema Statistics was failing with following errors in the log file:Error #1: ERROR: While GATHER_TABLE_STATS:object_name=GME.GME_BATCH_HEADER***ORA-12805: parallel query server died unexpectedly***Following errors are observed in alert log as well:ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B5FAA85D510], [], [], [], [], [], [], [], [], [], []ORA-07445: exception encountered: core dump [qesaMSR2SorRecMerge()+265] [SIGSEGV] [ADDR:0x30] [PC:0x139B739] [Address not mapped to object] [] ORA-00603: ORACLE server session terminated by fatal errorORA-24557: error 600 encountered while handling error 600; exiting server processORA-00600: internal error code, arguments: [17147], [0x2B4C94C114F8], [], [], [], [], [], [], [], [], [], []ORA-00600: internal error code, arguments: [17147], [0x2B4C94C114F8], [], [], [], [], [], [], [], [], [], []ORA-00039: error during periodic actionORA-00600: internal error code, arguments: [17114], [0x2B4C94C114F8], [], [], [], [], [], [], [], [], [], []opidrv aborting process P007 ospid (23806) as a result of ORA-603 Fix:Bug 10013177
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], http://www.programering.com/a/MjN5QTNwATI.html [], [], [], [], [], [], [], [], [], [], [] ORA-06512: in "SCOTT.CY_ALL_GAOJINSHUCHU", line 1214 00600. 00000 - "internal http://www.anbob.com/archives/2626.html error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]" *Cause: This is the generic internal error number for Oracle internal error 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 where ttime=YESTORDAY and RESON_ATTRIBUTE='KPI' --and 00600 internal error 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 parameter cursor_sharing NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cursor_sharing str
数据库及GoldenGate产品的实施、性能调优、故障诊断等服务, 联系QQ:85304522 Submit 首页 About Me(DBA张维照) 站内地图 Goldengate JAVA MongoDB MYSQL ORACLE ORACLE 12C SQL Server 点滴岁月 精选软件 系统相关 老哥杂谈 Rss Feed Mail 首页 » ORACLE » Troubleshooting Instance crash after ora-7445[opiaba],ora-600 [kgh_heap_sizes:ds], ora-600 [17147] Troubleshooting Instance crash after ora-7445[opiaba],ora-600 [kgh_heap_sizes:ds], ora-600 [17147] 2015/08/24 ORACLE 136 views Troubleshooting Instance crash after ora-7445[opiaba],ora-600 [kgh_heap_sizes:ds], ora-600 [17147]已关闭评论 最近有一套数据库 crash ,环境2nodes RAC 11.2.0.3 on AIX , alert日志中记录了在crash前出现了ora-7445[opiaba],ora-600 [kgh_heap_sizes:ds], ora-600 [17147], 下面记录当时的一些日志。 # DB alert log Wed Sep 16 23:44:23 2015 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xF00000E161B7CD2] [PC:0x10662AFD4, opiaba()+788] [flags: 0x0, count: 1] Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_ora_21759124.trc (incident=191931): ORA-07445: 出现异常错误: 核心转储 [opiaba()+788] [SIGSEGV] [ADDR:0xF00000E161B7CD2] [PC:0x10662AFD4] [Address not mapped to object] [] Incident details in: /u01/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_191931/anbob1_ora_21759124_i191931.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Wed Sep 16 23:46:37 2015 Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_ora_21759124.trc (incident=191932): ORA-00600: 内部错误代码, 参数: [kgh_heap_sizes:ds], [0x700000E82B30018], [], [], [], [], [], [], [], [], [], [] ORA-07445: 出现异常错误: 核