Old Oracle, New(ish) Linux

Ramblings / October 9, 2008 / John / 0

Okay, so as part of my amazing scheme to take a very old netapp, built around Oracle and PL/SQL and running on ancient end-of-life unsupportable SPARC hardware, and port it to low cost Linux boxen, I’ve finally gotten round to attempting to shoehorn Oracle9i and OAS onto our preferred linux – CentOS 4.6.

CentOS 4.6 is by no means bleeding edge, but it’s about as modern as I’m prepared to go with current non-debian systems. So, CentOS installed, 9i downloaded and unarchived, and off we go.

I’m not going to talk about installing and configuring Oracle because, frankly, if you don’t know you probably shouldn’t be installing it 🙂 Instead, I’m going to give you two commands which, when run, turn your installing-oracle adventure into a shiny easy thing, rather than the hideous nightmare it potentially can be. The main reason for the post is to help out all you guys getting the dreaded ‘can’t find GLIBC2.0’ errors that are thrown by the JVM.

Command One

yum install libaio libaio-devel openmotif21 compat-gcc-32 compat-gcc-32-c++ compat-libgcc-296 xorg-x11-deprecated-libs-devel compat-libstdc++-296

Next, you need to pop along to this page at oracle. Once there, download compat-libcwait, compat-libstdc++, compat-oracle-rhel4, libgcc32 and libstdc++32.

Command Two

rpm -i *.rpm

And that’s you done. That’s all the shinies you need. Next thing to do is add an Oracle user and the DBA group, create a destination directory somewhere with enough disk, then run the installer and pray. Remember to have a sane environment set before you run the installer. Something like the following should do it.

ORACLE_SID=myDbName

ORACLE_BASE=/u01/oracle

ORACLE_HOME=/u01/oracle/9.2.0

PATH=$ORACLE_HOME/bin:$PATH:.

LD_ASSUME_KERNEL=2.4.19

export ORACLE_SID ORACLE_BASE ORACLE_HOME PATH LD_ASSUME_KERNEL

 

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

export LD_LIBRARY_PATH

kernel.shmall=2097152

kernel.shmmax=2147483648

kernel.shmmni=4096

kernel.sem=250 32000 100 128

fs.file-max=65536

net.ipv4.ip_local_port_range=1024 65000

John

UNIX geek, wannabe cook, musician, book-lover, and all round good-guy.