If you install oracle10g enough times you are bound to run into the infamous libXp.so.6 error
java.lang.UnsatisfiedLinkError: /tmp/OraInstall2011-02-24_10-52-55PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
solving it is an easy task if you know what to do, just go to the dvd you installed the redhat from and search for libXp-1.0.0-8.1.el5.i386.rpm and install “rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm” and just for safe measure install “rpm -ivh libXpm-3.5.5-3.i386.rpm” as well.
this would instantly solve your libXp.so issue.
If you are running the oracle instance on a vm for say experimental reasons, you can always minimize its mem ory foot print by changing the sga max size and sga target, this can be done using the following command
alter system set sga_max_size =100M scope=spfile;
alter system set sga_target =100M scope = both;
and then restart your db