ITPub博客

首页 > 数据库 > Oracle > ORA-07445 [eomg_migrate_if_oldnew()+61] during upgrade 11.2.0.4 database

ORA-07445 [eomg_migrate_if_oldnew()+61] during upgrade 11.2.0.4 database

原创 Oracle 作者:hurp_oracle 时间:2015-07-09 14:58:24 0 删除 编辑
问题描述:
   在升级到11.2.0.4版本时,如果参数文件不设置内存参数将导致升级失败,解决方法,设置内存参数,重新跑升级脚本

适用场景:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

证状:

During upgrade to 11.2.0.4 the following errors can be seen:

ORA-07445: exception encountered: core dump [eomg_migrate_if_oldnew()+61] [SIGSEGV] [ADDR:0x0] [PC:0x39F2EC1] [Address not mapped to object] []

-OR-

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x39F2E59, eomg_migrate_if_oldnew()+61] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/orcl_m000_24405.trc  (incident=2594):
ORA-07445: exception encountered: core dump [eomg_migrate_if_oldnew()+61] [SIGSEGV] [ADDR:0x0] [PC:0x39F2E59] [Address not mapped to object] []
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/orcl_ora_24328.trc  (incident=2586):
ORA-07445: exception encountered: core dump [eomg_migrate_if_oldnew()+61] [SIGSEGV] [ADDR:0x0] [PC:0x39F2E59] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_2594/orcl_m000_24405_i2594.trc
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_2586/orcl_ora_24328_i2586.trc

原因:
参数文件(pfile/spfile)里没有设置内存相关参数
Looking over in the alert log at startup of new 11.2.0.4 instance, we can observe that there is no parameter related to the memory, such as MEMORY_TARGET or SGA_TARGET.

解决方案:
- Add the following line to the pfile or spfile file used to startup the 11.2.0.4 instance:

  memory_target = 2048M

- Then shutdown and restart the instance in upgrade mode, and re-execute the post upgrade installation actions:

  sqlplus /nolog
  connect / as sysdba
  shutdown immediate
  startup upgrade
  @?/catupgrd.sql
  

This should then allow the upgrade to complete successfully.

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

请登录后发表评论 登录
全部评论

注册时间:2014-01-17

  • 博文量
    152
  • 访问量
    647365