Bayu Kurniawan R

Sumber :

http://www.oracle.com/technology/pub/articles/smiley-11gr1-install.html
http://www.sqlplex.com/articles/oracle/installation/installing-oracle-database-11g.html
http://rattyboy.wordpress.com/2008/07/09/encrypted-rsync-with-centos-5-rhel-5-fuse-sshfs-and-duplicity/
http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php#the_rsh_command
http://ifrozi.wordpress.com/2008/05/

Setting Public Key
[root@rocat /]# ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/root/.ssh/id_dsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /root/.ssh/id_dsa.
Your public key has been saved in /root/.ssh/id_dsa.pub.
The key fingerprint is:
e9:44:24:20:dc:6a:1b:5e:6a:73:58:ca:5e:3e:35:fd root@testbox

Install Library yang dibutuhkan :
* elfutils-libelf-devel-0.125-3.el5
rpm -ivh elfutils-libelf-devel-0.125-3.el5.i386.rpm elfutils-libelf-devel-static-0.125-3.el5.i386.rpm
* compat-libstdc++-33-3.2.3-61
* elfutils-libelf-0.125-3.el5
* glibc-2.5-12
* glibc-devel-2.5-12
* glibc-common-2.5-12
* gcc-4.1.1-52.el5
* gcc-c++-4.1.1-52.el5
* libgcc-4.1.1-52.el5
* libaio-0.3.106-3.2
* libaio-devel-0.3.106-3.2
* libstdc++-4.1.1-52.el5
* libstdc++-devel-4.1.1-52.el5
* unixODBC-2.2.11-7.1
* unixODBC-devel-2.2.11-7.1
* sysstat-7.0.0-3.el5
* binutils-2.17.50.0.6-2.el5
* make-3.81-1.1

Setting User dan Group :
[root@rocat /]# /usr/sbin/groupadd oinstall
[root@rocat /]# /usr/sbin/groupadd dba
[root@rocat /]# /usr/sbin/useradd -m -g oinstall -G dba oracle
[root@rocat /]# passwd oracle

Pembuatan direktori dan hak akses :
[root@rocat /]# mkdir -p /u01/app/oracle
[root@rocat /]# chown -R oracle:oinstall /u01/app
[root@rocat /]# chmod -R 775 /u01/app

Setting Kernel :
[root@rocat /]# cat >> /etc/sysctl.conf <<EOF
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
> 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=4194304
> net.core.wmem_default=262144
> net.core.rmem_max=4194304
> net.core.wmem_max=262144
> EOF

[root@rocat /]# /sbin/sysctl -p

Minimum Kernel
kernel.shmall = 2097152
kernel.shmmax = 536870912
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=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144

Install Oracle :

* Login sebagai User oracle

* [root@rocat /]# ./runInstaller

Start Oracle automatically :

Setting oratab
/etc/oratab : SID:ORACLE_HOME:Y

Setting /etc/init.d/dbora
#########################################################
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

#ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
ORA_HOME=/u01/app/oracle/product/11.1.0/db_1
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo “Oracle startup: cannot start”
exit
fi

case “$1″ in
’start’)
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c “$ORA_HOME/bin/dbstart $ORA_HOME”
;;
’stop’)
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c “$ORA_HOME/bin/dbshut $ORA_HOME”
;;
esac

#########################################################

[root@rocat /]# chmod 750 /etc/init.d/dbora
[root@rocat /]# chkconfig –level 345 dbora on

Start Oracle
[root@rocat /]# $ORACLE_HOME/bin/lsnrctl start
[root@rocat /]# $ORACLE_HOME/bin/dbstart

Kalau masih masalah, tambahkan aja skrip dibawah ke /etc/rc.local
/etc/rc.local
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1/
$ORACLE_HOME/bin/lsnrctl start
/etc/init.d/dbora start