ORA-07445 [eomg_migrate_if_oldnew()+61] during upgrade 11.2.0.4 database-优快云博客

问题描述：
在升级到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.