Oracle 10G Installation Procedure in SuSE 9.3 Professional or SUSE Linux Enterprise Server 9

1. Install the following package in SUSE Linux Enterprise Server 9 :

binutils-2.15.90.0.1.1-32.5
gcc-3.3.3-43.24
gcc-c++-3.3.3-43.24
glibc-2.3.3-98.28
gnome-libs-1.4.1.7-671.1
libstdc++-3.3.3-43.24
libstdc++-devel-3.3.3-43.24
make-3.80-184.1
pdksh-5.2.14-780.1
sysstat-5.0.1-35.1
xscreensaver-4.16-2.6
openmotif-2.2.3
db1-1.85-89.1

compat-db-4.0.14(Will Prompt error But we cannot find in SuSE 9.3)

orarun-1.8-109.15.i586.rpm (For Oracle 9i Only)

2. Modify /etc/sysctl.conf

kernel.shmmax = 536870912
kernel.sem = 250 32000 100 128
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
fs.file-max = 65536

For SuSE Only : /sbin/chkconfig boot.sysctl on

3. Add the following to /etc/security/limits.conf

* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

4. Add the following to /etc/pam.d/login

session required /lib/security/pam_limits.so
session required pam_limits.so

5. Add the following to /etc/profile

ulimit -u 16384 -n 65536

6. Create user ora10g and group dba

7. Add the following to /home/ora10g/.profile

ORACLE_BASE=/disk1/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5; export NLS_LANG
NLS_DATE_FORMAT=dd/mm/yyyy
DISPLAY=192.168.1.123:0.0; export DISPLAY

PATH=$PATH:$ORACLE_HOME/bin; export PATH

ORACLE_SID=test_db
export ORACLE_SID

# For 8.1.7.3-4 and 9i export bugs
ORA_OCI_NO_OPTIMIZED_FETCH=1; export ORA_OCI_NO_OPTIMIZED_FETCH

8. mkdir /disk1 and change permission to ora10g:dba

9. Install DB

10. Install Compansion Option 2

11. Install Compansion Option 3(Apache Only)

12. mv /disk1/oracle/product/10.2.0/db_1/opmn/conf/ons.config /disk1/oracle/product/10.2.0/db_1/opmn/conf/ons.config.orig