create database ora-03113

yobyin

suse 11  sp1 64位， oracle 11
hp bl60 刀片 64G内存。双rac节点
rac 软件都装好了,在用dbca  create database  到3% 时就hang 住了 报ora-03113
.
sysctl.conf 文件
kernel.shmall = 8388608
kernel.shmmax = 34359738368
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 4194304

还有一个特点，单个lun 有的2t多，又在lun 组上建的lv , 映射raw .
请各位分析是什么问题

[ 本帖最后由 yobyin 于 2012-6-3 10:57 编辑 ]

Maclean Liu(刘相兵

把alert.log 日志上传

Maclean Liu(刘相兵

ODM DATA:

11.1.0.7.0   + Linux x86_64

  memory_target            = 25856M  使用AMM  25GB

Reconfiguration complete
Errors in file /opt/oracle/diag/rdbms/pm4h/pm4h1/trace/pm4h1_mman_15576.trc:
ORA-27103: internal error
Additional information: -1
Additional information: 1
MMAN (ospid: 15576): terminating the instance due to error 27103
System state dump is made for local instance
Trace dumping is performing id=[cdmp_20120602124449]
Instance terminated by MMAN, pid = 15576

MMAN进程 终止了实例

MMAN TRACE:

error 27103 detected in background process
ORA-27103: internal error
Additional information: -1
Additional information: 1

*** 2012-06-02 12:44:49.942
MMAN (ospid: 15576): terminating the instance due to error 27103
ksuitm: waiting up to [5] seconds before killing DIAG

[oracle@vrh8 ~]$ oerr ora 27103
27103, 00000, "internal error"
// *Cause: internal error
// *Action: contact Oracle support



kernel.shmmax = 34359738368 =>  32GB


ODM FINDING:


ORA-27103 when Memory target parameter is set to more than 3 GB

Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.1.0.7 - Release: 11.1 to 11.1
Linux x86-64
Symptoms
When setting the memory_target parameter on 11.1.0.7 > 3GB, 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

ORA-27103: internal error
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: -1
Additional information: 1
MMAN (ospid: 12249): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 12249

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

OR

DBCA fails with ORA-03114 error

This issue is not reproduced in 11.1.0.6
Changes

Applied the 11.1.0.7 patch set.
Cause
The problem is due to Bug:7272646, introduced in 11.1.0.7 patchset 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

An interim Patch:7272646 is available on My Oracle Support for Linux x86-64 11.1.0.7.
After applying the patch, test with memory_target set  > 3GB to verify patch resolves issue.

To workaround the issue:

1. Reduce value for kernel parameter SHMMAX below 4Gb (4294967296). This will cause more shared memory segments to be created for the instance SGA. There is no impact to setting SHMMAX lower.


建议：

这是11.1.0.7上的一个bug ，当 memory_target >3GB时 会触发，

解决方案：

1.  apply Patch:7272646
2.  降低 SHMMAX   到4GB以下

無限追云

学习了        

看来生产库，还是直接上11gR2好

yobyin

谢谢，老大， 我已经打了patch