ORA-07445: exception encountered: core dump [pevm_MOVC_i()+117]

saup007

之前遇到过类似的，但 ora 7445 函数只有pfrinstr_BRNCNULL，现在还有pevm_MOVC_i()+117，但trace文件内函数调用顺序却又相同

只在刷包（1、2个包）之后，alter有如此错误。

https://forums.oracle.com/thread/2460154?tstart=0

原来的给的解决是升级 APEX ，也没发现有什么影响，也就没升级。这是另一个库，发生类似的报错。

APEX到底是什么？貌似也没用到它啊？

alter 日志：更多的在附件：

1. Thu Nov 14 18:34:13 2013
   
2. Changing destination 2 from remote to local during archival of log#: 1 sequence#: 24040 thread#: 1
   
3. Archived Log entry 48046 added for thread 1 sequence 24040 ID 0x50d91174 dest 1:
   
4. Thu Nov 14 18:49:29 2013
   
5. Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2B91001912D7] [PC:0x916D4AB, pevm_MOVC_i()+117] [flags: 0x0, count: 1]
   
6. Thu Nov 14 18:49:30 2013
   
7. Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1A12D7] [PC:0x9164998, pfrinstr_BRNCNULL()+58] [flags: 0x0, count: 1]
   
8. Thu Nov 14 18:49:30 2013
   
9. Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1A12D7] [PC:0x9164998, pfrinstr_BRNCNULL()+58] [flags: 0x0, count: 1]
   
10. Errors in file /u01/app/oracle/diag/rdbms/huoying/HUOYING/trace/HUOYING_ora_17442.trc  (incident=169385):
    
11. ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+58] [SIGSEGV] [ADDR:0x1A12D7] [PC:0x9164998] [Address not mapped to object] []
    
12. Incident details in: /u01/app/oracle/diag/rdbms/huoying/HUOYING/incident/incdir_169385/HUOYING_ora_17442_i169385.trc
    
13. Use ADRCI or Support Workbench to package the incident.
    
14. See Note 411.1 at My Oracle Support for error and packaging details.
    
15. Errors in file /u01/app/oracle/diag/rdbms/huoying/HUOYING/trace/HUOYING_ora_26654.trc  (incident=175313):
    
16. ORA-07445: 出现异常错误: 核心转储 [pevm_MOVC_i()+117] [SIGSEGV] [ADDR:0x2B91001912D7] [PC:0x916D4AB] [Address not mapped to object] []
    
17. Incident details in: /u01/app/oracle/diag/rdbms/huoying/HUOYING/incident/incdir_175313/HUOYING_ora_26654_i175313.trc
    
18. Use ADRCI or Support Workbench to package the incident.
    
19. See Note 411.1 at My Oracle Support for error and packaging details.
    
20. Errors in file /u01/app/oracle/diag/rdbms/huoying/HUOYING/trace/HUOYING_ora_17710.trc  (incident=170146):
    
21. ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+58] [SIGSEGV] [ADDR:0x1A12D7] [PC:0x9164998] [Address not mapped to object] []
    
22. Incident details in: /u01/app/oracle/diag/rdbms/huoying/HUOYING/incident/incdir_170146/HUOYING_ora_17710_i170146.trc
    
23. Use ADRCI or Support Workbench to package the incident.
    
24. See Note 411.1 at My Oracle Support for error and packaging details.
    
25. Thu Nov 14 18:49:31 2013
    
26. Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2012D7] [PC:0x9164998, pfrinstr_BRNCNULL()+58] [flags: 0x0, count: 1]
    
27. Errors in file /u01/app/oracle/diag/rdbms/huoying/HUOYING/trace/HUOYING_ora_20913.trc  (incident=172361):
    
28. ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+58] [SIGSEGV] [ADDR:0x2012D7] [PC:0x9164998] [Address not mapped to object] []
    
29. Incident details in: /u01/app/oracle/diag/rdbms/huoying/HUOYING/incident/incdir_172361/HUOYING_ora_20913_i172361.trc
    
30. Use ADRCI or Support Workbench to package the incident.
    
31. See Note 411.1 at My Oracle Support for error and packaging details.
    
32. Thu Nov 14 18:49:31 2013
    
33. Dumping diagnostic data in directory=[cdmp_20131114184931], requested by (instance=1, osid=17442), summary=[incident=169385].
    
34. Thu Nov 14 18:49:34 2013
    
35. Sweep [inc][175313]: completed
    
36. Sweep [inc][172361]: completed
    
37. Sweep [inc][170146]: completed
    
38. Sweep [inc][169385]: completed
    
39. Sweep [inc2][172361]: completed
    
40. Sweep [inc2][169385]: completed

复制代码

Maclean Liu(刘相兵

1、何谓 刷包？　
2、帖子里没版本信息的帖子一律不看

saup007

Maclean Liu(刘相兵 发表于 2013-11-16 19:48
1、何谓 刷包？　
2、帖子里没版本信息的帖子一律不看

刷包就是有一个 package需要要更新，用PL/SQL Developer工具，create or replace一次，就替换掉原来包的内容。（PL/SQL Develop保存为pck的包文件，拖到PL/SQL Developer工具里，按F8执行。）

版本信息，我以为在trace文件里有，而且没有打opatch，就没有写。11.2.0.2。

Maclean Liu(刘相兵

刷包就是有一个 package需要要更新


==>一般叫换包吧？  replace package

Maclean Liu(刘相兵

Dump continued from file: /u01/app/oracle/diag/rdbms/huoying/HUOYING/trace/HUOYING_ora_26654.trc
ORA-07445: 出现异常错误: 核心转储 [pevm_MOVC_i()+117] [SIGSEGV] [ADDR:0x2B91001912D7] [PC:0x916D4AB] [Address not mapped to object] []

stack call pfrrun_no_tool=>pfrinstr_MOVC=>pevm_MOVC_i

Maclean Liu(刘相兵

BUG 14186852 - PACKAGE FAILING WITH ORA-07445 [PEVM_MOVC_I()]

这个bug 似乎还没有被修复，  


是否能够通过alter system flush shared_pool 来绕过？ 这个问题是 一运行这个语句就回被触发，还是偶尔触发？

saup007

Maclean Liu(刘相兵 发表于 2013-11-18 11:00
BUG 14186852 - PACKAGE FAILING WITH ORA-07445  

这个bug 似乎还没有被修复，  

以前都是create or replace时，包名为PKG_OPTION，才会在alter日志看到这个错误。

今天第一次看到在执行时也报这个错误，详细的trace在附件中。

PKG_GATEWAY 中间会调用PKG_OPTION