ricky

158 积分	1 好友	8 主题

发消息

遇到ORA-07445: [pfrinstr_BRNCCOND+035c] [SIGSEGV]，在metlink查不到

1^#

发表于 2012-5-30 11:07:47 | 查看: 6580| 回复: 2

环境：rac系统
节点1
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/app/oracle/product/10.2/db
System name: AIX
Node name:    RESDB1
Release:       1
Version:       6
Machine:       00CD21164C00
Instance name: nrms1

描述：节点1的alert报错如下：节点2木有任何报错。

节点一alert日志：Tue May 29 15:17:44 2012
Errors in file /oracle/app/oracle/admin/nrms/udump/nrms1_ora_30277886.trc:
ORA-07445: exception encountered: core dump [pfrinstr_BRNCCOND+035c] [SIGSEGV] [Address not mapped to object] [0x11246A328] [] []
Tue May 29 15:17:44 2012
Errors in file /oracle/app/oracle/admin/nrms/udump/nrms1_ora_30277886.trc:
ORA-07445: exception encountered: core dump [pfrtra+0070] [SIGSEGV] [Address not mapped to object] [0x11246A328] [] []
ORA-07445: exception encountered: core dump [pfrinstr_BRNCCOND+035c] [SIGSEGV] [Address not mapped to object] [0x11246A328] [] []
Tue May 29 16:11:36 2012
注：alert只是简单抛出这个错误，其他的木有了！！
google和metlink无果~~

trace文件：

nrms1_ora_30277886.rar (163.52 KB, 下载次数: 756)

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-5-30 17:46:57

这个问题和调优有什么关系？请搞清楚基本的问题分类！

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2012-5-31 00:37:54

ODM DATA:

10.2.0.4.0 - 64bit + AIX

*** ACTION NAME:(测试窗口 - 用户资源提取.tst) 2012-05-29 15:17:44.148
*** MODULE NAME:(PL/SQL Developer) 2012-05-29 15:17:44.148
*** SERVICE NAME:(nrms) 2012-05-29 15:17:44.148
*** SESSION ID:(1646.25628) 2012-05-29 15:17:44.148
Exception signal: 11 (SIGSEGV), code: 50 (Address not mapped to object), addr: 0x11246a328, PC: [0x101456e1c, pfrinstr_BRNCCOND+035c]
Registers:
iar: 0000000101456e1c, msr: a00000000000d032
lr: 000000010145aa24,  cr: 0000000048222283
r00: 0000000000002710, r01: 0fffffffffff6dc0, r02: 000000011022a588,
r03: 00000001104e5858, r04: 00000000a545fa34, r05: 000000011056d158,
r06: 0000000001efd1d0, r07: 0000000001efd1e0, r08: 000000000000000c,
r09: 00000000000a545f, r10: 00000000000008d8, r11: 00000000000000d8,
r12: 000000010145a228, r13: 0000000110270c40, r14: 0000000000000000,
r15: 00000001104ebdf0, r16: 0000000000000000, r17: 0000000105006c80,
r18: 0000000000220283, r19: 0000000000000009, r20: 0000000000000000,
r21: 00000000a545f15c, r22: 0000000000000006, r23: 00000000ffffffdf,
r24: 00000000ffefffff, r25: 00000000fffffffd, r26: 00000000fffffffb,
r27: 0000000000000010, r28: 0000000000000000, r29: 0000000000000020,
r30: 0000000104c9bc78, r31: 0fffffffffff6e40,
*** 2012-05-29 15:17:44.154
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [pfrinstr_BRNCCOND+035c] [SIGSEGV] [Address not mapped to object] [0x11246A328] [] []
Current SQL statement for this session:

7445 +  SIGSEGV

stack call :  kkxexe => peicnt => plsql_run=> pfrrun=> ssexhd=> ksedmp=>ksdfsql=>kkxtcs = >peitcs=>pfrtcs =>ssexhd

相关案例：

ODM FINDING:

Hdr: 8502137 10.2.0.4 RDBMS 10.2.0.4 UNKNOWN PRODID-5 PORTID-59 ORA-7445
Abstract: ORA-7445 [PFRTCS()+60] [SIGSEGV] [UNKNOWN CODE] [0X20020007C] [] []
PROBLEM:
--------
Intermittently getting ora-7445 errors and core dumps on 10.2.0.4 database:

Thu Apr 23 03:28:05 2009
Errors in file /opt/oracle/admin/prod/udump/prod_ora_16277.trc:
ORA-7445: exception encountered: core dump [] [SIGSEGV] [unknown code]
[0x800003FFBFE40008] [] []
Thu Apr 23 03:28:05 2009
Errors in file /opt/oracle/admin/prod/udump/prod_ora_16277.trc:
ORA-7445: exception encountered: core dump [pfrtcs()+60] [SIGSEGV] [unknown
code] [0x20020007C] [] []
ORA-7445: exception encountered: core dump [] [SIGSEGV] [unknown code]
[0x800003FFBFE40008] [] []
Thu Apr 23 03:28:06 2009
Errors in file /opt/oracle/admin/prod/udump/prod_ora_16277.trc:
ORA-7445: exception encountered: core dump [xsstatedump()+220] [SIGSEGV]
[unknown code] [0x1CD00000048] [] []
ORA-7445: exception encountered: core dump [pfrtcs()+60] [SIGSEGV] [unknown
code] [0x20020007C] [] []
ORA-7445: exception encountered: core dump [] [SIGSEGV] [unknown code]
[0x800003FFBFE40008] [] []

DIAGNOSTIC ANALYSIS:
--------------------
strings command run against the core file shows some type of aq operations
occurring:

CITASYNC_Q
DMDC
      CITA_SYNC
CDR-447942278
<ATTRIBUTE ATTRITE'>
3:32:11</ATTRIBUTE>/FACILITY_NCID><APPLICATION>%QUEUEAPPLICATIONNAME%</APPLICA
TION><SHUTDOWN>%SHUTDOWN%</SHUTDOWN></PAYLOAD><EXTENDED_DATA>%EXTENDED_DATA%</
EXTENDED_DATA></MESSAGE>
AQ$_CITASYNC_QT_EDMDC

Unable to match with any known bugs - the errors seem very generic.
The trace files do not report currently executing sql, so we are unable
to determine what exactly is running when these errors occur.

WORKAROUND:
-----------
none

RELATED BUGS:
-------------

REPRODUCIBILITY:
----------------

TEST CASE:
----------

STACK TRACE:
------------
ksedmp: obtaining current SQL failed earlier. not retrying
----- Call Stack Trace -----
calling             call    entry             argument values in hex

location          type    point             (? means dubious value)

-------------------- -------- --------------------
----------------------------
ksedst()+40       ?       ksedst1()          C000000000141A18 ?
                                                C00000112DE84BF0 ?
                                                0ED7B9FED ?
                                                20202020676F746F ?
ksedmp()+424       ?       ksedst()          0ED7B9FED ?
                                                20202020676F746F ?
                                                8000000100122298 ?
                                                8000000100145D20 ?
ssexhd()+1100       ?       ksedmp()          000000000 ?
                                                C000000000141A08 ?
                                                000003F50 ?
                                                8000000100147B20 ?
_sigreturn()+0    ?       ssexhd()          0010B2640 ? 000000000 ?
                                                0467900F8 ?
                                                800003FFC0015600 ?
pfrtcs()+60       ?       _sigreturn()       800003FFC0014FCA ?
                                                4000000002406E6B ?
                                                000000000 ?
                                                800003FFC00154F3 ?
peitcs()+36       ?       pfrtcs()          800003FFC00154F3 ?
                                                392D30342D323320 ?
                                                8000000100121A98 ?
                                                0001B0000 ?

建议：
1.
再次执行该procedure ，确认可以重现该 7445  错误，若不能则继续观察或者忽略该问题

begin
  -- Call the procedure
  pg_ra_cut_userrscchange.selectuserlist(in_area_id => :in_area_id,
                                       in_tml_id => :in_tml_id,
                                       in_device_id => :in_device_id,
                                       in_equipment_list => :in_equipment_list,
                                       in_device_spec => :in_device_spec,
                                       in_res_type => :in_res_type,
                                       in_res_status => :in_res_status,
                                       in_start_res => :in_start_res,
                                       in_end_res => :in_end_res,
                                       in_query_type => :in_query_type,
                                       in_action_type => :in_action_type,
                                       in_pick_bind => :in_pick_bind,
                                       in_value => :in_value,
                                       in_exp_id => :in_exp_id,
                                       out_msg => :out_msg);
end;

2. 是否apply了 10.2.0.4.3的PSU ，考虑升级到 10.2.0.5.7

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册