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!