Install oracle on SUSE 10 , 11

Install oracle 10g on SUSE 10,11

Pre-requirements

• At least 1GB RAM
• Swap space = 2 x physical RAM (until 3 GB) after 3GB swap should equal to physical RAM size
• 500MB on /tmp directory
• 5 GB on /home/oracle

Install following packages

• binutils
• gcc
• gcc-c++
• glibc
• gnome-libs
• libstdc++
• compat- libstdc++
• libstdc++-devel
• libaio
• libaio-devel
• make
• pdksh
• sysstat
• openmotif

(if you are not using gnome , gnome-libs is optional )

After all install orarun package which compatible to architecture of the PC

Edit following files

1. /etc/SuSE-release

Insert following details on it

SUSE Linux Enterprise Server 9 (i586)

VERSION = 9

2. /etc/hosts

Insert the ip address of the PC and comment the 127.0.0.2 line

Ex:

# 127.0.0.2 demo.chaamaa.com demo

192.168.1.5 demo.chaamaa.com demo

Run one of followings as root to set kernel parameters “/etc/init.d/oracle start” or “rcoracle start”. If none of them works edit /etc/sysconfig/oracle. Please have a look at the orarun readme (/usr/share/doc/packages/orarun)

Create following directories

mkdir -p /opt/oracle/stage

change ownership to oracle

chown -R oracle:dba /opt/oracle

log into X window session as oracle user

ssh –X oracle@localhost

(if x session failed assign password to oracle user and also check whether oracle user has a shell with yast user manager.if not assign bin/bash to oracle user)

copy the setup directory into /opt/oracle

ex: cp 10201_database_linux32.zip /opt/oracle

extract the zip file

unzip 10201_database_linux32.zip

change directory into extract folder

cd database/

run the installer to invoke oracle universal installer

./runInstaller

Continue with the oracle Universal installer by following instructions of OUI

Continue without any warnings of pre requirements failures.

Post installation activities

1. Auto Startup and Shutdown of Database and Listener

Login as root and modify /etc/oratab file and change last character to Y for apropriate database.

ORCL:/opt/oracle/102:Y

As root user create new file "oracle" (init script for startup and shutdown the database) in /etc/init.d/ directory with following content:

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

#!/bin/bash

#

# oracle Init file for starting and stopping

# valid for 10g and 11g versions.

#

# description: Oracle Database startup stop and restarting script

. /etc/rc.d/init.d/functions

ORACLE_OWNER="oracle"

ORACLE_HOME="/opt/oracle/product/10.2/db_1"

case "$1" in

start)

echo -n $"Starting Oracle DB:"

su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"

echo "OK"

;;

stop)

echo -n $"Stopping Oracle DB:"

su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"

echo "OK"

;;

restart)

echo -n $"Restarting Oracle DB"

su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"

echo -n "DB stopped successfully"

su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"

echo -n "DB started successfully"

;;

*)

echo $"Usage: $0 {start|stop|restart}"

esac

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

Give permission to the script to execute

Chmod +x /etc/init.d/oracle