Installing Oracle 10g

Hari Sabtu gini akhirnya saya masuk juga hiks..hiks... Tapi gpp, demi tugas :D

Alhamdulillah.... akhirnya selesai juga tugas saya menginstall Oracle 10g di Server SunFire dengan OS RedHat Enterprise Linux AS 4. selanjutnya tinggal kompilasi PHP agar support Oracle. sekarang waktunya download PHP di http://www.php.net beserta modul-modul pendukungnya seperti curl, zlib, gd dll.

di bawah ini ada sedikit script sebelum Installasi Oracle 10g dimulai

#!/bin/sh

`expr 1024 \* 1024 \* 1024` > /proc/sys/kernel/shmmax

#group of users to be granted with SYSDBA system privilege
groupadd -g 700 dba
#group owner of Oracle files
groupadd -g 701 oinstall
useradd -c "Oracle software owner" \
-d /opt/oracle/oracleDB/10g \
-u 700 -g oinstall -G dba oracledb

mkdir -p /opt/oracle/oracleDB/10g
chown -R oracledb.oinstall /opt/oracle/oracleDB

mkdir -p /var/opt/oracle
chown oracledb.dba /var/opt/oracle
chmod 755 /var/opt/oracle

dan di bawah ini isi dari /etc/sysctl.conf

# Disables packet forwarding
net.ipv4.ip_forward = 0
# Enables source route verification
net.ipv4.conf.default.rp_filter = 1
# Disables the magic-sysrq key
kernel.sysrq = 0

kernel.sem = 256 32000 100 200
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.shmall = 3279547

kernel.msgmni = 2900
kernel.msgmnb = 65535
net.ipv4.ip_local_port_range = 1024 65000

fs.file-max = 327679

kernel.shmseg = 4096
kernel.msgmax = 8192

net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.rmem_max=262144

net.ipv4.tcp_keepalive_time=3000
net.ipv4.tcp_retries2=5
net.ipv4.tcp_syn_retries=1

di bawah ini isi dar file /etc/rc.local

touch /var/lock/subsys/local
ORACLE_HOME=/oracle/oracleDB/10g
ORACLE_SID=`hostname -s`
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_HOME ORACLE_SID PATH
su - oracledb -c "/oracle/oracleDB/10g/bin/lsnrctl start"
su - oracledb -c "/oracle/oracleDB/10g/bin/mydbstart.sh"
su - oracledb \
-c "/oracle/oracleDB/10g/bin/isqlplusctl start"
su - oracledb \
-c "/oracle/oracleDB/10g/bin/emctl start dbconsole"
su - oracleag \
-c "/oracle/oracleAgent/agent/bin/emctl start agent"

Thanks to Puschitz.Com