Hi all,
this is my first post here. :D
I've just successfully installed on Ubuntu 10.04, Lucid Lynx, and wanted to share the steps that it took and summarize the information I gathered from plenty of Google searches and searches of this forum; maybe they are useful to someone else:
1. Increased swap (more information in English at https://help.ubuntu.com/community/SwapFaq and German at http://wiki.ubuntuusers.de/swap).
2. Installed Oracle Database 10g Express Edition as explained
here:
sudo apt-get install libaio1
sudo dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb
sudo /etc/init.d/oracle-xe configure
I answered the questions about the ports with the default answers (8080 and 1521) and "no" for starting the database on boot.
After that, I was able to access the database home page at http://127.0.0.1:8080/apex
3. After next reboot with my normal user account "carsten" I was not able to start the database and not able to access http://127.0.0.1:8080/apex
Following thread {message:id=4106998} that is linking to post http://ubuntuforums.org/showpost.php?p=7838671&postcount=4 in the Ubuntu forums, I also:
added myself to the
dba group,
sudo usermod -a -G dba carsten
made the listener log writable by the
dba group,
sudo chmod g+w /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
made sure the env vars are set for everyone,
sudo ln -s /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh /etc/profile.d/oracle_env.sh
changed *#!/bin/sh* to *#!/bin/bash* in nls_lang.sh,
sudo gedit /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh
and for being able to login as Ubuntu user "oracle" I set a password (this last step is optional, I needed to login as the "oracle" user for testing, but now it's no longer necessary).
sudo passwd oracle
-----
After the next reboot (not strictly required...), logging in again with my normal Ubuntu user "carsten", I can successfully start and stop the database via the gnome Applications menu and start the listener at the terminal with
lsnrctl start
When both the database and the listener are running, http://127.0.0.1:8080/apex can be accessed in a web browser. Installation complete! :x
This is also the first time that I use an Oracle DB, and I'd be happy about any thoughts or feed-back!
Best regards,
Carsten
http://www.cafu.de