Menggaulimu's Blog
Apa Aja Deh, Suka-Suka Gw
Tag Archives: oracle on centos
Installing Oracle 10G on Centos 5 (32bit)
Creating Oracle User Account :
$ su - root $ groupadd dba $ groupadd oinstall $ useradd -c "Oracle Software Owner" -g oinstall -G dba oracle $ passwd oracle
Setting Oracle Environments
$ su - oracle $ pwd #the directory has to be /home/oracle
use vi or nano to edit profile
$ nano .bash_profile
content of .bash_profile :
echo "Welcome to ORACLE Environment" export ORACLE_BASE=/oracle</em></span> export ORACLE_HOME=/oracle/product/10.1.0 export ORACLE_SID=oraclesid #name of oracle instance service export JAVA_HOME=/usr/java/jdk1.5.0_15 #Home directory for java (edit by yourself) export PATH=$JAVA_HOME/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:$ORACLE_HOME/bin export LD_LIBRARY_PATH=/lib:$JAVA_HOME/lib:$ORACLE_HOME/lib:.
Creating Oracle Home Directory (as mention in .bash_profile)
$ su - root $ mkdir /oracle
Change Ownership for Oracle Home Directory (/oracle)
$ chown -R oracle:oinstall /oracle
Check Installed RPMs (make sure all RPMs is Installed)
$ rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio compat-libstdc++-33 glibc-devel
Results :
binutils-2.17.50.0.6-14.el5
package compat-db is not installed
control-center-2.16.0-16.el5
gcc-4.1.2-48.el5
package gcc-c++ is not installed
glibc-2.5-49.el5_5.7
glibc-common-2.5-49.el5_5.7
package gnome-libs is not installed
libstdc++-4.1.2-48.el5
package libstdc++-devel is not installed
make-3.81-3.el5
package pdksh is not installed
package sysstat is not installed
package xscreensaver is not installed
libaio-0.3.106-5
.:: Install Package which not installed ::.
Install xorg-x11-deprecated-libs
$ yum install xorg-x11-deprecated-libs
Set Display to allow from any hosts
$ su - root $ xhost +
Change RedHat Release
$ cp /etc/redhat-release /etc/redhat-release.orig $ cat > /etc/redhat-release << EOF $ Red Hat Enterprise Linux AS release 3 (Taroon) $ EOF
After you are done with the Oracle10g installation, undo the changes you made to /etc/redhat-release
$ su - root</span><em> $ cp /etc/redhat-release.orig /etc/redhat-release
Checking Kernel Parameters (Important!)
To see all kernel parameters, execute:
$ su - root $ sysctl -a
For Oracle10G, the following kernel parameters have to be set to values greater than or equal to the recommended values which can be changed in the proc filesystem:
shmmax = 2147483648 (To verify, execute: cat /proc/sys/kernel/shmmax)
shmmni = 4096 (To verify, execute: cat /proc/sys/kernel/shmmni)
shmall = 2097152 (To verify, execute: cat /proc/sys/kernel/shmall) (for 10g R1)
shmmin = 1 (To verify, execute: ipcs -lm |grep “min seg size”)
shmseg = 10 (It’s hardcoded in the kernel – the default is much higher)
semmsl = 250 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $1}’)
semmns = 32000 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $2}’)
semopm = 100 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $3}’)
semmni = 128 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $4}’)
file-max = 65536 (To verify, execute: cat /proc/sys/fs/file-max)
ip_local_port_range = 1024 65000 (To verify, execute: cat /proc/sys/net/ipv4/ip_local_port_range)
NOTE: Do not change the value of any kernel parameter on a system where it is already higher than listed as minimum requirement.
Edit /etc/sysctl.cont
$ nano /etc/sysctl.conf
add :
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.wmem_default=262144 net.core.rmem_max=262144 net.core.wmem_max=262144
Download / copy Oracle 10G Source Binary to Oracle User Directory (/home/oracle)
10201_database_linux_x86_64.cpio.gz
$ gunzip 10201_database_linux_x86_64.cpio.gz $ cpio -idmv < 10201_database_linux_x86_64.cpio $ cd database $ ./runInstaller