Instalasi Oracle 10g R2 Pada Linux x86 Fedora 7

Instal Fedora7 (SELINUX Disabled):
* Editors
* Graphical Internet
* Administration Tools
* Base
* X Window System
* System Tools
* Server Configuration Tools
* GNOME Desktop Environment
* Development Libraries
* Development Tools
* Legacy Software Support
* Hardware Support

A. Setelah instalasi selesai, login pada terminal menggunakan user root su root

B. Lakukan pengecekan Hardware Minimum Requirements
- At least 1024 MB of physical RAM
- swap space 1-2 x RAM
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
free
- 400 MB of disk space in the /tmp directory
- Between 1.5 GB and 3.5 GB of disk space for the Oracle software
- 1.2 GB of disk space for a preconfigured database that uses file system storage (optional)
df -k /tmp
df -k
- determine whether the system architecture can run the software
grep “model name” /proc/cpuinfo

C. Lakukan pengecekan Software Requirements
The system must be running the following (or later) kernel version:
– Red Hat Enterprise Linux 3.0 and Asianux 1.0 : 2.4.21-27.EL
– Red Hat Enterprise Linux 4.0 and Asianux 2.0 : 2.6.9-5.0.5.EL
– SUSE Linux Enterprise Server 9 : 2.6.5-7.97
cat /etc/issue
uname -r
karena menggunakan fedora 7, update /etc/redhat-release , rubah menjadi “redhat-4″ :
Lakukan pengecekan paket. Instal paket yang belum tersedia :
rpm -q libaio make gcc glibc compat-db compat-gcc-34 compat-gcc-34-c++ compat-libstdc++-33 libXp openmotif setarch

D. Creating Required Operating System Groups and Users
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -g oinstall -G dba oracle
ganti passowrd user oracle
passwd oracle

E. Configuring Kernel Parameters.
edit /etc/sysctl.conf dan tambahkan:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
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 = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
terapkan perubahan:
/sbin/sysctl -p

F. Set Shell Limits for the oracle User
tambahkan pada /etc/security/limits.conf :
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
tambahkan pada /etc/pam.d/login , jika belum ada:
session required /lib/security/pam_limits.so
tambahkan pada /etc/profile :
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
export ORACLE_BASE=/u01/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl;
terapkan perubahan
source /etc/profile

G. Creating Required Directories
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle

H. Installing Oracle Database
reboot/restart, login sebagai user oracle (mode grafis), dan buka terminal.
./runInstaller
hilangkan pilihan create database. akan kita lakukan menggunakan dbca.

I. Oracle Post-installation Tasks

1. tambahkan pada /home/oracle/.bash_profile (dengan user root)
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
reboot/restart, login sebagai user oracle (mode grafis), dan buka terminal. buat database
dbca

2. Edit lagi /etc/redhat-release kembalikan seperti kondisi awal (dengan user root)
Fedora release 7 (Moonshine)

3. enables the oracle user to dbshut, dbstart and lsnrctl start (dengan user root)
# to orcl:/u01/app/oracle/product/10.2.0/db_1:Y

4. buat otomatis startup script, (dengan user oracle) gedit /home/oracle/oraclestartup.sh
lsnrctl start
emctl start dbconsole
isqlplusctl start
sqlplus sys/oracle as sysdba << EOF
startup
EOF
exit
dan beri hak akses
chmod 755 /home/oracle/oraclestartup.sh

5. Tambahkan pada /etc/rc.local (dengan user root)
su - oracle << EOF
/home/oracle/oraclestartup.sh
EOF
exit

6. REBOOT. Login dengan user oracle dan test oracle berjalan normal
melalui terminal:
lsnrctl status
emctl status dbconsole
melalui web browser :
- iSQL*Plus URL:
http://localhost:5560/isqlplus
- iSQL*Plus DBA URL:
http://localhost:5560/isqlplus/dba
- Enterprise Manager 10g Database Control URL:
http://localhost:1158/em