Oracle 期中考注意事項
5/7-2008 期中考囉!!
大家都在忙安裝 Oracle (安裝步驟)....(考試會考)
至於之前同學有問到考試當天是不是要自己燒兩片 CD 出來已備考試當天使用
哪兩片呢? 1.Enterprise-R4-U6-i386-disc3.iso (以下這段會用到這 一片)
大家都在忙安裝 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)2.oracle10gR2_server.iso
畢竟地球在暖化,實在不能再這樣浪費資源了!!
那要如何只靠著 ISO 檔案就去應付考試呢?以下是教學:
- 老師他說會幫我們先安裝好 LINUX到 VMWARE 所以到時候我們會有類似這樣的檔案 otherlinux.vmx
- 先備份 otherlinux.vmx 以防萬一改壞
- 利用 記事本 或 Notepad++ 打開 otherlinux.vmx
- 找出類似以下這段
ide1:0.present 或 ide1:0.fileName 或 ide1:0.deviceTypeide1:0.present = "FALSE" ide1:0.fileName = "auto detect" ide1:0.deviceType = "cdrom-raw"
- 改成以下後存檔
ide1:0.present = "TRUE" ide1:0.fileName = "C:\ORACLE\oracle10gR2_server.iso" //絕對路徑 ide1:0.deviceType = "cdrom-image"
- 這次開啟應該就會載入 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 網址:http://www.oracle.com/technology/tech/linux/install/index.html Feb 2008 ### Install Oracle 10g (10.2.0.1) 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 eg.joburg + 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 PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib ORACLE_BASE=/u01/app/oracle ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 ORACLE_SID=orcl PATH=$ORACLE_HOME/bin:$PATH export PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME ORACLE_SID + 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
Comment Form under post in blogger/blogspot