3 Replies Latest reply: Feb 5, 2013 12:59 PM by Srini Chavali-Oracle RSS

    [Linux Mint 14] ORA-00845: MEMORY_TARGET again and again !

    989172
      Good Morning,
      I decided to use Oracle 11g XE on Linux Mint. I read this tutorial Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto included the seventh part. However, I did a minor change in the script given. Indeed, since Ubuntu 12.04, a bug appeared. So I use the following script :
      cat > /etc/init.d/oracle-shm <<-EOF
      #! /bin/sh
      # /etc/init.d/oracle-shm
      #
      #
      case "\$1" in
        start)
          echo "Starting script /etc/init.d/oracle-shm"
          # Run only once at system startup
          if [ -e /dev/shm/.oracle-shm ]; then
            echo "/dev/shm is already mounted, nothing to do"
          else
            rm -f /dev/shm
            mkdir /dev/shm
            mount --move /dev/shm /run/shm
            mount -B /dev/shm /run/shm
            touch /dev/shm/.oracle-shm
          fi
          ;;
        stop)
          echo "Stopping script /etc/init.d/oracle-shm"
          echo "Nothing to do"
          ;;
        *)
          echo "Usage: /etc/init.d/oracle-shm {start|stop}"
          exit 1
          ;;
      esac
      #
      ### BEGIN INIT INFO
      # Provides:          oracle-shm
      # Required-Start:    $remote_fs $syslog
      # Required-Stop:     $remote_fs $syslog
      # Default-Start:     2 3 4 5
      # Default-Stop:      0 1 6 
      # Short-Description: Bind /run/shm to /dev/shm at system startup.
      # Description:       Fix to allow Oracle 11g use AMM.
      ### END INIT INFO
      EOF
      This changement has been suggested in this post : Re: Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto

      I already uninstalled and reinstalled Oracle 3-4 times, but nothing else happened. When I want to configure oracle-xe, I have a such message :
      Starting Oracle Net Listener...Done
      Configuring database...
      Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for details
      And this is the content of the file postDBCreation.log :
      begin
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available 
      Process ID: 0 
      Session ID: 0 Serial number: 0 
      
      
      
      File created.
      
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory
      ORA-00845: MEMORY_TARGET not supported on this system
      select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available 
      Process ID: 0 
      Session ID: 0 Serial number: 0 
      
      
      BEGIN utl_recomp.recomp_serial(); END;
      
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available 
      Process ID: 0 
      Session ID: 0 Serial number: 0 
      
      
      select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available 
      Process ID: 0 
      Session ID: 0 Serial number: 0 
      Does someone have any suggestion ?

      Thanks.