Install Oracle 10g/11g di Linux

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

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 +
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

sumber : http://bicarait.com/2013/04/28/step-by-step-cara-instalasi-database-oracle-10g-atau-11g-di-linux-red-hat-atau-fedora/