ORA-07445: exception encountered: core dump [hok2beg()+191]-优快云博客

本文记录了ORA-07445异常的排查过程，通过修改gatewayinit文件及listener.ora配置尝试解决问题。初步判断此问题由物化视图定时刷新引发。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-07445: exception encountered: core dump[hok2beg()+191] [SIGSEGV] [ADDR:0x0] [PC:0x66C67EB] [Address not mapped to object][] Errors in file/opt/oracle/diag/rdbms/seladevs/SELADEVS/trace/SELADEVS_j001_27250.trc (incident=41712):

初步确定是由于物化视图定时刷新产生这个错的，

修改gateway init文件，

[oracle@oracnbj008 admin]$ vi initdg4msql.ora
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server

#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[SQLCNBJ015]:3888//MDM_StagingDB
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=255（开trace文件,如果要关掉就设为false）
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_FDS_FETCH_ROWS=1

oracle support 分析后认为listener.ora中没有加ENV项，于是加上去，如下：

vi listener.ora

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = dg4msql)
      (ORACLE_HOME = /opt/oracle/product/11.2.0/dbhome_1)
      (ENV="LD_LIBRARY_PATH=/opt/oracle/product/11.2.0/dbhome_1/dg4msql/driver/lib:/opt/oracle/product/11.2.0/dbhome_1/lib")
      (PROGRAM = dg4msql)
    )

    (SID_DESC =
      (SID_NAME = mdmdist)
      (ORACLE_HOME = /opt/oracle/product/11.2.0/dbhome_1)
      (ENV="LD_LIBRARY_PATH=/opt/oracle/product/11.2.0/dbhome_1/dg4msql/driver/lib:/opt/oracle/product/11.2.0/dbhome_1/lib")
      (PROGRAM = dg4msql)
    )

)