Untuk Instalation siapkan minimum 2 G Swap, untuk secure Linux disabled, Defaultnya seperti di bawah ini :
Centos 5.0:
- GNOME Desktop Environment
- Editors
- Graphical Internet
- Text-based Internet
- Development Libraries
- Development Tools
- Server Configuration Tools
- Administration Tools
- Base
- System Tools
- X Window System
Download Oracle 11g:
Hosts File
#vi /etc/hosts
<IP-address> <fully-qualified-machine-name> <machine-name>
Set Kernel Parameters
kernel.shmall = 2097152
kernel.shmmax = 2147483648 # Smallest of ->
#(Half the size of the physical memory) or (4GB - 1 byte)
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536 # 512 * PROCESSES
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
Test apakah Nilai Kernel sudah masuk dengan syntak :
/sbin/sysctl -a | grep <param-name>
Tambahkan pada file :
“/etc/sysctl.conf” file.
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
Jalankan perintah dibawah ini untuk mengetahui perubahan pada parameter kernel
/sbin/sysctl -p
Tambahkan di #vi/etc/security/limits.conf file:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
Tambahkan di #vi/etc/pam.d/login file,:
session required /lib/security/pam_limits.so
session required pam_limits.so
Edit Disable secure linux di /etc/selinux/config file
SELINUX=disabled
Setup
# Centos 5 Disk 1
cd /media/cdrom/Server
rpm -Uvh binutils-2.*
rpm -Uvh elfutils-libelf-0.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh libaio-0.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh make-3.*
cd /
eject
# Centos 5 Disk 2
cd /media/cdrom/Server
rpm -Uvh elfutils-libelf-devel-0.*
rpm -Uvh glibc-devel-2.*
rpm -Uvh gcc-4.*
rpm -Uvh gcc-c++-4.*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh unixODBC-2.*
cd /
eject
# Centos 5 Disk 3
cd /media/cdrom/Server
rpm -Uvh compat-libstdc++-33*
cd /
eject
# Centos 5 Disk 4
rpm -Uvh unixODBC-devel-2.*
cd /
eject
# Centos 5 Disk 5
rpm -Uvh libaio-devel-0.*
cd /
eject
# Centos 5 Disk 6
cd /media/cdrom/Server
rpm -Uvh sysstat-7.*
cd /
eject
Membuat user account dan, groups :
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle
Buatkan Direktori untuk keperluan Instalasi Oracle :
mkdir -p /u01/app/oracle/product/11.1.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
Login sebagai root, ikuti perintah dibawah ini:
xhost +<machine-name>
Login sebagai user oracle dan tambhkan beberapa syntak dibawah ini
pada file .bash_profile :
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=oel45.localdomain
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.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
Installasi
Login sebagai user Oracle, lakukan syntak dibawah ini:
DISPLAY=<machine-name>:0.0; export DISPLAY
Mulai jalankan Installer Oracle :
./runInstaller
- Select Installation Method
2. Specify Inventory Directory and Credentials
3.Select Installation Type
4. Install Location
5. Product-Specific Prerequisite Checks
6.Select Configuration Option
7. Select Database Configuration
8. Specify Database Configuration Options
9. Specify Database Configuration Details
10. Select Database Management Option
11. Specify Database Storage Option
12. Specify Backup and Recovery Options
13. Specify Database Schema Passwords
14. Oracle Configuration Manager Registration
15. Summary
16. Install
17. Configuration Assistants
18. Database Configuration Assistant
19. DatabaseConfiguration Assistant Summary
20. Execute Configuration Scripts
21. End of Installation
22. OEM Database Control Login
23. OEM Database Control
Setelah Installasi
Edit e /etc/oratab isikan ‘Y’:
DB11G:/u01/app/oracle/product/11.1.0/db_1:Y
Startup Otomatis
vi /home/oracle/startuporacle.sh
#!/bin/sh
ORACLE_HOSTNAME=oracleas.pmt.com
ORACLE_BASE=/home/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.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 LD_LIBRARY_PATH
lsnrctl start
sqlplus “/ as sysdba” <<EOF
startup
quit
EOF
emctl start dbconsole
isqlplusctl start
exit
Hak akses
chmod +x startuporacle (jalankan dg user yg sama waktu create file ini. jgn sbg root)
login sbg root . buka file rc.local .
$ vi /etc/rc.d/rc.local
tambahkan lines berikut pada bagian akhir (simpan di /home/oracle):
su – oracle -c /home/oracle/startuporacle
Source : www.oracle-base.com
Leave a comment