很新的一个bug,看下你的 memory_target是不是>3G
主题: ORA-27103 when Memory target parameter is set to more than 3 GB
文档 ID: 743012.1 类型: PROBLEM
上次修订日期: 08-OCT-2009 状态: PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
References
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.1.0.7
Linux x86-64
Symptoms
When setting the memory_target parameter on 11.1.0.7 > 3 GB , The instance can not start up and crashes with the following errors displayed in the alert log :
ALTER DATABASE MOUNT
This instance was first to mount
Errors in file /oracle/app/oracle/diag/rdbms/dwhp/DWHP1/trace/DWHP1_mman_22192.trc:
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 22192): terminating the instance due to error 27103
System state dump is made for local instance
System State dumped to trace file /oracle/app/oracle/diag/rdbms/dwhp/DWHP1/trace/DWHP1_diag_22166.trc
Trace dumping is performing id=[cdmp_20080929103326]
Instance terminated by MMAN, pid = 22192
OR:
Errors in file /app/oemrep/diag/rdbms/emrep/emrep/trace/emrep_mman_30849.trc:
ORA-27103: internal error
Linux-x86_64 Error: 17: File exists
Additional information: -1
Additional information: 1
MMAN (ospid: 30849): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 30849
This issue is not reproduced in 11.1.0.6
Changes
Applied the 11.1.0.7 patch set.
Cause
Due to Bug 7272646
This problem is introduced in 11.1.0.7 on 64bit Linux .
In some cases after applying the 11.1.0.7 patch set on 64Bit Linux x86 the instance will not start when
MEMORY_TARGET > 3GB.
Solution
To solve the issue need to do the following :
1.) Download and apply Patch 7272646 available on metalink for Linux x86-64 11.1.0.7
2.) After applying the patch, test with memory_target set > 3GB to verify patch resolves issue.
References
ORA-27013
最新推荐文章于 2023-10-29 15:52:45 发布