Tuesday, January 1, 2008

Oracle 10g on Fedora Core 8


Yes, installing oracle 10g on fc8 is a pain. But there are two avenues on how to do it.

1. Download the dizwell script and run it with two parameters.

Download the script, save it with the .sh extension and give the execute permission to it.

chmod u+x doris.sh

to run the script do the following.

./doris.sh fedora8 10g

./

but if you have hacked your linux beyond reckon, such a me, it is better to run each step one by one.

otherwise d'ont mess aroung run DORIS !!!


2. otherwise install the oracle db as per instructions below.

a. download oracle for your architecture. Be careful ! i tried to install a x64 version on i386, there was no such error as 'wrong architecture' !!! It was more a linking error of some sort.

b. modify the parameters of linux to make it suitable for Oracle. refer to the installation guide.

c. in a nutshell, follow 5. i.e. create a group 'dba' and a user 'oracle'

d. modify the kernel parameters as per 6. in /etc/sysctl.conf

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
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

e. modify oracle shell limit

f. create the oracle root and home directories with full access/ownership to the 'oracle' user and 'dba'.

g. modify the .bash_profile for oracle to add the usual oracle parameters e.g. $ORACLE_HOME $ORACLE_SID $ORACLE_BASE

set the lock to the sloppy lock which otherwise will 'crap' xlib
LIBXCB_ALLOW_SLOPPY_LOCK=1

Also, do add those to the .bash_profile

LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
export LD_LIBRARY_PATH CLASSPATH

h. chekc if your internet conn is up and get the 'other' packages which are not supplied with a fedora core install.

yum install -y libaio gcc libaio-devel unixODBC unixODBC-devel sysstat elfutils-devel libstdc++-devel

The libxcb is critical as without it certain package such as dbca will give a xlib.c line 50 error.

yum --enablerepo=development -y install libxcb.i386

h.instead of clocking i propose that we run the installer with the ignore pre-requiresite. The -jreLoc is to specify the jre location otherwise a funny error happens with the runinstaller. More technical discussions on the sun forums.

./runinstaller -ignoreSysPrereqs -jreLoc /usr/lib/java/jvm

i. ready to install and run.

j. when it has been installed, Don't for get to start the console from:

emctl start dbconsole

k. et voila..


2 comments:

FartyAnimal said...

Can't download the scripts you specified... required a password...

Anthony said...

Looks like the Dizwell script's moved to here: http://dizwell.com/2008/05/01/doris-redux/