So you’ve got Oracle 10G and you want to install it on your RedHat Enterprise 3 server. Well, since Oracle can’t manage to create tar files like everyone else in the world, you have to find a way of dealing with the .cpio they send you. Here’s how to get it extracted:
cpio -idmv < /path/to/ship-version.cpio
This extracts everything nicely into a Disk1 directory.
Now, before flying off and running the installer, you have a couple of things to do first. To start, you have to tweak your kernel a bit. There are a number of ways to do this, but I like to use the /etc/sysctl.conf file.
Edit /etc/sysctl.conf and add the following lines:
kernel.shmall = 134217728
kernel.shmmax = 2147483648
kernel.semopn = 100
semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
Next you have to add an oracle user and a dba group. Run the following commands as root:
groupadd dba
useradd -d /path/to/oracle/user/directory -g dba -c ‘Oracle User’ -s /path/to/fovorite/shell oracle
chown oracle:dba /path/to/oracle/user/directory
passwd oracle (set new password)
Add the following environmental settings to your oracle user’s .bashrc file. Feel free to change them if you are using a C-Type shell.
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.1.0/Db_1; export ORACLE_HOME
ORACLE_SID=YOUR_SID; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
That should just about do it. Restart the system, log in as the oracle user and run the oracle installer (/path/to/Disk1/runInstaller). Check to make sure that all the settings from your .bashrc file are picked up by the oracle installer and have fun.
In some cases, the installer may complain about not having the required packages. If it does this, make sure that the following packages are installed:
setarch-1.3-1.i386.rpm
openmotif-2.2.2-16.i386.rpm
compat-libstdc++-7.3-2.96.122.i386.rpm
compat-libstdc++-devel-7.3-2.96.122.i386.rpm
compat-db-4.0.14-5.i386.rpm
compat-gcc-7.3-2.96.122.i386.rpm
compat-gcc-c++-7.3-2.96.122.i386.rpm
[...] Here is a HOWTO for installing oracle on RedHat Enterprise 3. [...]
[...] How to Install Oracle 10g on RedHat Enterprise 3 – suggestion: skip the 80% of your documentation that Oracle took care of and just put in the part about setting the environment variables. If you want to be helpful to n00bs you should explain that you need to set ORACLE_BASE to whatever you installed to, not necessarily /u01/app/oracle. They’re going to cut-n-paste your stuff and wonder why it’s not working. The product is also “Red Hat” (two words) “Enterprise Linux 3.” You get a D. [...]
Dear lone sysadmin,
Have you ever installed Oracle? Ever read the documentation? This type of cliff-notes (pun intended) are exactly what you need to take the hour it took to read and digest the documentation the first time, and make it a quick 5 minute skim so you can get on your way.
People new to Oracle should sit down with the docs, learn to hate them, learn to love them, but after that have a shorter reference to go back to. That’s exactly what this post is about.
I’m sorry you’ve missed the point of this post, and from what I can see on your blog, many others like it. Somehow I am not surprised to find that “General Ramblings” is your biggest category, but perhaps you could focus some of your energies on providing some informational or at least entertaining content.
Rewriting documentation in boiled down easy step by steps is one of the great uses of blogs. Sure, these instructions may not tell you the *ideal* setup, but they may get someone around some serious roadblocks. If a “n00b” uses this copy and paste to get Oracle up and running, great! Now they can play with it, tweak it, and spend time understanding what they did and how it’s working.
If ignorance is bliss, the lone sysadmin is orgasmic.
For those of us that have installed on other platforms and just need a quick reference for Red Hat, this is great!