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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29446986/viewspace-1727653/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Upgrade Oracle Database from 10.2.0.1 to 11.2.0.4OracleDatabase
- upgrade 10.2.0.5 to 11.2.0.4 on linuxLinux
- How to Move or Copy a Tablespace to Another Database (61)Database
- What documents and steps should be reviewed during upgrade to R12View
- ORA-39700: database must be opened with UPGRADE optionDatabase
- ora-07445 LATCHING DURING KSSADPM/KSSREM OPERATIONS,bug 4927533.REM
- Oracle Database Upgrade Path Reference List [ID 730365.1]OracleDatabase
- Supporting Bigfile Tablespaces During Database Creation (77)Database
- oracle 11.2.0.4 rac節點異常當機之ORA-07445Oracle
- 11.2.0.3 database異機升級至11.2.0.4Database
- ORA-279 signalled during: alter database recover logfileDatabase
- Getting "JVM_GetClassSignature" error message during upgrade of GC_888769.1JVMErrorGC
- Oracle案例04——ORA-39700: database must be opened with UPGRADE optionOracleDatabase
- ORA-1113 signalled during: alter database open...Database
- Ora-12720 During Rman Duplication Of Database (文件 ID 341089.1)Database
- Upgrade Advisor: Database from 10.2 to 11.2 (文件 ID 251.1)Database
- Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2DatabaseASM
- Download and Run Oracle's Database Pre-Upgrade Utility [ID 884522.1]OracleDatabase
- 1 Oracle Database 11g Release 2 (11.2.0.4) New FeaturesOracleDatabase
- [重慶思莊每日技術分享]-oracle ins,INS-32027 during Oracle 12 upgradeOracle
- PMON TRYING TO START CJQ0 DURING DATABASE SHUTDOWN-ORA-443&ORA-450Database
- Use Database Replay Feature to Help With Upgrade From 10.2.0.4 to 11g_748895.1Database
- 1Z0-060: Upgrade to Oracle Database 12c的理解OracleDatabase
- ORACLE rac 11.2.0.4 for rhel7.8 upgrade to 19.11.1 報錯ORA-29516處理Oracle
- RAC 例項不能啟動 ORA-1589 signalled during ALTER DATABASE OPENDatabase
- ORACLE-1Z0-060題庫(Upgrade to Oracle Database 12c)OracleDatabase
- oracle 11.2.0.4之oracle database db link之測試明細之一OracleDatabase
- [Upgrade] Oracle 10.2.0.5 PSU upgradeOracle
- [Upgrade] Oracle 10.2.0.5 opatch utility upgradeOracle
- Using silent mode to install GC 10.2.0.1 and upgrade GC to 10.2.0.5 by Using an Existing Database onGCDatabase
- [Upgrade] Oracle 10.2.0.1 --> 10.2.0.5 patchset Upgrade.Oracle
- [重慶思莊每日技術分享]-ORA-1142 signalled during: ALTER DATABASE END BACKUPDatabase
- SAP Errors described – from 61-228 to 61-245Error
- SAP Errors described – from 61-21 to 61-227Error
- 10.2.0.3 升級到 10.2.0.4 database upgrade 報ORA-03113錯誤解決方法Database
- 2.3.3.3 Application UpgradeAPP
- Failed to create or upgrade OLRAI
- My first Upgrade projectProject