Weblog

Oracle XE installation on Debian

I just tried installing Oracle Express Edition on Debian 3.1, but without much luck. I guess this really is a beta release.

The linux version is currently distributed as an rpm file, so i converted it to a deb file using alien:

alien -d --test  -c --verbose oracle-xe-10.2.0.1-0.1.i386.rpm

Next I installed the deb file using apt-get, this worked without problems:

debian:/etc# apt-get install oracle-xe
Reading Package Lists... Done
Building Dependency Tree... Done
The following NEW packages will be installed:
  oracle-xe
0 upgraded, 1 newly installed, 0 to remove and 6 not upgraded.
Need to get 0B/198MB of archives.
After unpacking 384MB of additional disk space will be used.
(Reading database ... 13700 files and directories currently installed.)
Unpacking oracle-xe (from .../oracle-xe_10.2.0.1-1.1_i386.deb) ...
Setting up oracle-xe (10.2.0.1-1.1) ...
Executing Post-install steps..........

You must run '/etc/init.d/oracle-xe configure' as root user to
configure the database.

So far, so good. But this is where the problems start. I tried running the oracle-xe script as indicated in the apt-get output:

debian:/etc/init.d# /etc/init.d/oracle-xe configure
/etc/init.d/oracle-xe: line 16: /etc/init.d/functions: No such file or directory
/etc/init.d/oracle-xe: line 99: init_status: command not found
...
...
Configuring Database...
/etc/init.d/oracle-xe: line 131: /etc/sysconfig/oracle-xe-config: No such file or directory
Starting Oracle Net Listener.
/etc/init.d/oracle-xe: line 493: /sbin/chkconfig: No such file or directory
You need to configure Oracle Database 10g Express Edition before you can start it.

So now i’m pretty much stuck. Anybody know how to solve this, or is this release just too beta?

Update:
This article is really outdated. There’s nothing easier than installing the production version of Oracle XE on Debian. You can apt-get install the database, no sweat.

Share and Enjoy:
  • del.icio.us
  • Google Bookmarks
  • DZone
  • LinkedIn
  • SphereIt
  • StumbleUpon
  • Technorati

31 Responses to “Oracle XE installation on Debian”

  1. Robert Pang Says:

    Which Debian distribution did you try? Pure Debian or one of its derivatives?

  2. Robert Pang Says:

    I believe it will be the best if you will post your help request on OTN forum for XE once it opens up (really soon).

  3. akoelewijn Says:

    I used the plain debian. I started with the i386 businesscard iso, and installed the rest through ftp.

  4. Sergio Says:

    Here’s the forum Robert mentioned earlier (registration required)

    http://forums.oracle.com/forums/forum.jspa?forumID=251&start=0

    There’s a thread about the install failing on Debian. mtownsen, the product manager, says:

    “Installing the RPM version on Debian will not work. We are in the process of producing a full .deb file for install on Debian. We will post this as soon as it is ready. Thanks for the feedback”

    Sergio

  5. akoelewijn Says:

    Ok, i’ll try debian later when the debs are released. In the meanwhile i’ve installed it on CentOS 4.2, without problems.

  6. akoelewijn Says:

    According to Amedee in this thread on OTN: http://forums.oracle.com/forums/thread.jspa?threadID=337067&tstart=0, installation on debian 3.1 should work if you install libaio.

  7. matelot Says:

    geesh….for the love of God why can’t you just follow the requirements ?

  8. akoelewijn Says:

    You’re right, the requirement for libaio is in the documentation. But the error messages don’t really help, they don’t indicate that libaio is missing. But that’s alright, it’s still a beta.

  9. isegrimm Says:

    note for (k)ubuntu: you should use libaio1 instead of libaio. if you want a clean install (and uninstall…), it’s better to wait for a real .deb package. i’m pretty sure you’ll not have to wait for a long time any more :)

  10. Ago Says:

    Does anybody use Oracle 10g Express with SELinux enabled CentOS4.2?
    It hangs at the startup but continues to load if I hit enter.

  11. akoelewijn Says:

    No, i disabled SELinux on installation of CentOS.

  12. ansris Says:

    i have an installation problem on knoppix. Please, help me at ansrisREMOVE_THIS@yahoo.it

  13. jon Says:

    http://www.guruwired.com/blog

    instructions to install xe on debian

  14. Antti Andreimann Says:

    Here is a small patch for the blody init script that will make it play nice on Debian.

    http://www.linux.ee/~anttix/oracle-xe-startupscript.diff

    Also sometimes alien manages to create a package that will install itself
    without running the install scripts.
    Just check if You can see this message:

    Executing Post-install steps……….

    If not, extract the scripts by hand:

    rpm -q –scripts -p oracle…..rpm > scripts.txt

    Cut them out (there are 4 of them, just search for “scriptlet” to find them).
    Replace all occourences of df -k with df -Pk
    (one possible cause of failure is that when You use LVM and volumes have long names df will output two lines per filesystem and preinst script will not be able to parse it).
    Then run preinst script and postinst script.

    Make sure to install libaio (the package from debian unstable works OK) and run /etc/init.d/oracle-xe configure

    Oh, and if someone would be nice and copy-paste this information to Oracle 10g XE forum for oracle developers to chew I’d appriciate it since the registration doesn’t work for me for some unknown reason (I guess that’s because I don’t use IE or something). Especially the link for startup script patch because I made an effort to tweak it to be as generic as I possibly can.

  15. PmmR Says:

    Greetings from Asuncion, Paraguay…
    I’m trying to install Oracle XE on my Debian 3.1 box but i haven’t much luck… I followed instructions posted on “www.guruwired.com/blog” and it hanged when “/etc/init.d/oracle-xe configure” ran… I check for log file in “$ORACLE_HOME/config/log” and no log file was created, executing “netstat -lpn” I noted that the listener (tnslsnr) run on port 1521 but not yet htmldb on port 8080… I try changing values for “sga_target” and “pga_aggregate_target” from 0M to 256M, I don’t know what format must take this values within the files “init.ora” and “initXETemp.ora”, maybe that I set wrong… another doubt, I used a .deb maked with “alien” on a Debian Woody 3.0 version, this can cause any problem with the installation? I noted too that the directory “/usr/lib/oracle/xe/oradata” wasn’t created during the installation or this directory are created when I run satisfactorily “/etc/init.d/oracle-xe configure”?
    Thanks to anyone for any help..

  16. Antti Andreimann Says:

    Do You have libaio installed?
    If yes, edit /etc/init.d/oracle-xe and remove redirection to /dev/null to see error messages.
    Oh, and did You comment out the rm seeddb line?

  17. Antti Andreimann Says:

    I’ve posted instructions how to build a decent .deb to:

    http://www.guruwired.com/blog/?p=16#comments

  18. PmmR Says:

    Yes, I have libaio_0.3.104-1_i386.deb installed… I commented out line 205 in “/etc/init.d/oracle-xe”, I commented out too all “/dev/nul” lines on “/etc/init.d/oracle-xe” then I have displayed what doing the script like you recommended to me… I found multiple “Permission denied” messages now that I can see messages while running “/etc/init.d/oracle-xe configure”, I chown the oracle-xe script to “oraclexe:dba” and I tried again “/etc/init.d/oracle-xe configure” and now it finished well… Now I’ll make symlinks to /etc/rcX.d to try to start automatically when system startup… Many thanks to you…

  19. Steffen Says:

    For the Xpress I did the following:

    1. apt-get install rpm alien libaio
    2. alien -s –-test –-verbose -c oracle-xe-10.2.0.1-0.1.i386.rpm
    3. cd cd oracle-xe-10.2.0.1
    4. wget http://www.linux.ee/~anttix/oracle-xe-startupscript.diff
    5. cat oracle-xe-startupscript.diff | patch -p1
    6. dpkg-buildbackage
    7. cd ..
    8. dpkg -i oracle-xe_10.2.0.1-1.1_i386.deb
    9. /etc/init.d/oracle-xe configure

    … but the link above (two posts higher) is the on eI used as well.

    For the Enterprise Installation check http://www.gutermann.net/debian-linux/installation-von-oracle-auf-debian-linux-sarge-sid-remote/

  20. Joel Becker Says:

    Add this to your sources.list and update:

    deb http://oss.oracle.com/debian/ unstable main non-free

    We’ve got libaio there as well for folks using stable.

    Joel Becker

  21. Homo-Adminus Says:

    This article is not actual now. From now you can use http://oss.oracle.com/debian repository for quick and safe Oracle XE installation.
    http://blog.kovyrin.net/2006/03/07/how-to-install-oracle-xe-on-debian-sarge/ – this is article about how to do it.

  22. carlos m. Says:

    i think this is not the right place for my question but anyway i see some posts about centos. I’m trying to install xe on centos 4.2 and i’m stucked with this error:
    [root@localhost RPMS]# rpm -ivh /root/oracle-xe-10.2.0.1-0.1.i386.rpm
    error: Failed dependencies:
    libaio >= 0.3.96 is needed by oracle-xe-10.2.0.1-0.1.i386
    Suggested resolutions:
    libaio-0.3.103-3.i386.rpm

    the package already installed is libao-0.8.5-2.EL.0… so i dont know what to do… maybe is linux newbie question , but should i erase the newer one and install the older?
    thanks in advance.

  23. Andrej Koelewijn Says:

    libao and libaio are two different libraries. libao is an audio library and libaio is a library for asynchronous i/o. You’ll need to install libaio as suggested.

  24. carlos m. Says:

    thanks a lot , i’m sorry i didn’t notice that ‘ i ‘ :S (i’ve been practicing fast reading ). I succesfuly installed libaio-0.3.103-3.i386.rpm it comes in the cenOS cd 3 , but now i got another problem:

    [root@localhost ~]# rpm -ivh /root/oracle-xe-10.2.0.1-0.1.i386.rpm
    Preparing… ########################################### [100%]
    Oracle Database 10g Express Edition requires a minimum of 256 MB of physical
    memory (RAM). This system has 249 MB of RAM and does not meet minimum
    requirements.
    error: %pre(oracle-xe-10.2.0.1-0.1.i386) scriptlet failed, exit status 1
    error: install: %pre scriptlet failed (2), skipping oracle-xe-10.2.0.1-0.1

    I guess my video card take that 7m so i cant pass that check , is there anyway to fool the installer ? ( i got no plans to buy more RIMM memory) , i have 9i and XE on the same machine and i didn’t get that error…

    thanks in advance.

  25. carlos m. Says:

    In the last line of the previos post i forgot to mention the another OS installed in the machine is windows XP

  26. carlos mafla Says:

    I found the way:

    [root@localhost ~]# rpm -Uvh –force –nopre /root/oracle-xe-10.2.0.1-0.1.i386.rpm
    Preparing… ########################################### [100%]
    1:oracle-xe ########################################### [100%]
    Executing Post-install steps……….
    You must run ‘/etc/init.d/oracle-xe configure’ as root user to
    configure the database.

  27. Fat Says:

    Hi.. can you give me exact steps to install libaio? I have downloaded the tar file but cant seems to install it

  28. vaarsha Says:

    I want to down load oracle Xe software.

  29. varsha Says:

    I want to downloade Oracle Xesoftware

  30. mike Says:

    run
    sudo ./ /etc/init.d/oracle-xe configure

    icurtain

  31. мepтвeц Says:

    Опять-таки достаточно побочная проблема. Вряд ли она кому-нибудь мешает, мне вот лично как то пофигу :)

Leave a Reply

Technology