Ubuntu Howto: Install Oracle

Installing Oracle on Ubuntu is fairly easy, since Oracle has created a Debian and Ubuntu package repository, so it is possible to download and install the Oracle database softwareusing apt-get and aptitude.

Howto use the Oracle Debian and Ubuntu Repository:

Add the following lines to the /etc/apt/sources.list

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

Update the package repository database with:

cc@ray:~$ sudo apt-get update

Now you should be able to install the following Oracle software:

  • libaio
  • oracle-xe-client
  • oracle-xe
  • oracle-xe-universal

Install the Oracle Express packages

sudo aptitude install oracle-xe oracle-xe-client

Configure using:

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

Access the nice Oracle web interface by pointing your Firefox to:

http://127.0.0.1:8080/apex

 

Updated:
The installation process might report that the Oracle packages are not gpg signed, but you should be able to install the packages anyway.

You can avoid this report by added the Oracle gpg-public key to your apt-key chain

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -

Read more on Oracle and Debian and Ubuntu here

Comments off

Optimize MySQL for Low Memory Use

MySQL is a light database engine compared tomany of it’s rivals, but for some reason theDebian MySQL-server package contains a setup that makes it very heavy and memory consuming. The Debian version of becomes memory consuming because it comes with config file where MySQL’s most memory consuming and seldom used storage engine InnoDB is enable. As result of this the MySQL server instance uses around 100MB of memory while almost idle.

And here comes the optimization tip.

Since the InnoDB storage engine is used very seldom it can be disable in most cases and let the server save almost about 100MB of memory.

To disable to InnoDB storage engine add this to my.cnf (the default MySQLconfiguration files) in /etc/mysql/
skip-innodb

More on MySQL and Apache optimization and here

Comments off