ORA-00602 ORA-07445 數據庫宕機

wangmaochun1982

出現ORA-00602 ORA-07445，重新startup又可以了，但過一段又出現及宕機，
系統:SUSE LINUX 10
數據庫：oracle10g 10.2.0.4.0
老大，幫忙看看
Errors in file /oracle/data/mesh/log/udump/mesh_ora_25562.trc:
ORA-07445: exception encountered: core dump [kghupr_flg()+387] [SIGSEGV] [Address not mapped to object] [0x000000070] [] []
Fri May 10 08:00:25 2013
Errors in file /oracle/data/mesh/log/udump/mesh_ora_25566.trc:
ORA-00600: internal error code, arguments: [17148], [0x0D34F7000], [], [], [], [], [], []
Fri May 10 08:00:30 2013
Errors in file /oracle/data/mesh/log/bdump/mesh_m000_25572.trc:
ORA-00600: internal error code, arguments: [17148], [0x0B22CB228], [], [], [], [], [], []
Fri May 10 08:00:32 2013
Errors in file /oracle/data/mesh/log/bdump/mesh_m000_25572.trc:
ORA-00600: internal error code, arguments: [17148], [0x0F540D758], [], [], [], [], [], []
Fri May 10 08:00:34 2013
Errors in file /oracle/data/mesh/log/bdump/mesh_m000_25572.trc:
ORA-00600: internal error code, arguments: [17148], [0x0A2D1B000], [], [], [], [], [], []
Fri May 10 08:00:35 2013
Errors in file /oracle/data/mesh/log/udump/mesh_ora_25586.trc:
ORA-00600: internal error code, arguments: [17148], [0x0E8C61000], [], [], [], [], [], []
Fri May 10 08:00:35 2013
Errors in file /oracle/data/mesh/log/udump/mesh_ora_25588.trc:
ORA-00600: internal error code, arguments: [17148], [0x0D34F7000], [], [], [], [], [], []
Fri May 10 08:00:36 2013
Errors in file /oracle/data/mesh/log/bdump/mesh_m000_25572.trc:
ORA-00600: internal error code, arguments: [17148], [0x0B12AE2A0], [], [], [], [], [], []
Fri May 10 08:00:37 2013
Errors in file /oracle/data/mesh/log/udump/mesh_ora_25586.trc:
ORA-00600: internal error code, arguments: [17148], [0x0E8C5F000], [], [], [], [], [], []
Fri May 10 08:00:38 2013
Errors in file /oracle/data/mesh/log/udump/mesh_ora_25594.trc:
ORA-00600: internal error code, arguments: [17148], [0x0E8C61000], [], [], [], [], [], []
Fri May 10 08:00:38 2013
Errors in file /oracle/data/mesh/log/bdump/mesh_m000_25572.trc:
ORA-00600: internal error code, arguments: [17148], [0x0B128A2A0], [], [], [], [], [], []
Fri May 10 08:00:39 2013
Errors in file /oracle/data/mesh/log/bdump/mesh_pmon_14797.trc:
ORA-07445: exception encountered: core dump [kghupr_flg()+387] [SIGSEGV] [Address not mapped to object] [0x000000070] [] []
Fri May 10 08:00:39 2013
Errors in file /oracle/data/mesh/log/bdump/mesh_pmon_14797.trc:
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghupr_flg()+387] [SIGSEGV] [Address not mapped to object] [0x000000070] [] []
Fri May 10 08:00:39 2013
PMON: terminating instance due to error 602
Instance terminated by PMON, pid = 14797

huang_tg

trace文件不全，上传Thu May  9 09:00:02 2013以后的trace文件。$ORACLE_HOME/OPatch/opatch lsinventory的结果贴出来！

yehc@epsoft.com

尝试将隐藏参数_bloom_filter_enabled改为FALSE，再观察。
问题类似bug：4927533，但在10.2.0.4版本的DB上出现还是比较奇怪，
建议开SR。
查看参数属性：

1. SQL> col KSPPINM for a30
   
2. SQL> col KSPPSTVL for a20
   
3. SQL> col KSPPDESC for a40
   
4. SQL> set lines 200
   
5. SQL> select ksppinm,ksppstvl,ksppdesc from x$ksppi a,x$ksppcv b where a.indx = b.indx and ksppinm='_bloom_filter_enabled';

复制代码

修改参数属性：

1. SQL> alter system set "_bloom_filter_enabled"=false scope=both;

复制代码

wangmaochun1982

Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/app
Central Inventory : /oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /oracle/app/oui
Log file location : /oracle/app/cfgtoollogs/opatch/opatch2013-05-10_10-27-14AM.log

Lsinventory Output file location : /oracle/app/cfgtoollogs/opatch/lsinv/lsinventory2013-05-10_10-27-14AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0
There are 2 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.