`

ORA-27013

阅读更多

很新的一个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 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics