Oracle OEM Console Setup on Ubuntu

There are many tools for managing Oracle instances. Oracle themselves want you to use their Grid Control, which is a good tool, but... none of them are easier to use for quickly gaining access to multiple instances to make small changes that the original Java Oracle Enterprise Manager (which they stopped supplying with releases from 11g onward).

Installing the 10g admin client under Windows is easy, but I had to look up how to do it under Ubuntu Linux, so I've documented it here.

Download the Oracle Database 10g Client Release 2 (10.2.0.1.0) for Linux x86 zip file from oracle.com and unzip it:

cp ~/Downloads/10201_client_linux32.zip ~/tmp
cd ~/tmp
unzip 10201_client_linux32.zip
cd client
./runInstaller -ignoreSysPrereqs

you can ignore the linking error that happens arount 88%

to run the root commands it prompts you to, type: sudo (and the command specified)

edit ~/.bashrc to add the following lines:

export ORACLE_HOME=/home/roq/oracle/product/10.2.0/client_1
export PATH=$ORACLE_HOME/bin:$PATH

copy tnsnames.ora from backup to $ORACLE_HOME/network/admin

restart system

from a terminal, start the oem console:

oemapp console &

if you want to, add a launcher for the oemapp console and sqlplus

done!