ORA-7445(koiogex)错误

在一个数据库的alert文件中发现了这个ORA-7445错误，这个错误应该是升级不完全造成的问题。

 

 

错误信息为：

Errors in file /opt/oracle/admin/data01/udump/data01_ora_7327.trc:
ORA-07445: exception encountered: core dump [0000000101BFDCAC] [SIGSEGV] [Address not mapped to object] [0x00000009C] [] []

详细的trace文件内容：

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x9c, PC: [0x101bfdcac, 0000000101BFDCAC]
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [0000000101BFDCAC] [SIGSEGV] [Address not mapped to object] [0x00000009C] [] []
Current SQL statement for this session:
BEGIN :1 := "SYS"."DBMS_AW_EXP".schema_info_exp(:2,:3,:4,:5,:6); END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
4012ff94020       106  package body SYS.DBMS_AW
4012ff94020       222  package body SYS.DBMS_AW
40143214ff8       264  package body SYS.DBMS_AW_EXP
401326627d8         1  anonymous block
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedmp()+328         CALL     ksedst()+0           FFFFFFFF7FFF5A60 ?
                                                   000000000 ? 000000000 ?
                                                   00000003E ?
                                                   FFFFFFFF7FFF62F8 ?
                                                   1031C9458 ?
ssexhd()+604         CALL     ksedmp()+0           000000000 ? 000103400 ?
                                                   0001035CD ? 000102C00 ?
                                                   1035CD000 ? 1035CD328 ?
sigacthandler()+44   PTR_CALL 0000000000000000     1035D5000 ?
                                                   FFFFFFFF7FFF7290 ?
                                                   000000000 ? 000000001 ?
                                                   1035D24D8 ? 00000000B ?
koiogex()+76         PTR_CALL 0000000000000000     00000000B ?
                                                   FFFFFFFF7FFF7290 ?
                                                   FFFFFFFF7FFF6FB0 ?
                                                   00000000B ? 000000000 ?
                                                   000000000 ?
OCIObjectExists()+9  CALL     koiogex()+0          1035CD588 ? 0000000A4 ?
00                                                 10358EB18 ?
                                                   FFFFFFFF7FFF777C ?
                                                   00000000B ? 00000000C ?
build_namelist()+48  CALL     OCIObjectExists()+0  FFFFFFFF7D069698 ?
                                                   FFFFFFFF7CE0FA30 ?
                                                   0000000A4 ?
                                                   FFFFFFFF7FFF777C ?
                                                   102BEC440 ? 000039400 ?
xseifExportTable()+  CALL     build_namelist()+0   FFFFFFFF7FFF7988 ?
236                                                0000000A4 ? 103741188 ?
                                                   000000001 ?
                                                   FFFFFFFF7FFF7988 ?
                                                   000000000 ?

根据METALINK查询的结果：Doc ID:  Note:416063.1，造成这个问题的原因是OLAP组件的状态不正常：

SQL> SELECT COMP_NAME, STATUS FROM DBA_REGISTRY;

COMP_NAME                                STATUS
---------------------------------------- -----------
Oracle OLAP API                          UPGRADED
OLAP Analytic Workspace                  UPGRADED
Oracle Text                              VALID
Oracle interMedia                        VALID
Oracle9i Java Packages                   VALID
Oracle XDK for Java                      VALID
JServer JAVA Virtual Machine             VALID
Oracle9i Packages and Types              VALID
Oracle9i Catalog Views                   VALID
Oracle Workspace Manager                 VALID
Spatial                                  VALID
Oracle XML Database                      VALID
Oracle Ultra Search                      VALID
Oracle Data Mining                       VALID
OLAP Catalog                             VALID

15 rows selected.

由于OLAP的状态不正常，导致全库导出过程中，出现了这个错误。

Oracle给出的解决方法是STARTUP MIGRATE，然后运行?/rdbms/admin/catpatch.sql脚本。

这个方法需要重新启动数据库，且需要执行CATPATCH.SQL，代价相对较大。对于一些确认不使用OLAP的环境，可以通过避免全库导出，或者直接删除OLAP用户的方法来避免问题的产生。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-366056/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-366056/