oracle10grac安裝圖解.doc

oracle 10g rac 安裝圖解規(guī)劃：所用linux系統(tǒng)以虛擬化方式安裝在esx上，配置有內(nèi)網(wǎng)的yum源，各分配有16G存儲，下面為簡單拓?fù)鋱D一，下載軟件1,地址：/technology/software/products/database/oracle10g/htdocs/10201linx8664soft.html10201_database_linux_x86_64.cpio.gz10201_clusterware_linux_x86_64.cpio.gz2,地址：/technology/software/tech/linux/asmlib/rhel5.htmloracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpmoracleasm-support-2.1.3-1.el5.x86_64.rpm二，安裝環(huán)境1，系統(tǒng)：centos 5.4 x86_642，外部存儲：linux下的iscsi3, iscsi服務(wù)器配置#下載iSCSI Enterprise Targetwget /sourceforge/iscsitarget/iscsitarget-0.4.17.tar.gz#解壓縮tar -zxvf iscsitarget-0.4.17.tar.gzcd iscsitarget-0.4.17#編譯、安裝makemake install#配置服務(wù)chkconfig -level 2345 iscsi-target onservice iscsi-target start#配置第一個iSCSI設(shè)備#在/opt/下生成64G大的空洞設(shè)備文件#請將opt修改為實(shí)際的目錄，并根據(jù)實(shí)際情況設(shè)置設(shè)備文件大小#生成空洞文件速度很快的，且在真正使用之前不占用磁盤實(shí)際空間dd if=/dev/zero of=/opt/iscsi.配置文件中Target的名稱.img bs=1G count=64 seek=64#cout是從什么開始，一般設(shè)置為0#生成256G的例子dd if=/dev/zero of=/opt/iscsi/.haoyuan-inc:storage.disk.oracle.01.img bs=1G count=0 seek=256vim /etc/ietd.conf#編輯Target名稱，例如：.haoyuan-inc:storage.disk.share.01#編輯LUN段內(nèi)容，例如：Lun 0 Path=/opt/.haoyuan-inc:storage.disk.share.01.image,Type=fileio#不要設(shè)置XXXUser，允許任何人訪問#重啟iscsi-targetservice iscsi-target restart三，安裝準(zhǔn)備1，檢查必須軟件yum install jdk binutils elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c+ libaio libaio-devel libgcc libstdc+ libstdc+-devel make sysstat unixODBC unixODBC-devel libXp libXp-devel#其中jdk是我在yum服務(wù)器中添加的2，修改內(nèi)核參數(shù)編輯/etc/sysctl.confkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144#生效/sbin/sysctl -p3，修改系統(tǒng)shell限制vi /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655364，配置 Hangcheck 計時器所有 RHEL 版本：cat /etc/rc.d/rc.local /.ssh/authorized_keys$cat /.ssh/id_dsa.pub /.ssh/authorized_keys$ssh oraclerac2 cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ssh oraclerac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys$chmod 644 /.ssh/authorized_keysrac2$cat /.ssh/id_rsa.pub /.ssh/authorized_keys$cat /.ssh/id_dsa.pub /.ssh/authorized_keys$ssh oraclerac1 cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ssh oraclerac1 cat /.ssh/id_dsa.pub /.ssh/authorized_keys$chmod 644 /.ssh/authorized_keys#建立等效性rac1,rac2$ssh rac1$ssh rac1-priv$ssh rac2$ssh rac2-priv8，配置時間同步rac1、rac2#vi /etc/crontab17 18 * * * /usr/sbin/ntpdate /dev/null9,修改系統(tǒng)版本rac1,rac2vi /etc/redhat-release#將CentOS release 5 (Final) 修改成redhat 4四、配置ASM1，安裝所需軟件rac1、rac2rpm -ivh oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpmoracleasm-support-2.1.3-1.el5.x86_64.rpm2，掛載iscsi硬盤rac1、rac2yum install -y -nogpgcheck iscsi-initiator-utilschkconfig -level 2345 iscsi onchkconfig -level 2345 iscsid onservice iscsi startservice iscsid startiscsiadm -mode discovery -type sendtargets -portal 1iscsiadm -m node -T .forzw:storage.disk.oracle.01 -p 1 -lvi /etc/rc.localiscsiadm -m node -T .forzw:storage.disk.oracle.01 -p 1 -l3，配置ASMrac1，rac2/etc/init.d/oracleasm configureDefault user to own the driver interface : oracleDefault group to own the driver interface : dbaStart Oracle ASM library driver on boot (y/n) n: yScan for Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: OK Scanning the system for Oracle ASMLib disks: OK /etc/init.d/oracleasm enableWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: OK Scanning the system for Oracle ASMLib disks: OK rac1fdisk /dev/sdbDisk /dev/sdb: 67.1 GB, 67108864000 bytes64 heads, 32 sectors/track, 64000 cylindersUnits = cylinders of 2048 * 512 = 1048576 bytesDevice Boot Start End Blocks Id System/dev/sdb1 1 1000 1023984 83 Linux/dev/sdb2 1001 2000 1024000 83 Linux/dev/sdb3 2001 12000 10240000 83 Linux/dev/sdb4 12001 64000 53248000 83 Linux/etc/init.d/oracleasm createdisk VOL1 /dev/sdb3/etc/init.d/oracleasm listdisksVOL1rac2/etc/init.d/oracleasm scandisks五，安裝配置RAC1，創(chuàng)建安裝目錄rac1，rac2mkdir -p /u01/app/oracle/product/10.2.0/db_1mkdir -p /u01/app/oracle/product/10.2.0/crschown -R oracle:oinstall /u01chmod -R 775 /u012，設(shè)置環(huán)境變量rac1$vi .bash_profile# .bash_profile# User specific aliases and functions# Source global definitionsif -f /etc/bashrc ; then. /etc/bashrcfiexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crsexport ORACLE_SID=bccb1export ORACLE_TERM=xtermexport NLS_LANG=AMERICAN_AMERICA.UTF8export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/libPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/sbinexport PATHrac2$vi .bash_profile# .bash_profile# User specific aliases and functions# Source global definitionsif -f /etc/bashrc ; then. /etc/bashrcfiexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crsexport ORACLE_SID=bccb2export ORACLE_TERM=xtermexport NLS_LANG=AMERICAN_AMERICA.UTF8export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/libPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/sbinexport PATH3，配置voting diskrac1，rac2mkdir -p /u02/oracrs/chown -R oracle:oinstall /u02/oracrs/chmod -R 775 /u02/oracrs/raw /dev/raw/raw1 /dev/sdb1raw /dev/raw/raw2 /dev/sdb2vi /etc/sysconfig/rawdevices/dev/raw/raw1 /dev/sdb1/dev/raw/raw2 /dev/sdb2chown root:oinstall /dev/raw/raw1chmod 640 /dev/raw/raw1chown oracle:dba /dev/raw/raw2chmod 660 /dev/raw/raw2vi /etc/rc.localraw /dev/raw/raw1 /dev/sdb1raw /dev/raw/raw2 /dev/sdb2chown root:oinstall /dev/raw/raw1chmod 640 /dev/raw/raw1chown oracle:dba /dev/raw/raw2chmod 660 /dev/raw/raw2$ln -s /dev/raw/raw1 /u02/oracrs/ocr.crs$ln -s /dev/raw/raw2 /u02/oracrs/vote.crs4，安裝racrac1(安裝只在一臺機(jī)器上進(jìn)行）gzip d 10201_clusterware_linux_x86_64.cpio.gzcpio idmv 10201_clusterware_linux_x86_64.cpiochown -R oracle:oinstall clusterwarestatxxhost+su oracle$cd $source .bash_profile$mkdir -p /u01/app/oracle/oraInventory$cd clusterware$./runInstall彈出安裝界面指定Inventory目錄，由于已經(jīng)環(huán)境變量，這里會默認(rèn)選擇改變crs安裝路徑，這里選擇已經(jīng)設(shè)置在環(huán)境變量中的crs目錄安裝條件檢查群集名稱默認(rèn)設(shè)置為crs，添加節(jié)點(diǎn)，注意要和hosts文件種一致配置網(wǎng)絡(luò)接口類型配置ocr位置配置Voting Disk位置安裝概要安裝過程執(zhí)行腳本，依次執(zhí)行，且先執(zhí)行本機(jī)，等腳本完成后，再在節(jié)點(diǎn)上執(zhí)行，權(quán)限為root用戶在rac2上執(zhí)行root.sh時候會出現(xiàn)錯誤，這里跳到文章最后的“問題四“去按照步驟解決問題，之后回來點(diǎn)OK，即完成。六，安裝oracle 10grac1(安裝只在一臺機(jī)器上進(jìn)行）cpio idmv 10201_database_linux_x86_64.cpiochown -R oracle:oinstall databasestatxxhost+su oracle$cd $source .bash_profile$mkdir -p /u01/app/oracle/oraInventory$cd database$./runInstall彈出歡迎界面選擇安裝類型，選擇企業(yè)版選擇安裝位置，這里會自動填寫變量中定義目錄選中所有節(jié)點(diǎn)安裝條件檢查創(chuàng)建啟動數(shù)據(jù)庫選擇通用數(shù)據(jù)庫指定全局?jǐn)?shù)據(jù)庫名稱和sid，并選上示例選擇數(shù)據(jù)庫管理選項(xiàng)選擇數(shù)據(jù)庫數(shù)據(jù)存儲方式，這里選擇ASM彈出警告，點(diǎn)擊OK繼續(xù)配置備份，這里選擇無備份選擇ASM存儲，由于只設(shè)置了一個卷，選擇冗余方式為擴(kuò)展配置密碼安裝概要安裝過程配置助手過程彈出界面配置成功安裝結(jié)束#安裝過程中遇到問題解決辦法#問題一：連接被拒絕PRKC-1044 FAILED TO CHECK REMOTE COMMAND EXECUTION在節(jié)點(diǎn)上執(zhí)行ssh （本地和其他節(jié)點(diǎn)hostname）問題二：提示虛擬ip被占用不應(yīng)該事先綁定虛擬ip問題三：提示SEVERE: Remote AttachHome failed on nodes查看node的oralnventory目錄權(quán)限后執(zhí)行”/u01/crs/oracle/product/10.2.0/crs_1/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=/u01/crs/oracle/product/10.2.0/crs_1 ORACLE_HOME_NAME=OraCrs10g_home CLUSTER_NODES=HY_471,HY_472 CRS=true “INVENTORY_LOCATION=/u01/oracle/oraInventory” LOCAL_NODE=HY_472“問題四：在節(jié)點(diǎn)上執(zhí)行root.sh結(jié)束時候提示“Running vipca(silent) for configuring nodeapps/u01/app/oracle/product/10.2.0/crs/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: “等解決方法：rac2cd /u01/app/oracle/product/10.2.0/crs/bin/ ./oifcfg iflisteth0 eth1 ./oifcfg setif -global eth0/:public./oifcfg setif -global eth1/:cluster_interconnect./oifcfg iflisteth0 eth1 ./oifcfg getifeth0 global publiceth1 global cluster_interconnect/crs/bin下，文件名分別為vipca和srvctl。首先編輯vipca文件，找到如下內(nèi)容：Remove this workaround when the bug 3937317 is fixedarch=uname -mif $arch = i686 -o $arch = ia64 thenLD_ASSUME_KERNEL=2.4.19export LD_ASSUME_KERNELfi#End workaround#在fi 后新添加一行：unset LD_ASSUME_KERNEL然后編輯srvctl文件，找到如下內(nèi)容：LD_ASSUME_KERNEL=2.4.19export LD_ASSUME_KERNEL#同樣在其后新增加一行：unset LD_AS