Creating 11.2.0.4 DB using DBCA fails at 75% with the error:

ORA-29516: Aurora assertion failure: Assertion failure at joez.c:3422

排错步骤：
1. look at your shell limits, and ensure that your stack is set to less than two gigabytes:

ulimit -a

[oracle@DB01 ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 255685
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 2047
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

设置正确。

2. If you see any other mount options in file /etc/fstab after the word "defaults" for /dev/shm,
such as nosuid, nodev, or noexec:

none /dev/shm tmpfs defaults,nosuid,nodev,noexec 0 0

then remove these options from the entry in /etc/fstab:

none /dev/shm tmpfs defaults 0 0

then reboot the system for the changes to take effect.

/dev/mapper/vg_sys-lv_swap swap swap defaults 0 0
tmpfs /dev/shm tmpfs defaults,noexec,nodev,nosuid 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0

红色部分按照步骤2调整后，DBCA顺利完成DB创建。
参考文档：ID 1673407.1

ITPub博客

DBCA遭遇ORA-29516

最新文章