Tuesday, June 7, 2011

ORACLE AND LINUX UNBREAKABLE


in partioning select remove linux partitions on selected drive and create default layout

select costumise now

desktop environments
gnome desktop environment

aplications
unselect all options except graphical internet

develpors
select all except kde development and ruby + from x softment development select optional packages and check on llbxp and openmotif

servers
unselect all

base system
select lagacy software support + optionsl psckges check compat-db from system tool check sysstat

installing oracle

open terminal

gedit /etc/sysctl.conf file

past this karnals at the end of the file and replace existing shmmax and shmall

kernel.shmall = 2097152
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
use this cmd to make the kernel parameters changes effective immediately

to check /sbin/sysctl -p

gedit /etc/security/limits.conf

past this parameters at the end of the file

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

gedit /etc/pam.d/login

past this parameters in the end of the file

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

gedit /etc/profile

past this parameters abouve pathmunge

if [ $USER = "oracle" ]; then

        if [ $SHELL = "/bin/ksh" ]; then

              ulimit -p 16384

              ulimit -n 65536

        else

              ulimit -u 16384 -n 65536

        fi

fi

change the release file etc/redhat-release

redhat-4

add user and groups

groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle
passwd oracle

create directory for oracle software

cd /
mkdir u01
cd u01/
mkdir oracle
cd oracle/
mkdir product
cd product/
mkdir 10.2.0
cd 10.2.0
mkdir db_1
cd db_1/
pwd

log in with oracle user

unzip the database from terminal change into the root user and write this
cd /
chown -R oracle:oinstall /u01/
exit

go to the folder that contain database and start installing the software

./runInstaller

select install sofware only
follow instruction at the end of the installation you will be ask to run two cmd as a root user

cd /home/oracle/oraInventory/
./orainstRoot.sh

cd /$oracle_home/
./root.sh

exit and close every thing and reboot the system

login as oracle user insert the fowllowing karnels in

gedit /home/oracle/.bashrc

ORACLE_HOME=/u01/oracle/product/10.2.0/db_1;export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH

and write dbca then fowllow the interface to create database

chack oracle path

echo $ORACLE_HOME
echo $ORACLE_SID


optional

for sql

gedit /home/oracle/.bash_profile


export ORACLE_HOME=
export LD_LIBARARY_PATH=$LD_LIBARARY_PATH:$ORACLE_HOME/lib
export PATH=ORACLE_HOME/bin:$PATH
alias database = 'export ORACLE_SID=test;sqlplus "/as sysdba"'..

Thank you for Reading and have fun with Linux....