<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=utf-8">
<TITLE></TITLE>
<META NAME="GENERATOR" CONTENT="OpenOffice.org 1.9.79 (Linux)">
<META NAME="AUTHOR" CONTENT="Gaurav p">
<META NAME="CREATED" CONTENT="20050331;16025400">
<META NAME="CHANGEDBY" CONTENT="Gaurav p">
<META NAME="CHANGED" CONTENT="20050401;15384300">
<STYLE>
<!--
@page { size: 8.5in 11in; margin-left: 1.25in; margin-right: 1.25in; margin-top: 1in; margin-bottom: 1in }
P { margin-bottom: 0.08in }
H1.western { font-family: "Bitstream Vera Serif", serif }
H1.cjk { font-family: "Bitstream Vera Sans" }
H1.ctl { font-family: "Lucidasans" }
H2.western { font-family: "Bitstream Vera Sans", sans-serif; font-size: 14pt; font-style: italic }
H2.cjk { font-family: "Mincho"; font-size: 14pt; font-style: italic }
H2.ctl { font-size: 14pt; font-style: italic }
-->
</STYLE>
</HEAD>
<BODY LANG="en-US" DIR="LTR">
<H1 CLASS="western">Oracle 9i under Fedora Core 3 - Installation How
to
</H1>
<PRE><FONT SIZE=3 STYLE="font-size: 13pt">Gaurav </FONT>
<A HREF="mailto:gauravpd@gmail.com">gauravpd@gmail.com</A></PRE><P STYLE="margin-bottom: 0.2in">
v1.0-pre1, <SDFIELD TYPE=DATETIME SDVAL="38443.4846527778" SDNUM="1033;1033;MMMM D, YYYY">April 1, 2005</SDFIELD>
</P>
<HR>
<P STYLE="margin-bottom: 0in">This tutorial describes how to install
Oracle 9i on Fedora Core 3 (or greater)
</P>
<HR>
<H2 CLASS="western"></H2>
<PRE STYLE="margin-bottom: 0.2in; page-break-after: avoid"></PRE>
<DIV ID="Table of Contents1" DIR="LTR">
<DIV ID="Table of Contents1_Head" DIR="LTR">
<P STYLE="margin-top: 0.17in; margin-bottom: 0.2in; background: transparent; line-height: 200%; page-break-before: auto; page-break-after: avoid">
<FONT FACE="Bitstream Vera Sans, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><B><SPAN STYLE="float: left; font-size: 300%">T</SPAN>able
of Contents</B></FONT></FONT></P>
</DIV>
<P STYLE="margin-bottom: 0in">Oracle 9i under Fedora Core 3 -
Installation How to 1</P>
<P STYLE="margin-bottom: 0in">1. Introduction 2</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">1.1
Acknowledgments 3</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">1.2 Revision
History 3</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">1.3 New versions
of this document 3</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">1.4 Feedback 3</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">1.5 Distribution
Policy 3</P>
<P STYLE="margin-bottom: 0in">2. Get Oracle 9i 5</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">2.1 CD
Installation 5</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">2.2 Download 5</P>
<P STYLE="margin-bottom: 0in">3. Create users and Directories 5</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">3.1 Create users
and groups 5</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">3.2 Create the
directories 5</P>
<P STYLE="margin-bottom: 0in">4. Set Environmental variables 6</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">4.1 Edit
.bash_profile 6</P>
<P STYLE="margin-bottom: 0in">5. Set Kernel Parameters 7</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">5.1 Edit
/etc/sysctl.conf 7</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">5.2 Edit
/etc/security/limits.conf 7</P>
<P STYLE="margin-bottom: 0in">6. Install GCC 2.9 Compat libraries 7</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">6.1 Install GCC
2.96 Compat packages 7</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">6.2 Create
symbolic links 8</P>
<P STYLE="margin-bottom: 0in">7. Run Installer 8</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">7.1 Apply
libwait.c patch 8</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">7.2 Export Display
variable 9</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">7.3 Finally Run
the Installation 9</P>
<P STYLE="margin-left: 0.2in; margin-bottom: 0in">7.4 Fix
nodeinfo 9</P>
<P STYLE="margin-bottom: 0in">7. Startup script 10</P>
<P STYLE="margin-bottom: 0in">Miscellaneous Errors 11</P>
</DIV>
<P STYLE="margin-top: 0.17in"><BR><BR>
</P>
<H2 CLASS="western"></H2>
<H1 CLASS="western"><FONT SIZE=5>1. Introduction</FONT></H1>
<P>This tutorial was written due to my frustration on installing
Oracle 9i on FC3. Basically 9i installation on RAS 1,2,3 RH 9, fc1,
fc 2 is documented fairly well but its hard to find anything worth
while on FC3 , some people even suggested installing Oracle 9i on FC3
is not possible !! . This How to attempts to condense all my
experience /findings with any such info peculiar to FC3 which
scattered all over web in to one concise but useful Doc.</P>
<P>I hope you might find this short tutorial useful</P>
<P>If you need to install Oracle 9i on FC3 than you must know/ look
at following fact</P>
<UL>
<LI><P>Fedora is not *Officially Supported* by Oracle Corp</P>
<LI><P>Oracle 9i installation is difficult but <B>possible </B>in
FC3</P>
<LI><P>Oracle 9i CANNOT be linked with the libraries used by gcc 3.4
Under FC3, you need to use, (its only possible thru Fc2 compat
library)
</P>
<LI><P>Oracle 10 G installation method does NOT WORKS with 9i</P>
<LI><P>This How to deals with Red hat products >= f3 or higher or
gcc version greater than 2.9 other wise if you are installing any
other Redhat product you might want look at other exellent tutorials
at (<A HREF="http://www.puschitz.com/OracleOnLinux.shtml">http://www.puschitz.com/OracleOnLinux.shtml</A>
, <A HREF="http://oracle-base.com/">http://oracle-base.com/</A> )</P>
</UL>
<P>also
</P>
<UL>
<LI><P>This howto is aim to assist you only ...there is NOTHING
OFFICIAL about !! so i am not responsible if
</P>
<LI><P>I am not a DBA ..so do not mail me Help pl!! types mail (a
better place would be Oracle forums ) , but any suggestion or
improvement in How to is appreciated
</P>
<LI><P>Next probable step for me is to write some bash or Perl
scripts to fully automate this tideous and boring , frustrating,
manual process but that depends on spare time I get , your inputs
are welcome :-)</P>
</UL>
<H2 CLASS="western"><A NAME="ss1.1"></A>1.1 Acknowledgments</H2>
<P>I would like to thank Jean Francois for helping me out on most
tricky part</P>
<H2 CLASS="western"><A NAME="ss1.2"></A>1.2 Revision History
</H2>
<P>Version 1.0-pre1 – March 25, 2005.
</P>
<P>Version 1.1 -April 1,2005 added miscellaneous errors section</P>
<P><BR><BR>
</P>
<H2 CLASS="western" STYLE="margin-top: 0in"><A NAME="ss1.3"></A>1.3
New versions of this document
</H2>
<P>The latest version can be found at
<A HREF="http://www.alsa-project.org/%7Evalentyn">http://www.pagux.com/oracle9ionfedora3.html</A></P>
<PRE STYLE="margin-bottom: 0.2in"></PRE><H2 CLASS="western" STYLE="margin-top: 0in">
<A NAME="ss1.4"></A>1.4 Feedback
</H2>
<P>I rely on you, the reader, to make this HOWTO useful. If you have
any suggestions, corrections or comments, please send them to me (
<A HREF="mailto:alsa-howto@alsa-project.org">gauravpd@gmail.com</A>),
and I will try to incorporate them in the next revision.
</P>
<PRE STYLE="margin-bottom: 0.2in"></PRE><H2 CLASS="western" STYLE="margin-top: 0in">
<A NAME="ss1.5"></A>1.5 Distribution Policy
</H2>
<P>Copyright 2005/2006 Gaurav Prasad</P>
<P>This HOWTO is free documentation; you can redistribute it and/or
modify it under the terms of the GNU General Public License as
published by the Free Software Foundation; either version 2 of the
License, or (at your option) any later version.
</P>
<P>This document is distributed in the hope that it will be useful,
but <B>without any warranty</B>; without even the implied warranty of
<B>merchantability</B> or <B>fitness for a particular purpose</B>.
See the GNU General Public License for more details.
</P>
<P>You can obtain a copy of the GNU General Public License by writing
to the <A HREF="http://www.fsf.org/">Free Software Foundation</A>,
Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
</P>
<PRE STYLE="margin-bottom: 0.2in"></PRE><P STYLE="margin-top: 0.17in">
<BR><BR>
</P>
<P STYLE="margin-top: 0.17in; page-break-before: always"><BR><BR>
</P>
<H1 CLASS="western"><FONT SIZE=5>2. Get Oracle 9i </FONT>
</H1>
<H2 CLASS="western">2.1 CD Installation</H2>
<UL>
<LI><P>If you got Oracle 9i CD then mount it
</P>
<LI><P>mkisofs -r -o ora9id1.iso Disk1/,loop=/dev/loop0 cd_image
mount_dir</P>
</UL>
<H2 CLASS="western">2.2 Download</H2>
<UL>
<LI><P>Otherwise download it from
</P>
<LI><P>otn.<B>oracle</B>.com/software/products/
<B>oracle9i</B>/htdocs/<B>linux</B>soft.html ( You will need to
following)</P>
<LI><P>Extract all three files as
</P>
<LI><P>gunzip ship_9204_linux_disk1.cpio</P>
<LI><P>cpio -idmv -I ship_9204_linux_disk1.cpio (Dont forget -I
option other wise it give error during extraction )</P>
<LI><P>This will expand to folder Disk1 (Repeat the process other
two files)</P>
</UL>
<P STYLE="margin-left: 1.58in"><BR><BR>
</P>
<H1 CLASS="western"><FONT SIZE=5>3. Create users and Directories </FONT>
</H1>
<H2 CLASS="western">3.1 Create users and groups</H2>
<PRE STYLE="margin-left: 1.58in">groupadd oinstall
groupadd dba
groupadd oper
groupadd apache
useradd -g oinstall -G dba oracle
passwd oracle</PRE><H2 CLASS="western">
3.2 Create the directories
</H2>
<P STYLE="margin-left: 0.49in">in which the Oracle software will be
installed:</P>
<PRE STYLE="margin-left: 1.58in; margin-right: 0.39in"><CODE><B>mkdir /u01 /u02</B></CODE>
<CODE><B>chown oracle.dba /u01 /u02</B></CODE>
<CODE><B>chmod 755 /u01 /u02</B></CODE></PRE><P STYLE="margin-bottom: 0in">
<BR>
</P>
<H1 CLASS="western"><FONT SIZE=5>4. Set Environmental variables </FONT>
</H1>
<H2 CLASS="western">4.1 Edit .bash_profile</H2>
<UL>
<LI><P>Log as oracle user</P>
<LI><P>su – oracle</P>
<LI><P>Edit .bash_profile</P>
<LI><P>vim .bash_profile add following</P>
</UL>
<PRE STYLE="margin-left: 1.58in">############################################################################
############################ Oracle Variables######################################
echo " Wel come to oracle";
ORACLE_BASE=/u01/app/oracle
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_HOME=/u01/app/oracle/product/9.2.0.1.0
ORACLE_SID=ORTD
LD_PRELOAD=$HOME/libcwait.so
export DISPLAY=172.28.66.39:0.0
PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
THREADS_FLAG=native; export THREADS_FLAG
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH LD_PRELOAD
###############################Oracle##################################</PRE><H1 CLASS="western">
<FONT SIZE=5>5. Set Kernel Parameters </FONT>
</H1>
<H2 CLASS="western">5.1 Edit /etc/sysctl.conf</H2>
<UL>
<LI><P>Add following lines can be added to the /etc/sysctl.conf
file:</P>
</UL>
<PRE STYLE="margin-left: 0.79in; margin-right: 0.39in">kernel.shmmax = 2147483648
kernel.shmmni = 128
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000</PRE><H2 CLASS="western">
5.2 Edit /etc/security/limits.conf</H2>
<UL>
<LI><P>In addition the following lines can be added to the
/etc/security/limits.conf file:</P>
</UL>
<PRE STYLE="margin-left: 0.79in; margin-right: 0.39in">oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384</PRE>
<UL>
<LI><P>Adding lines into these files requires a reboot before they
take effect.</P>
</UL>
<H1 CLASS="western"><FONT SIZE=5>6. Install GCC 2.9 Compat libraries</FONT></H1>
<H2 CLASS="western">6.1 Install GCC 2.96 Compat packages
</H2>
<UL>
<LI><P>From Fedora Core TWO (note if newer FC3 packages are
installed use rpm -i –force )</P>
</UL>
<PRE STYLE="margin-left: 0.49in">compat-libstdc++-7.3-2.96
compat-libstdc++-devel-7.3-2.96
compat-gcc-7.3-2.96.118.i386.rpm
compat-gcc-c++-7.3-2.96</PRE>
<UL>
<LI><P>From Fedora Core THREE</P>
</UL>
<PRE STYLE="margin-left: 1.58in; margin-bottom: 0.2in">compat-db</PRE>
<UL>
<LI><P>If don't install GCC compat libraries as above you get
zillion linking error</P>
</UL>
<H2 CLASS="western">6.2 Create symbolic links
</H2>
<UL>
<LI><P STYLE="margin-bottom: 0in">Put gcc296 and g++296 first in
$PATH variable by creating the following symbolic links:</P>
</UL>
<PRE STYLE="margin-left: 0.39in; margin-right: 0.39in">mv /usr/bin/gcc /usr/bin/gcc323
mv /usr/bin/g++ /usr/bin/g++323
ln -s /usr/bin/gcc296 /usr/bin/gcc
ln -s /usr/bin/g++296 /usr/bin/g++</PRE>
<UL>
<P></P>
</UL>
<H1 CLASS="western"><FONT SIZE=5>7. Run Installer </FONT>
</H1>
<H2 CLASS="western">7.1 Apply libwait.c patch
</H2>
<UL>
<LI><P>Before you run installer you do following to over come some
weird errors</P>
<LI><P>Complie libwait.c (in /home/oracle)</P>
<LI><P>Save this as libcwait.c and do as explained in the
comment:<BR><BR>/* Compile with<BR><BR>gcc -shared -o libcwait.so
libcwait.c -fpic -O<BR><BR>and use it by adding</P>
<P><BR>LD_PRELOAD=/path/to/libcwait.so<BR><BR>in the environment of
the application with the bug.<BR><BR>*/<BR>#include
<errno.h><BR>#include <sys/syscall.h><BR>#include
<sys/types.h><BR>#include <sys/wait.h><BR>pid_t<BR>__libc_wait
(int *status)<BR>{<BR>int res;<BR>asm volatile ("pushl
%%ebx\n\t"<BR>"movl %2, %%ebx\n\t"<BR>"movl %1,
%%eax\n\t"<BR>"int $0x80\n\t"<BR>"popl %%ebx"<BR>:
"=a" (res)<BR>: "i" (__NR_wait4), "0"
(WAIT_ANY), "c" (status), "d" (0),<BR>"S"
(0));<BR>return res;<BR>}<BR><BR><BR>
</P>
<LI><P>Compile gcc -shared -o libcwait.so libcwait.c -fpic -O</P>
<LI><P>Then do <BR>export LD_PRELOAD=/home/oracle/libcwait.so</P>
</UL>
<H2 CLASS="western">7.2 Export Display variable</H2>
<UL>
<LI><P><CODE>xhost +localhost<BR>export DISPLAY=localhost:0.0</CODE></P>
<LI><P><CODE>if above doest work take vnc connection to server and
run installation (su – oracle and the vncserver to start
vncserver)</CODE></P>
</UL>
<H2 CLASS="western"><CODE><B>7.3 Finally Run the Installation</B></CODE></H2>
<UL>
<LI><P>/path/to/oracle/Disk1/runInstaller
</P>
<LI><P>Now carry with Graphical setup (if you are not sure choose
Standard database )...from here its really easy</P>
</UL>
<H2 CLASS="western">7.4 Fix nodeinfo</H2>
<UL>
<LI><P>Now installation should proceed without any linking errors
but you will get one error in end</P>
</UL>
<PRE STYLE="margin-left: 2.36in"> Parameter "nodeinfo" = NO_VALUE
Agent Service Failed</PRE>
<UL>
<LI><P>For do this after setup
</P>
<LI><PRE STYLE="margin-bottom: 0.2in">netca & (this run wizard)</PRE>
<LI><P>cd $ORACLE_HOME and run ./lsnrctl start
</P>
<LI><PRE STYLE="margin-bottom: 0.2in"> check if its running $ ps afx | grep LISTEN | grep -v grep</PRE>
</UL>
<H1 CLASS="western"><FONT SIZE=5>7. Startup script</FONT></H1>
<UL>
<LI><P>You have to write startup a script so that oracle can
automatically be started as reboot and easily control service using
service command
</P>
<LI><P>create a start up a start script as following</P>
<LI><P>vim /etc/init.d/oracle</P>
<LI><P>add following to it
</P>
</UL>
<PRE STYLE="margin-left: 1.58in">#!/bin/bash
#
# Run-level Startup script for the Oracle Instance and Listener
#
# chkconfig: 345 91 19
# description: Startup/Shutdown Oracle listener and instance
ORA_HOME="/u01/app/oracle/product/9.2.0.1.0"
ORA_OWNR="oracle"
# if the executables do not exist -- display error
if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi
# depending on parameter -- startup, shutdown, restart
# of the instance and listener or usage display
case "$1" in
start)
# Setting up kernel parameters
#echo 100 32000 100 100 > /proc/sys/kernel/sem
#echo 2147483648 > /proc/sys/kernel/shmmax
#echo 4096 > /proc/sys/kernel/shmmni
#echo 2097152 > /proc/sys/kernel/shmall
#echo 65536 > /proc/sys/fs/file-max
#ulimit -n 65536
#echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
#ulimit -u 16384
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNR -c $ORA_HOME/bin/dbstart
touch /var/lock/subsys/oracle
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNR -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/oracle
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: $0 start|stop|restart|reload"
exit 1
esac
exit 0</PRE>
<UL>
<LI><P>Now run command chkconfig oracle (this will create init
scripts)</P>
<LI><P>now service oracle start|stop|restart should work
</P>
</UL>
<H1 CLASS="western"><FONT SIZE=4 STYLE="font-size: 16pt">Miscellaneous
Errors</FONT>
</H1>
<P STYLE="margin-left: 0.49in"><B><FONT SIZE=2>ERROR: <BR>ORA-01034:
ORACLE not available <BR>ORA-27101: shared memory realm does not
exist <BR>Linux Error: 2: No such file or directory </FONT></B><BR><BR>This
error happens when you reboot and try to login ... you will get lot
of errors as database instance is not mounted/started automatically
<BR><B>Step 1</B> <BR>In /etc/oratab If you have:
<BR>*:/opt/oracle/OraHome1:N <BR>ordb:/opt/oracle/OraHome1:N <BR><BR>edit
it to *:/opt/oracle/OraHome1:Y <BR>ordb:/opt/oracle/OraHome1:Y
<BR><BR>here N means No and Y means Yes ....so you basically asking
database to start automatically when you reboot or stop service <BR><B>Step
2 </B><BR>after that try to initialize database
<BR>$ORACLE_HOME/bin/dbstart <BR><BR>if you get error <BR><BR><B><FONT SIZE=2>No
start entry for SID * at /opt/oracle/OraHome1 in /etc/oratab</FONT></B>
<BR><BR>this might be due a bug in dbstart script looking at sid file
wrong place <BR>then -> <BR>cp
$ORACLE_BASE/admin/$ORACLE_SID/pfile/init_*.ora
<BR>$ORACLE_HOME/dbs/init$ORACLE_SID.ora <BR><BR>and <BR>$ sqlplus '/
as sysdba' <BR>SQL> create pfile from spfile; <BR>SQL> exit
<BR>run the db start script <BR>$ORACLE_HOME/bin/dbstart <BR><BR><BR><BR><BR>
</P>
<P STYLE="margin-left: 1.58in"><CODE><B>if you reached this state
with any errors the Congrats !! Relax :-) ...Go have a cup of coffee
or call your girl friend </B></CODE>
</P>
<P><BR><BR>
</P>
<UL>
<P><BR><BR><BR>
</P>
</UL>
<P STYLE="margin-left: 1.58in"><BR><BR>
</P>
<P STYLE="margin-left: 1.58in"><BR><BR>
</P>
<P><BR><BR>
</P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
</BODY>
</HTML>