7 Replies Latest reply: May 3, 2013 7:01 AM by 1006671 RSS

    Oracle 11.2.0.2.0 on Ubuntu 13.04

    1006671
      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
          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
            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
              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
                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
                  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
                    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
                      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