Monday, June 26, 2006

Install Oracle 9i on FC 3

Note: this installation failed

REF: (1) http://ivan.kartik.sk/oracle/install_ora9_fedora.html
(2) http://www.tldp.org/HOWTO/html_single/Oracle-9i-Fedora-3-Install-HOWTO/#sect_06_01

Added YS annotation:


Installation of Oracle 9i (R2) on Fedora Core Linux 2, 3 and 4

This paper (HOWTO ref 1) describes step-by-step installation of Oracle 9i database software on Fedora Core 2, 3 and 4.

This paper covers following steps: 1. Pre-Instalation Tasks 1. Create oracle User Account
Login as root and create te user oracle which belongs to dba group.
su -
# groupadd dba
# useradd -g dba oracle
# passwd oracle
(YS: ignore bad password retype the password again)

2. Setting System parameters
Edit the /etc/sysctl.conf and add following lines:
kernel.sem = 250 32000 100 128
kernel.shmmax = 2147483648
kernel.shmmni = 128
kernel.shmall = 2097152
kernel.msgmnb = 65536
kernel.msgmni = 2878
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
Note: You need execute "sysctl -p" or reboot system to apply above settings.
YS: type
% sysctl -p /etc/sysctl.conf

Edit the /etc/security/limits.conf file and add following lines:
* - nproc 16384
* - nofile 16384

3. Setting Oracle Enviroment
Edit the /home/oracle/.bash_profile file and add following lines:
ORACLE_BASE=/opt/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/9.2.0.4
ORACLE_SID=FC3DB1
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_ASSUME_KERNEL=2.4.1
THREADS_FLAG=native
ORACLE_OEM_JAVARUNTIME=/opt/jre
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH LD_ASSUME_KERNEL THREADS_FLAG ORACLE_OEM_JAVARUNTIME PATH

Save the .bash_profile and execute following commands for load new enviroment:
cd /home/oracle
. .bash_profile

Additional step (YS)
- create directory
% mkdir /opt/app
% cd /opt/app
% mkdir oracle
% chown oracle.dba oracle
% chmod 775 oracle

Download & Install

1. Download and install required .rpm packages

Some additional packages are required for succesful instalation of Oracle software. To check wheter required packages are installed on your operating system use following command:
% rpm -q gcc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc

YS: -------------------- result in my machine: -----------------------------------------------
[root@localhost app]# rpm -q gcc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc
gcc-3.4.2-6.fc3
glibc-headers-2.3.3-74
glibc-kernheaders-2.4-9.1.87
glibc-devel-2.3.3-74
package compat-libstdc++ is not installed
cpp-3.4.2-6.fc3
package compat-gcc is not installed

-------------------------------------------------------------------------

If some package is not installed download it from Fedora project website or direct from Core 2, Core 3 or Core 4 locations.

This step is required for Fedora Core 3 and 4 only. Fedora Core 3 is shipped with compat-gcc-8.3.3.4. Fedora Core 4 is shipped with compat-gcc-32-3.2.3. These package are GCC 3.x compiler which are not useful for succesful inatallation. Check whether compat-gcc-8.3.3.4 or compat-gcc-32-3.2.3 is installed. If so then uninstall it using folowing command:
rpm -e compat-gcc
Download the compat-gcc-7.3-2.96.126.i386.rpm package from Core 2 location or from here.



Install the required packages using the rpm command:
# rpm -ivh gcc-3.4.2-6.fc3.i386.rpm glibc-headers-2.3.3-74.i386.rpm glibc-kernheaders-2.4-9.1.87.i386.rpm glibc-devel-2.3.3-74.i386.rpm compat-libstdc++-3.4.2-6.fc3.i386.rpm cpp-3.4.2-6.fc3.i386.rpm compat-gcc-7.3-2.96.126.i386.rpm
---------------------------------------------------------------------------------------
YS: In my case, dowload the following four packages and install:
Note : compat-libstdc++-3.4.2-6.fc3.i386.rpm ( can not find this package)
  • compat-libstdc++-7.3-2.96.126.i386.rpm

  • compat-libstdc++-devel-7.3-2.96.126.i386.rpm

  • compat-gcc-7.3-2.96.126.i386.rpm

  • compat-gcc-c++-7.3-2.96.126.i386.rpm

using: rpm -i --force
to install above 4 packgaes

% rpm -i --force compat-*.rpm
----------------------------------------------------------------------------

For Fedora Core 4 only:Install the required additional packages using the rpm command:
# rpm -ivh compat-libgcc-296-2.96-132.fc4 compat-libstdc++-33-3.2.3-47.fc4 compat-libstdc++-296-2.96-132.fc4

If all required packages were installed succesfuly then login as root and switch the GCC3 compiler binary with GCC2 compiler binary as following:
su -
# cd /usr/bin
# mv ./gcc ./gcc3
# mv ./gcc296 ./gcc

YS: in my case do the following:
---------------------------------------------
# mv /usr/bin/gcc /usr/bin/gcc342
# mv /usr/bin/g++ /usr/bin/g++342
# ln -s /usr/bin/gcc296 /usr/bin/gcc
# ln -s /usr/bin/g++296 /usr/bin/g++

2. Download the Java Runtime Enviroment (j2re-1_3_1_15-linux-i586.bin) from the Sun website. Keep in mind you need to download j2re1.3.1_11 or higher
(Note: Install JRE 1.3.1_1x version only).

YS: downloaed j2re-1_3_1_18-linux-i586.bin ( from: http://java.sun.com/j2se/1.3/download.html)
Login as root and make the the file executable and then execute it. When the JRE is exracted move the "jre1.3.1_15" di rectory to "/opt" directory.

# chmod +x j2re-1_3_1_18-linux-i586.bin
# ./j2re-1_3_1_18-linux-i586.bin
# mv jre1.3.1_18 /opt/
% cd /opt/
% ln -s jre1.3.1_18 jre
3. Download the Oracle 9i (9.2.0.4) software from Oracle website. (YS: skip. Already have disks)
Extract the files using following command: <>
When all archives were extracted you've got three directories Disk1, Disk2 and Disk3.
Edit the Disk1/install/linux/oraparam.ini and modify JRE_LOCATION variable and set path to our JRE installation from Step 2.

JRE_LOCATION=/opt/jre

4. Start the Oracle software installation process.

Now the system is prepared for Oracle software installation. To start the installation process execute the following commands: Unable to load native library: /tmp/OraInstall2005-01-08_11-11-34AM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

Solution: Install new JRE 1.3.1 version. Edit the Disk1/install/linux/oraparam.ini and set path to new JRE for JRE_LOCATION variable. For more information see Download & Install section.

Error in invoking target install of makefile /opt/oracle/920/ctx/lib/ins_ctx.mk
Error in invoking target install of makefile /opt/oracle/920/precomp/lib/ins_precomp.mk
Error in invoking target install of makefile /opt/oracle/920/plsql/lib/ins_plsql.mk
Error in invoking ntcontab.o of makfile /opt/oracle/920/network/lib/ins_net_client.mk

Solution: Install the compat-gcc-7.3-2.96.126.i386.rpm (gcc 2.96) package and change the GCC binaries. For more information see Download & Install section.

/tmp/OraInstall2005-06-14_03-46-25PM/jre/bin/i386/native_threads/java: error while loading shared libraries: /tmp/OraInstall2005-06-14_03-46-25PM/jre/lib/i386/native_threads/libhpi.so: cannot restore segment prot after reloc: Permission denied
Solution: Modify /etc/selinux/config and change value of SELINUX to "disabled" and reboot computer.

No comments: