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/ ,如需转载,请注明出处,否则将追究法律责任。