This discussion is archived
7 Replies Latest reply: May 3, 2013 5:01 AM by 1006671 RSS

Oracle 11.2.0.2.0 on Ubuntu 13.04

1006671 Newbie
Currently Being Moderated
Hello all,

I'm trying to get Oracle 11.2.0.2.0 XE working on Ubuntu 13.04.
For some reason I keep getting the error: "ORA-00845: MEMORY_TARGET not supported on this system". I have checked several forums for an answer. All problems had something to do with a tmpfs that is too small.
I have tried mounting tmpfs of 8G without any luck. I tried both tmpfs and shmfs.

Here's my configuration atm:

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 904K 1.6G 1% /run
none 5.0M 0 5.0M 0% /run/lock
none 6.0G 36K 6.0G 1% /run/shm
none 100M 28K 100M 1% /run/user
/dev/sda1 180M 45M 126M 27% /boot
/dev/sdb1 688G 2.5G 651G 1% /home
/home/ydbondt/.Private 688G 2.5G 651G 1% /home/ydbondt
shmfs 6.0G 36K 6.0G 1% /run/shm

Kernel info:
Linux DELL-YOURI 3.8.0-19-generic #29-Ubuntu SMP Wed Apr 17 18:16:28 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux


I also have found another error in clsc.log:

Oracle Database 11g Clusterware Release 11.2.0.2.0 - Production Copyright 1996, 2010 Oracle. All rights reserved.
[    CLSE][1032939328]clse_get_crs_home: Error retrieving OLR configuration [0] [Error opening olr.loc file. No such file or directory]

Any ideas ?
  • 1. Re: Oracle 11.2.0.2.0 on Ubuntu 13.04
    Bas de Klerk Pro
    Currently Being Moderated
    Hi,

    what is the value of MEMORY_TARGET you are using ?
    It should not be larger than 1Gb (on XE ).

    Regw
  • 2. Re: Oracle 11.2.0.2.0 on Ubuntu 13.04
    1006671 Newbie
    Currently Being Moderated
    I think it is 1GB.
    I can see it in the initXE.ora file:

    XE.__db_cache_size=444596224
    XE.__large_pool_size=4194304
    XE.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
    *.audit_file_dest='/u01/app/oracle/admin/XE/adump'
    *.compatible='11.2.0.0.0'
    *.control_files='/u01/app/oracle/oradata/XE/control.dbf'
    *.db_name='XE'
    *.DB_RECOVERY_FILE_DEST='/u01/app/oracle/fast_recovery_area'
    *.DB_RECOVERY_FILE_DEST_SIZE=10G
    *.diagnostic_dest='/u01/app/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
    *.job_queue_processes=4
    *.memory_target=1073741824
    *.open_cursors=300
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sessions=20
    *.shared_servers=4
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS1'

    Edited by: 1003668 on May 2, 2013 4:50 AM
  • 3. Re: Oracle 11.2.0.2.0 on Ubuntu 13.04
    Bas de Klerk Pro
    Currently Being Moderated
    Hi,

    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
    </edit>

    Edited by: Bas de Klerk on 2-mei-2013 4:53
  • 4. Re: Oracle 11.2.0.2.0 on Ubuntu 13.04
    Balazs Papp Expert
    Currently Being Moderated
    Yes, because Oracle requires tmpfs mounted at /dev/shm, not /run/shm

    Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto
  • 5. Re: Oracle 11.2.0.2.0 on Ubuntu 13.04
    1006671 Newbie
    Currently Being Moderated
    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.
    See:

    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
  • 6. Re: Oracle 11.2.0.2.0 on Ubuntu 13.04
    1006671 Newbie
    Currently Being Moderated
    I have not created a separate ext3 partition though. Will try to reinstall with new partition first.
  • 7. Re: Oracle 11.2.0.2.0 on Ubuntu 13.04
    1006671 Newbie
    Currently Being Moderated
    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/shm
    This 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 0
    Edited by: 1003668 on May 3, 2013 5:01 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points