8 Replies Latest reply: Oct 22, 2012 1:05 PM by 969973 RSS

    Oracle database express edition 11g release 2 on SLES 10 SP2

    926656
      Hello

      I would appreciate any help in this topic I am not so familiar with installation oracle database.

      I am trying to install oracle database 11g on SLES 10 SP2. Installation is finished without the errors.
      When I try to configure oracle database (/etc/init.d/oracle-xe configure) I got the following error 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

      The logs contains some errors ...


      cloneDBCreation.log
      Create controlfile reuse set database "XE"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      BEGIN dbms_backup_restore.zerodbid(0); END;

      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      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
      Create controlfile reuse set database "XE"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter system enable restricted session
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter database "XE" open resetlogs
      *

      CloneRmanRestore.log

      ORA-00845: MEMORY_TARGET not supported on this system
      select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      declare
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0



      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0

      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

      postScripts.log
      CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS '/u01/app/oracle/product/11.2.0/xe/lib/libqsmashr.so';
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      BEGIN dbms_datapump_utl.replace_default_dir; END;

      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      commit
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      create or replace directory XMLDIR as '/u01/app/oracle/product/11.2.0/xe/rdbms/xml'
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      DROP DIRECTORY ORACLE_OCM_CONFIG_DIR
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0



      Package requirments :
      binutils-2.16.91.0.5-23.31
      gcc-4.1.2_20070115-0.21
      make-3.80-202.2
      glibc-2.4-31.54
      libaio-0.3.104-14.2

      System rquirments:
      cat /etc/SuSE-release
      SUSE Linux Enterprise Server 10 (x86_64)
      VERSION = 10
      PATCHLEVEL = 2

      Disk /dev/sda: 42.9 GB, 42949672960 bytes
      255 heads, 63 sectors/track, 5221 cylinders
      Units = cylindry of 16065 * 512 = 8225280 bytes

      Zařízení Boot Start End Blocks Id System
      /dev/sda1 * 1 26 208813+ 83 Linux
      /dev/sda2 27 288 2104515 82 Linux swap / Solaris
      /dev/sda3 289 5221 39624322+ 8e Linux LVM

      /etc/hosts
      127.0.0.1 localhost

      # special IPv6 addresses
      ::1 localhost ipv6-localhost ipv6-loopback

      fe00::0 ipv6-localnet

      ff00::0 ipv6-mcastprefix
      ff02::1 ipv6-allnodes
      ff02::2 ipv6-allrouters
      ff02::3 ipv6-allhosts
      172.27.4.42 brqb042x.testdomain.net brqb042x

      Do you know what is wrong ?

      Thank you for any help
        • 1. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
          Helios-GunesEROL
          Hi;

          For your issue i suggest close your thread here as changing thread status to answered and move it to Forum Home » Database » Application Express which is XE dedicated forum site.

          Regard
          Helios
          • 2. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
            Udo
            Hello Helios,
            For your issue i suggest close your thread here as changing thread status to answered and move it to Forum Home » Database » Application Express which is XE dedicated forum site.
            I'm not sure if you were aware that this IS the forum dedicated to XE, which the APEX forum is NOT.

            -Udo
            • 3. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
              Udo
              Hello,

              the root cause for your issue to be the following error
              ORA-00845: MEMORY_TARGET not supported on this system
              This is probably due to the fact that your SLES isn't configured to support shared memory, at least not in the way Oracle Database needs it.
              See Step 7. in Dudes post: {thread:id=2301639} for details. Though this HowTo is based on Ubuntu, I guess there are similar means to configure your SLES.

              -Udo
              • 4. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
                926656
                Hello

                Thank you for your prompt reply. I have changed the script "oracle-shm" for SLES purposes and after reboot I got another error messages.
                I suppose SLES 10 SP2 is supported system for oracle 11g ... Do you think that these steps are necessary for the correct configuration ?

                mount
                /dev/mapper/vgSystem-lvRoot on / type ext3 (rw,acl,user_xattr)
                proc on /proc type proc (rw)
                sysfs on /sys type sysfs (rw)
                debugfs on /sys/kernel/debug type debugfs (rw)
                udev on /dev type tmpfs (rw)
                devpts on /dev/pts type devpts (rw,mode=0620,gid=5)
                /dev/sda1 on /boot type ext3 (rw,acl,user_xattr)
                /run/shm on /dev/shm type none (rw,bind)


                cloneDBCreation.log
                Create controlfile reuse set database "XE"
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0


                BEGIN dbms_backup_restore.zerodbid(0); END;

                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0


                ORA-01034: ORACLE not available
                ORA-27101: shared memory realm does not exist
                Linux-x86_64 Error: 2: No such file or directory
                ORA-00600: internal error code, arguments: [SKGMHASH], [1], [18446744072646661188], [0], [0], [], [], [], [], [], [], []
                Create controlfile reuse set database "XE"
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0


                alter system enable restricted session
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0


                alter database "XE" open resetlogs
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0

                CloneRmanRestore.log

                ORA-00600: internal error code, arguments: [SKGMHASH], [1], [18446744072646661188], [0], [0], [], [], [], [], [], [], []
                select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0


                declare
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0


                select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0




                begin
                *
                ERROR at line 1:
                ORA-01034: ORACLE not available
                Process ID: 0
                Session ID: 0 Serial number: 0

                postDBCreation.log

                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-00600: internal error code, arguments: [SKGMHASH], [1], [18446744072646661188], [0], [0], [], [], [], [], [], [], []
                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
                • 5. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
                  Udo
                  Hello,
                  I have changed the script "oracle-shm" for SLES purposes and after reboot I got another error messages.
                  ORA-27101: shared memory realm does not exist
                  This error usually has two reasons:
                  1) ORACLE_HOME and/or ORACLE_SID aren't set as expected
                  2) Your shared memory configuration has some error.

                  So, let's start the analysis... For 1) please run
                  env | grep ORACLE
                  and see if you get the following values (or none if you've uninstalled already)
                  ORACLE_SID=XE
                  ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
                  For 2) we have
                  sysctl -p |grep kernel
                  df -k /dev/shm
                  The first one should verify that you have enough shared memory in your kernel parameters to serve your memory_target parameter. (Which value did you enter for that parameter, anyway?) You can also verify if the semaphore parameters ( sem ) have been setup as required.
                  The second one should verify that this amount of shared memory is actually available on the mounted device using the right filesystem-type ( tmpfs ).
                  I suppose SLES 10 SP2 is supported system for oracle 11g
                  It is, but this doesn't mean that the installer checks every setting for every parameter needed. Some things, e.g. configuring your kernel parameters, are [url http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#BABJFAIA]part of the Installation Guide

                  -Udo
                  • 6. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
                    926656
                    Hello

                    The problem has been solved, it is quite simple ..

                    mount -t tmpfs shmfs -o size=2048m /dev/shm

                    Many thanks for your effort
                    Best regards
                    • 7. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
                      Udo
                      The problem has been solved, it is quite simple ..
                      Great to hear you've got it working now!

                      Thanks for marking this thread as answered. Please also mark any helpful or correct answer accordingly, so other users searching for a similar issue can spot relevant posts easily.

                      Thanks again!

                      -Udo
                      • 8. Re: Oracle database express edition 11g release 2 on SLES 10 SP2
                        969973
                        Me sirvió de mucho.

                        Gracias por el aporte