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:
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/pam_limits.so
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:
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/10gR2
ORACLE_SID=MY_ORACLE
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
Save the .bash_profile and execute following commands for load new enviroment:
cd /home/oracle
. .bash_profile
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 \
make-3.80-184.1.i586.rpm
2. Download the Oracle 10g release 2 (10.2.0.1.0) software from Oracle website.
Extract the files using following command:
unzip 10201_database_linux32.zip
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/
./runInstaller
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
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: libaio.so.1: 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.