Installation of Oracle 10g Release 2 ( on SUSE ES 9, SUSE Profesional 9.1, 9.2 and 9.3

This paper (HOWTO) describes step-by-step installation of Oracle 10g R2 database software on SUSE Linux Enterprise Server 9 and for SUSE Profesional 9.1, 9.2 and 9.3. Note that SUSE Profesional distribution is not certified by Oracle Corporation for this version of Database.
This article does not cover database creation process, and ASM Instance creation process.

This paper covers following steps:

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
# mkdir /home/oracle
# chown oracle:dba /home/oracle

2. Setting System parameters
Edit the /etc/sysctl.conf and add following lines:
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 = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
Note: You need reboot system or execute "sysctl -p" command to apply above settings.

Edit the /etc/pam.d/login file and add following line:
session required /lib/security/

Edit the /etc/security/limits.conf file and add following lines:
oracle    soft  nproc  2047
oracle    hard  nproc  16384
oracle    soft  nofile  1024
oracle    hard  nofile  65536

3. Creating oracle directories
# mkdir /opt/oracle
# mkdir /opt/oracle/10gR2
# chown -R oracle:dba /opt/oracle

4. Setting Oracle Enviroment
Edit the /home/oracle/.bash_profile file and add following lines:


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

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 make gcc glibc glibc-devel libstdc++ libstdc++-devel cpp openmotif openmotif21 pdksh libaio libaio-devel

If some package is not installed install it from installation media or download it (only for SUSE Profesional distributions) from locations SUSE ftp server or direct from 9.1, 9.2 or 9.3 locations.

Install the required packages using the rpm command:
# rpm -ivh gcc-3.3.4-11.i586.rpm \
glibc-devel-2.3.3-118.i586.rpm \
libstdc++-3.3.4-11.i586.rpm \
libstdc++-devel-3.3.4-11.i586.rpm \
cpp-3.3.4-11.i586.rpm \
pdksh-5.2.14-780.i586.rpm \
openmotif-2.2.2-519.1.i586.rpm \
openmotif21-libs-2.1.30MLI4-115.i586.rpm \
libaio-0.3.98-17.i586.rpm \
libaio-devel-0.3.98-18.3.i586.rpm \

2. Download the Oracle 10g release 2 ( software from Oracle website.
Extract the files using following command:

3. Start the Oracle software installation process.

Now the system is prepared for Oracle software installation. To start the installation process execute the following commands:
cd db/Disk1/

Post-Instalation Tasks

1. Use this step when you will be not running RAC or ASM instance.
su -
# /etc/init.d/init.cssd disable
# /etc/init.d/init.cssd stop

Common Installation Errors

DISPLAY not set. Please set the DISPLAY and try again.
Solution: Execute "export DISPLAY=:0.0" when you perform installtion on local machine or "export DISPLAY=:0.0 when you perform installation on remote machine connected over SSH". Don't forget to execute "xhost +" command on client machine.

error while loading shared libraries: cannot open shared object file: No such file or directory
Solution: Install libaio and libaio-devel packages. If packages already installed and error still occurs try execute "ldconfig" as root.

Check complete. The overall result of this check is: Failed <<<<
Solution: Install missing package or set check system parameters (See reason of failure).

Comments, suggestions, questions, errors (also grammatical :) )? Feel free to contact me.