Step by Step Cara Instalasi Database Oracle 10g atau 11g di Linux Red Hat atau Fedora

ORACLE INSTALLATION 11gR2 ON FEDORA :
=====================================
 
Guidance ini juga bisa digunakan untuk instalasi Oracle 10g atau 11g di Operating Sistem Linux Redhat, Fedora, Centos, Mandriva
1. Ekstrak file Oracle
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
2. Rubah File /etc/hosts
<IP-address> <fully-qualified-machine-name> <machine-name>
3. /sbin/sysctl -a
Rubah di = “/etc/sysctl.conf”
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
Eksekusi = /sbin/sysctl -p
4. Tambahkan isi di = “/etc/security/limits.conf” file
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
5. Tambahkan di = “/etc/pam.d/login”
session required pam_limits.so
6. Matikan Firewall = (System > Administration > Firewall). Click the “Disable”
atau :
# /sbin/service iptables save
# /sbin/service iptables stop
7. Disable Secure Linux di = “/etc/selinux/config”
SELINUX=disabled
8. Pastikan semua Paket yang perlu di-Install sudah terinstall dengan baik = (terutama compiler)
Jika ingin melakukan yum install melalui Local Repository agar mempermudah instalasi, maka lakukan ini :
# mount /dev/cdrom1 /mnt/ (Here cdrom1 is my local cdrom device)
# cd /mnt/Packages
# rpm -ivh createrepo-0.9.8-5.el6.noarch.rpm
# mkdir -p /opt/localyumserver
# cp -ar *.* /opt/localyumserver
# vim /etc/yum.repos.d/localyumserver.repo
[localyumserver]
name=”Local Yum Server”
baseurl=file:///opt/localyumserver
gpgcheck=0
enabled=1
# createrepo -v /var/ftp/pub/localyumserver
# yum clean all
# yum update
yum install binutils
yum install compat-libstdc++-33
yum install compat-libstdc++-33.i686
yum install elfutils-libelf
yum install elfutils-libelf-devel
yum install gcc
yum install gcc-c++
yum install glibc
yum install glibc.i686
yum install glibc-common
yum install glibc-devel
yum install glibc-devel.i686
yum install glibc-headers
yum install ksh
yum install libaio
yum install libaio.i686
yum install libaio-devel
yum install libaio-devel.i686
yum install libgcc
yum install libgcc.i686
yum install libstdc++
yum install libstdc++.i686
yum install libstdc++-devel
yum install make
yum install numactl-devel
yum install sysstat
yum install unixODBC
yum install unixODBC.i686
yum install unixODBC-devel
yum install unixODBC-devel.i686
yum install libXp
yum install libXp-devel
9. Tambah Group dan User =
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle
10. Buat Direktori untuk Oracle =
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
11. Login sebagai Root, jalankan ini =
xhost +<machine-name>
12. Edit file “/etc/redhat-release”
# cp /etc/redhat-release /etc/redhat-release.original
Ganti isinya menjadi = redhat release 5
13. Login sebagai Oracle, buka file “.bash_profile”
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=fedora14.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; 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
14. Lakukan Instalasi =
Agar X bisa jalan, maka lakukan ini :
a. sebagai normal user lakukan perintah $ xhost + agar semua orang bisa connect ke local display
b. menjadi root using su –
c. lakukan perintah # export DISPLAY=:0.0
d. jalankan program xclock untuk verifikasi
15. ./runInstaller
16. Selesai Instalasi, lakukan =
Kembalikan isi File “/etc/redhat-release”
17. Edit file = “/etc/oratab”
Rubah menjadi : DB11G:/u01/app/oracle/product/11.2.0/db_1:Y
Jika service Oracle mati, maka lakukan perintah ini untuk menaikkan secar manual :
18. $ emctl start dbconsole
19. $ sqlplus /nolog ; conn / as sysdba ; startup
20. $ lsnrctl start
Buka browser anda dan koneksi ke Enterprise Manager di http://localhost:1158/em