Oracle 期中考注意事項

5/7-2008 期中考囉!!
大家都在忙安裝 Oracle (安裝步驟)....(考試會考)
至於之前同學有問到考試當天是不是要自己燒兩片 CD 出來已備考試當天使用
哪兩片呢? 1.Enterprise-R4-U6-i386-disc3.iso  (以下這段會用到這 一片)
+ Install the pre-requisite rpms from the EL4 dvd
 # cd /media/cdrom/Enterprise/RPMS/
 # rpm -ivh libaio-0.3.105-2.i386.rpm  (the DB needs this)


那要如何只靠著 ISO 檔案就去應付考試呢?以下是教學:

  1. 老師他說會幫我們先安裝好 LINUX到 VMWARE 所以到時候我們會有類似這樣的檔案 otherlinux.vmx
  2. 先備份 otherlinux.vmx 以防萬一改壞
  3. 利用 記事本 或 Notepad++ 打開 otherlinux.vmx
  4. 找出類似以下這段
    ide1:0.present 或 ide1:0.fileName 或 ide1:0.deviceType
  5. 改成以下後存檔
  6. 這次開啟應該就會載入 CD 囉



Installing Oracle Database 10gR2 on EL4U5 Linux x86  (Chi-Chung Lee)
這個檔案為了中華大學教學的目的修改自Oracle OTN網站上的檔案而完成
檔名: Oracle Database 10g Rel 2 and Oracle Apex 2.2.1 on OEL4u4 
Feb 2008

### Install Oracle 10g ( on EL4
Boot from EL4 CD or dvd
press enter for graphical install
 ** Need at least 512MB RAM / 2.5GB Space **
+ Select custom package install

+ Automaticaly or Manually partition your hard drive with Disk Druid
 /tmp = 512MB ext3 fixed size
 /boot = 128MB ext3 fixed size
 swap = 1024MB fixed size
 / = fill to maximum allowable size

+ Accept defaults for GRUB boot loader, configure networking, set hostname

+ Most Linux distros and EL4 ship with default security preferences locked down.
For testing purposes I typically turn off the firewall and disable SE Linux.

+ Set language preferences and root password

+ Make sure the packages essential for installing Oracle are selected.
  Desktop : X Window System; Gnome or KDE
  Editors : at least one editor - vi etc.
  Graphical Internet : a web browser - firefox
  Development : Development Tools, and Legacy Software Development
  System : Administration Tools (useful)

+ Uncheck the non-essential packages.
  Servers : Web Server, and Windows File Server
  System : Printing support

For post-install configuration login as root
+ Install the pre-requisite rpms from the EL4 dvd //PS:需要第三光碟片
 # cd /media/cdrom/Enterprise/RPMS/
 # rpm -ivh libaio-0.3.105-2.i386.rpm  (the DB needs this)

+ create groups
 # /usr/sbin/groupadd oinstall
 # /usr/sbin/groupadd dba
 # /usr/sbin/groupadd oper

+ create OS user oracle with group permissions and home /home/oracle
 # /usr/sbin/useradd -g oinstall -G dba,oper -d /home/oracle oracle

+ set user oracle's password
 # /usr/bin/passwd oracle

+ Append user oracle's bash profile with PATH and ORACLE:BASE,HOME and SID information
 # vi /home/oracle/.bash_profile

 umask 022



+ Create the directory for the software installation and assign ownership to oracle:oinstall
 # mkdir -p /u01/app/oracle
 # chown -R oracle:oinstall /u01/app
 # chmod -R 775 /u01/app

+ Make sure the correct kernel parmeters are appended to sysctl.conf
 # vi /etc/sysctl.conf (these can be easily copied from the Quick Installation Guide
                              for Linux x86 doc on the Oracle10g CD)
 kernel.shmall = 2097152
 kernel.shmmax = 2147483648
 kernel.shmmni = 4096
 kernel.sem = 250 32000 100 128
        net.core.rmem_default = 262144
 net.core.rmem_max = 262144
 net.core.wmem_default = 262144
 net.core.wmem_max = 262144
 fs.file-max = 65536
 net.ipv4.ip_local_port_range = 1024 65000

+ set the kernel parameters or reboot //PS: 重開機喔 之後用 ORACLE 這帳號登入進行安裝 DB
 # /sbin/sysctl -p

Login in to xwindows session as user oracle
+ Mount the Oracle10gR2 cd or dvd and run the Database installer
 mount /media/cdrom/
 (cd $HOME && /media/cdrom/database/runInstaller)
 //cd $HOME && /media/cdrom/runInstaller  本人的版本不需要加上 database
 - follow the installer instructions 
(installer checks for 3GB of swap, default partitioning gives 2GB )
 - use password mgmt to unlock DBuser HR & set password 'hr'

+ Installation successful
 http://localhost:5560/isqlplus  ( iSQL*Plus Url )
 http://localhost:5560/isqlplus/dba  ( iSQL*Plus DBA Url )
 http://localhost:1158/em   (bookmark the Enterprise Manager console)

+ The following enables the oracle user to dbshut, dbstart, lsnrctl start and stop  
 As root # vi /etc/oratab  change :N to :Y 
           # cp /etc/oratab /opt/oracle/oratab
[參考連結] How-to: VMware player modification Running .iso Files in VMWare Player

Make A Comment