ORA-07445: exception encountered: core dump [hok2beg()+191]

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)
    )

  )


生启后错误依旧,看来这不是根本原因,

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:大白 设计师:CSDN官方博客 返回首页
评论

打赏作者

lixiaohuiok111

你的鼓励将是我创作的最大动力

¥2 ¥4 ¥6 ¥10 ¥20
输入1-500的整数
余额支付 (余额:-- )
扫码支付
扫码支付:¥2
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值