ORACLE rac安裝后總結(jié)

1、.linux 安裝oracle 總結(jié)： Redhat5.4 x64安裝ORACLE10G修改 /etc/vsftpd>>>>ftpusers and user_ 開啟FTP.首先安裝以下包：rpm -q glibc glibc-common glibc-devel libXp binutils binutils compat-db control-enter gcc gcc-c+ libstdc+ libstdc+-devel make ksh sysstat gnome-screensaver libaio-devel libaio openmotif22用以下命令檢

2、查是否全部成功：$ rpm -qa |grep glibc-2glibc-2.3.4-2.13compat-glibc-2.3.2-95.30compat-glibc-2.3.2-95.30glibc-2.3.4-2.13$ rpm -qa |grep glibc-develglibc-devel-2.3.4-2.13glibc-devel-2.3.4-2.13 32（32位）rpm -qa -queryformat "%NAME-%VERSION-%RELEASE (%ARCH)n"|grep 終極查看法.以root用戶身份執(zhí)行，在兩節(jié)點(diǎn)上做如下配置。編輯/etc/sys

3、ctl.conf文件# vi /etc/sysctl.conf在文件尾部添加下述內(nèi)容kernel.shmall = 2097152kernel.shmmax = 4294967297/ 物理內(nèi)存的一半kernel.shmmni = 4096kernel.sem = 250 32000 100 128vm.min_free_kbytes=409600vm.vfs_cache_pressure=200vm.swappiness =40fs.file-max = 101365net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default

4、= 1048576/ 256Knet.core.rmem_max = 1048576/ 1Mnet.core.wmem_default = 262144net.core.wmem_max = 1048576Sysctl -p生效.為 oracle 用戶設(shè)置 Shell 限制.Oracle 建議對(duì)每個(gè) Linux 帳戶可以使用的進(jìn)程數(shù)和打開的文件數(shù)設(shè)置限制,ROOT登錄.(/etc/profile file (or the file on SUSE systems)/etc/profile.local:if $USER = "oracle" ; thenif $SHELL =

5、 "/bin/ksh" ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi For the C shell (csh or tcsh), add the following lines to the/etc/csh.login file (or the file on SUSEsystems)/etc/csh.login.local:if ( $USER = "oracle" ) thenlimit maxproc 16384limit descriptors 6553

6、6endifAdd the following lines to the /etc/security/limits.conf file:oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536修改/etc/pam.d/login，增加以下內(nèi)容session required /lib/security/pam_limits.so配置hangcheck-timer內(nèi)核模塊以root用戶身份執(zhí)行，在兩節(jié)點(diǎn)上做如下配置。查看模塊是否存在# find /lib/modules

7、 -name "hangcheck-timer.ko"編輯/etc/modprobe.conf# vi /etc/modprobe.conf在文件的末尾加入一行options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180配置為自啟動(dòng)vi /etc/rc.d/rc.local在文件的末尾加入一行/sbin/modprobe hangcheck_timer啟動(dòng)hangcheck# modprobe hangcheck_timer檢查hangcheck是否成功啟動(dòng)# grep hangcheck /var/log/m

8、essages | tail -2如果顯示下述信息說明已經(jīng)成功啟動(dòng)hangcheckMar 16 12:52:32 node2 kernel: Hangcheck: starting hangcheck timer 0.5.0 (tick is 180 seconds, margin is 60 seconds).創(chuàng)建ORACLE用戶及文件夾權(quán)限等新增組和用戶：groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oraclepasswd oracle 創(chuàng)建Oracle的安裝目錄，并把權(quán)限付給oracle用戶:mkdir oracle

9、chown -R oracle:oinstall /oracle解壓database修改database目錄權(quán)限，用戶和用戶組chown -R oracle：oinstall database/chmod -R 775 database/. 修改/etc/hosts文件及oracle用戶里的.bash_profile文件# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/bin:/usr/

10、bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbinexport PATHunset USERNAMEORA_CRS_BASE=/oracle/crsORA_CRS_HOME=$ORA_CRS_BASE/product/10.2.0/crs_1ORACLE_BASE=/oracle/app#ORACLE_BASE=$ORA_CRS_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1#ORACLE_HOME=$ORA_CRS_HOMEORACLE_SID=oradb1PATH=$ORACLE

11、_HOME/bin:$ORA_CRS_HOME/bin:/usr/local/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORA_CRS_HOME/lib:$ORA_CRS_HOME/lib32NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORA_CRS_BASE ORA_CRS_HOME PATH NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH. 安裝一些RAC_的必要包c(diǎn)ompat-binutils215

12、-.2-24.i386.rpmoracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5debug-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5-debuginfo-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5xen-2.0.5-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpmoracleasm-support-2.1.3-1.el5.x86_6

13、4.rpm.配置SSH 用ORACLE用戶執(zhí)行分別在2臺(tái)機(jī)上運(yùn)行mkdir /.sshchmod 700 /.sshcd .ssh/usr/bin/ssh-keygen -t rsa (回車就OK)#/usr/bin/ssh-keygen -t dsa (回車就OK) 這可以不做在RAC1 機(jī)上運(yùn)行ssh name1 cat /home/oracle/.ssh/id_rsa.pub>>authorized_keys#ssh name1 cat /home/oracle/.ssh/id_dsa.pub>>authorized_keys這可以不做ssh name2 cat

14、/home/oracle/.ssh/id_rsa.pub>>authorized_keys#ssh name2 cat /home/oracle/.ssh/id_dsa.pub>>authorized_keys這可以不做把a(bǔ)uthorized_keys cp 到RAC2中/home/oracle/.ssh/scp authorized_keys rac2:/home/oracle/.ssh/(分別在2臺(tái)機(jī)上運(yùn)行)chmod 600 authorized_keysssh rac2 dateexec /usr/bin/ssh-agent $SHELL /usr/bin/ss

15、h-add 確定ForwardX11置為no 編輯或創(chuàng)建 $ vi oracle/.ssh/config 內(nèi)容如下： Host * ForwardX11 no 8.Ntpdate . IP 時(shí)間同步Vi /etc/ntp.conf服務(wù)端restrict mask nomodifyserver fudge stratum 10driftfile /var/lib/ntp/driftbroadcastdelay 0.008authenticate no keys /etc/ntp/keys運(yùn)行 chkconfig ntp

16、 on /etc/init.d/ntpd restart客務(wù)端restrict mask nomodifyserver Server . ipfudge stratum 10driftfile /var/lib/ntp/driftbroadcastdelay 0.008authenticate no keys /etc/ntp/keys運(yùn)行ntpdate db1出現(xiàn)信息調(diào)整的信息表示成功，一般要5分鐘走左右如果是把內(nèi)核時(shí)間更新到當(dāng)前時(shí)間，就用下面的命令：hwclock -hctosys 檢查ntp的版本，如果你使用的

17、是ntp4.2（包括4.2）之后的版本，在restrict的定義中使用了notrust的話，會(huì)導(dǎo)致以上錯(cuò)誤。使用以下命令檢查ntp的版本：ntpd -c version 如何去掉notrust？9.磁盤分區(qū)10.配置裸設(shè)備vi /etc/udev/rules.d/60-raw.rulesACTION="add",KERNEL="sddlmac1",RUN+="/bin/raw /dev/raw/raw1 %N"ACTION="add",KERNEL="sddlmac2",RUN+="/

18、bin/raw /dev/raw/raw2 %N"ACTION="add",KERNEL="sddlmac5",RUN+="/bin/raw /dev/raw/raw3 %N"ACTION="add",KERNEL="sddlmac6",RUN+="/bin/raw /dev/raw/raw4 %N"ACTION="add",KERNEL="sddlmac7",RUN+="/bin/raw /dev/raw/raw5

19、 %N"KERNEL="raw1-5", OWNER="oracle", GROUP="oinstall", MODE="640"用RAW -QA 查看裸設(shè)備情況11.配置asm注意：必須以root 身份進(jìn)行首先在node1 執(zhí)行：rootnode1 # /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Orac

20、le ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets (''). Hitting <ENTER> without typing ananswer will keep that current value. Ctrl-C will abort.Default user to

21、own the driver interface : oracleDefault group to own the driver interface : dbaStart Oracle ASM library driver on boot (y/n) n: yFix permissions of Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: OK Loading module "oracleasm": OK Mounting ASMlib driver

22、filesystem: OK Scanning system for ASM disks: OK 提示：如果本步執(zhí)行出錯(cuò)(可能出錯(cuò)機(jī)率最高的是在Scanning system for ASM)，不妨將轉(zhuǎn)換一下命令行三思筆記-手把手教你用VMware 在linux 下安裝Oracle10g RAC QQ：5454589 君三思群：59666289的執(zhí)行方式，改成:rootnode1 # sh /etc/init.d/oracleasm configure有可能解決你的問題！然后切換至node2 執(zhí)行rootnode2 # /etc/init.d/oracleasm configureConfig

23、uring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets (''). Hitting <ENTER>

24、; without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface : oracleDefault group to own the driver interface : dbaStart Oracle ASM library driver on boot (y/n) n: yFix permissions of Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library

25、 driver configuration: OK Loading module "oracleasm": OK Mounting ASMlib driver filesystem: OK Scanning system for ASM disks: OK 再切換回node1 執(zhí)行rootnode1 # /etc/init.d/oracleasm createdisk VOL1 /dev/sdd1Marking disk "/dev/sdd1" as an ASM disk: OK rootnode1 # /etc/init.d/oracleasm createdisk VOL2 /dev/sde1Marking disk "/dev/sde1" as an ASM disk: OK rootnode1 linux-patch# /etc/init.d/oracleasm scandisksScanning system for ASM disks: OK 查看一下當(dāng)前的磁盤組：Scanning s