INSTALASI ORACLE 10g R2 Pada Linux x86 Fedora 7 oleh : Hatma Suryotrisongko -www.hatma.info- Referensi : - Oracle® Database Quick Installation Guide : 10g Release 2 (10.2) for Linux x86 : B15661-01 : June 2005 - Oracle® Database Installation Guide : 10g Release 2 (10.2) for Linux x86 : B15660-01 : June 2005 - http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnFedora7.php 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" gedit /etc/redhat-release 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: gedit /etc/sysctl.conf 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 : gedit /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: gedit /etc/pam.d/login session required /lib/security/pam_limits.so tambahkan pada /etc/profile : gedit /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) gedit /home/oracle/.bash_profile 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) gedit /etc/redhat-release Fedora release 7 (Moonshine) 3. enables the oracle user to dbshut, dbstart and lsnrctl start (dengan user root) gedit /etc/oratab # change orcl:/u01/app/oracle/product/10.2.0/db_1:N # 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) gedit /etc/rc.local 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