This content has been marked as final. Show 7 replies
what is the value of MEMORY_TARGET you are using ?
It should not be larger than 1Gb (on XE ).
I think it is 1GB.
I can see it in the initXE.ora file:
XE.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
Edited by: 1003668 on May 2, 2013 4:50 AM
normally on XE 11.2 an spfile is used, did you check the spfile or init.ora ?
<edit> just saw you posted initXE.ora so ignore my question
Edited by: Bas de Klerk on 2-mei-2013 4:53
Sorry Bas, I editted my question when I saw that the init.ora was not the correct file ;)
Balazs, I have setup the bootscript like on the tutorial you posted to mount the tmpfs, and it seems to be correct. Only the df -h only shows /run/shm.
ydbondt@DELL-YOURI:~$ sudo cat /etc/mtab | grep shm
none /run/shm tmpfs rw,nosuid,nodev 0 0
/run/shm /dev/shm none rw,bind 0 0
ydbondt@DELL-YOURI:~$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda6 110G 6.4G 98G 7% /
none 4.0K 0 4.0K 0% /sys/fs/cgroup
udev 7.8G 4.0K 7.8G 1% /dev
tmpfs 1.6G 900K 1.6G 1% /run
none 5.0M 0 5.0M 0% /run/lock
none 7.8G 808K 7.8G 1% /run/shm
none 100M 24K 100M 1% /run/user
/dev/sda1 180M 45M 126M 27% /boot
/dev/sdb1 688G 2.6G 651G 1% /home
/home/ydbondt/.Private 688G 2.6G 651G 1% /home/ydbondt
Edited by: 1003668 on May 2, 2013 11:38 PM
I have not created a separate ext3 partition though. Will try to reinstall with new partition first.
Ok, I have figured it out. Just like Balasz said, it's because the tmpfs is not mounted to /dev/shm.
If you open /etc/init/mounted-dev.conf you will see the following line:
[ -e /dev/shm ] || ln -s /run/shm /dev/shmThis creates a symlink from /dev/shm to /run/shm. For some reason oracle really needs the tmpfs to be mounted to /dev/shm.
I fixed it by commenting out the line in mounted-dev.conf and added the following in /etc/fstab:
shm /dev/shm tmpfs size=2g 0 0Edited by: 1003668 on May 3, 2013 5:01 AM