This discussion is archived
8 Replies Latest reply: Oct 22, 2012 11:05 AM by 969973 RSS

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

926656 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Me sirvió de mucho.

    Gracias por el aporte

Legend

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