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

hurp_oracle發表於2015-07-09
問題描述:
   在升級到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部落格 ” ,連結:http://blog.itpub.net/29446986/viewspace-1727653/,如需轉載,請註明出處,否則將追究法律責任。

相關文章