ORACLE 10g/11g installation steps

download software at http://www.oracle.com/downloads or use CD


$ unzip 10201_database_linux32.zip

Note: You must unzip both files at the same location for oracle 11gR1 or 2. The output will be just 1 directory named 'database'. If you don't have just 1 directory, please redo this step because you will get an error during installation!

------------------------
check host configuration
------------------------
vi /etc/hosts

----------------------
set kernel parameters
----------------------
vi /etc/sysctl.conf

add this line:

#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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

------
run
------
/sbin/sysctl -p

--------------------------
vi /etc/security/limits.conf
--------------------------
add this line:

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

----------------------
vi /etc/pam.d/login
----------------------
add line:

session required pam_limits.so

--------------------
Disable selinux by:
--------------------
vi /etc/selinux/config

add this line:
SELINUX=disabled

---------------------------------------
Install packages if you don't have them:
---------------------------------------
# From RedHat AS5 Disk 1
cd /media/cdrom/Server
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
cd /
eject

# From RedHat AS5 Disk 2
cd /media/cdrom/Server
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c++-3*
rpm -Uvh gcc-4*
rpm -Uvh libXp-1*
cd /
eject

# From RedHat AS5 Disk 3
cd /media/cdrom/Server
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
cd /
eject

NOTE: Your system engineer should be able to do this for you. Most firms will not give you root access, so you may have to work with your System Engineer to get the packages installed.

------------------------------
create group and user:
------------------------------
groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

-------------------------------
create directories
-------------------------------
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01

----------------------
Login as Oracle and
----------------------

vi .bash_profile

add this line:

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi


Note: This will help you set the environmental variables and avoid errors from these variables.
----------------------
set display variable
----------------------

DISPLAY=(machine-name):0.0; export DISPLAY

Note: If you don't export display, you may have a shaking screen output or may even get an error specifying the display problem.

----------------
lauch installer
----------------
change directory to database and locate runInstaller.exe

./runInstaller

----------------------------
run post installation script
----------------------------
vi /etc/oratab
add :Y to the instance line (i.e. TSH1:/u01/app/oracle/product/10.2.0/db_1:Y)

Note: This is optional.