oracle g grid安裝指南

1、oracle 11g grid安裝指南 軟件環(huán)境l        操作系統(tǒng)：Redhat linux 6.2l        數(shù)據(jù)庫和集群件版本:ORACLE 11204l        用戶組和文件系統(tǒng)配置用戶組和文件系統(tǒng)配置     軟件組件用戶主組輔助組主目錄軟件目錄Gri

2、d Infragridoinstalldba/oracle/grid/oracle/grid檢查必要的軟件包binutils-2.20.51.0.2-5.11.el6 (x86_64)compat-libstdc+-33-3.2.3-69.el6 (x86_64)glibc-2.12-1.7.el6 (x86_64)ksh-*.el6 (x86_64)    <= any version of ksh is acceptablelibaio-0.3.107-10.el6 (x86_64)libgcc-4.4.4-13.el6 (x86_64)lib

3、stdc+-4.4.4-13.el6 (x86_64)make-3.81-19.el6 (x86_64)compat-libcap1-1.10-1 (x86_64)gcc-4.4.4-13.el6 (x86_64)gcc-c+-4.4.4-13.el6 (x86_64)glibc-devel-2.12-1.7.el6 (x86_64)libaio-devel-0.3.107-10.el6 (x86_64)libstdc+-devel-4.4.4-13.el6 (x86_64)sysstat-9.0.4-11.el6 (x86_64)compat-libstdc+-33-3.2.3-69.el6

4、 (i686)glibc-2.12-1.7.el6 (i686)glibc-devel-2.12-1.7.el6 (i686)libaio-0.3.107-10.el6 (i686)libaio-devel-0.3.107-10.el6 (i686)libgcc-4.4.4-13.el6 (i686)libstdc+-4.4.4-13.el6 (i686)libstdc+-devel-4.4.4-13.el6 (i686)elfutils-libelf-devel-0.97網(wǎng)絡(luò)需求（兩節(jié)點(diǎn)均要執(zhí)行）l        

5、;每個(gè)節(jié)點(diǎn)一個(gè)public IPl        每個(gè)節(jié)點(diǎn)一個(gè)public VIPl        每個(gè)節(jié)點(diǎn)一個(gè)private IPl        一個(gè)用于集群的SCAN名稱和一個(gè)和public IP同網(wǎng)段的IPpublic IP,VIP和private IP,scan vip寫入/etc/hosts文件192.168.56.101  

6、     node1192.168.56.103       node1-vip10.10.10.17       node1-priv192.168.56.105       node-scan192.168.56.102      node2192.168.56.104

7、60;      node2-vip10.10.10.18       node2-priv基本參數(shù)設(shè)置（兩節(jié)點(diǎn)均要執(zhí)行）編輯/etc/sysctl.conf 添加如下內(nèi)容： vi /etc/sysctl.confkernel.shmall = 8388608kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6553600fs.aio-max-nr = 1048576n

8、et.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144mem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576/sbin/sysctl p編輯/etc/pam.d/login 添加如下內(nèi)容：vi /etc/pam.d/loginsession    required     pam_limits.so編輯vi /etc/

9、profile添加如下內(nèi)容：if /$USER = "oracle" | /$USER = "grid" ; then    if /$SHELL = "/bin/ksh" ; then        ulimit -p 16384        ulimit -n 65536    else

10、60;       ulimit -u 16384 -n 65536    fi    umask 022fi創(chuàng)建用戶,組（兩節(jié)點(diǎn)均要執(zhí)行）要求        創(chuàng)建GRID用戶        創(chuàng)建oinstall組DBA組  創(chuàng)建命令   

11、     groupadd -g 501 oinstall        groupadd -g 502 dba       useradd -u 501 -g oinstall -G dba grid        passwd grid用戶shell限制（兩節(jié)點(diǎn)均要執(zhí)行）編輯/etc/security/limits

12、.conf 添加如下內(nèi)容： vi /etc/security/limits.confgrid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid ssh信任關(guān)系設(shè)置設(shè)置前先修改ssh配置文件參數(shù)：grid用戶：node1:grid node1$ ssh-keygen -t rsa        /一路回車grid node1$ ssh-keygen -t dsagrid node1

13、$ cd .sshgrid node1.ssh$ cat *.pub > authorized_keys   node2:grid node2$ ssh-keygen -t rsa        /一路回車grid node2$ ssh-keygen -t dsanode1:gridnode1 .ssh$ scp authorized_keys node2:/home/grid/.ssh/       /選ye

14、s  輸入busrac2 grid用戶密碼node2:grid node2$ cd .sshgridnode2 .ssh$ cat *.pub >> authorized_keysgridnode2 .ssh$ scp authorized_keys node1:/home/grid/.ssh/  驗(yàn)證ssh用戶等效性node1:第一次選擇yesgrid node1 $ ssh node1 dategrid node1 $ ssh node2 dategrid node1 $ ssh node1-priv dategrid node1 $ s

15、sh node2-priv date切換至node 2 執(zhí)行  grid node2 $ ssh node1 dategrid node2 $ ssh node2 dategrid node2 $ ssh node1-priv dategrid node2 $ ssh node2-priv date/如果不需要輸入密碼，則配置成功環(huán)境變量設(shè)置node1  grid用戶：export ORACLE_BASE=/oracle/baseexport ORACLE_HOME=/oracle/gridexport ORACLE_SID=+ASM1expo

16、rt PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATHnode2  grid用戶：export ORACLE_BASE=/oracle/baseexport ORACLE_HOME=/oracle/gridexport ORACLE_SID=+ASM2export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH創(chuàng)建軟件安裝目錄# mkdir -p /oracle# chown -R oracle:oinstall /oracle# chmod -R 775 /oracle安裝Gri

17、d Infrastructurep13390677_112040_Linux-x86-64_3of7.zipunzip p13390677_112040_Linux-x86-64_3of7.zipsu  grid  設(shè)置DISPLAY環(huán)境變量$ export LANG=en_US$ ./runInstaller安裝截圖出來下面安裝界面，選擇最下面的Skip software updates,然后選next選擇第一個(gè)安裝和配置集群環(huán)境，next選擇第二個(gè)高級(jí)安裝，next選上添加簡體中文，next此處集群名自己取，SCAN名需要和/etc/hosts中的s

18、can ip別名一致，端口默認(rèn)，不選GNS，next添加busrac2節(jié)點(diǎn)，并進(jìn)行ssh測試，next配置網(wǎng)絡(luò)接口:選對(duì)網(wǎng)卡類型，next存儲(chǔ)選擇:選擇ASM，next建立OCRVOTE盤，選擇3塊2G的盤 next設(shè)置密碼：next安裝路徑指定:選擇ORACLE_BASE和ORACLE_HOME，根據(jù)自己設(shè)置來，建議ORACLE_BASE不和RDBMS軟件ORACLE_BASE不是同一個(gè)，方便管理檢測結(jié)果:· 查看檢測結(jié)果，如果fixable為yes則可以通過按fix&check again,執(zhí)行腳本來修復(fù)（不保證一定可以修復(fù)），如果不能，則只能手工修復(fù)，經(jīng)檢查，

19、可以忽略，選擇ignore all繼續(xù)安裝以root身份執(zhí)行腳本:root用戶執(zhí)行兩個(gè)腳本，一個(gè)節(jié)點(diǎn)執(zhí)行完后再執(zhí)行第二個(gè)節(jié)點(diǎn)執(zhí)行腳本。注意:l        root腳本在所有節(jié)點(diǎn)一定要成功完成l        如果root.sh執(zhí)行失敗Ø        切換到root,在失敗的節(jié)點(diǎn)執(zhí)行"$GRID_HOME/crs/install/ro

20、otcrs.pl -verbose -deconfig -force".注意不能是最后一個(gè)節(jié)點(diǎn)Ø        如果是deconfig整個(gè)集群,那么在執(zhí)行完第一步后,在最后一個(gè)節(jié)點(diǎn)運(yùn)行"$GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode".這個(gè)命令會(huì)清空OCR VOTE安裝完成：rootnode1 etc# /oracle/oraInventory/orainstRoot.shC

21、hanging permissions of /oracle/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/oraInventory to oinstall.The execution of the script is complete.rootnode1 etc# /oracle/grid/root.shPerforming root user operation for O

22、racle 11gThe following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=  /oracle/gridEnter the full pathname of the local bin directory: /usr/local/bin:   Copying dbhome to /usr/local/bin .   Copyi

23、ng oraenv to /usr/local/bin .   Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root acti

24、ons will be performed.Using configuration parameter file: /oracle/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerOLR initialization - successful  root wallet  root wallet cert  root ce

25、rt export  peer wallet  profile reader wallet  pa wallet  peer wallet keys  pa wallet keys  peer cert request  pa cert request  peer cert  pa cert  peer root cert TP  profile reader root cer

26、t TP  pa root cert TP  peer pa cert TP  pa peer cert TP  profile reader pa cert TP  profile reader peer cert TP  peer user cert  pa user certAdding Clusterware entries to upstartCRS-2672: Attempting to start 'ora.mdnsd' on

27、 'node1'CRS-2676: Start of 'ora.mdnsd' on 'node1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on 'node1'CRS-2676: Start of 'ora.gpnpd' on 'node1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on 'node1'CRS-2672

28、: Attempting to start 'ora.gipcd' on 'node1'CRS-2676: Start of 'ora.gipcd' on 'node1' succeededCRS-2676: Start of 'ora.cssdmonitor' on 'node1' succeededCRS-2672: Attempting to start 'ora.cssd' on 'node1'CRS-2672: Attempting to start 

29、9;ora.diskmon' on 'node1'CRS-2676: Start of 'ora.diskmon' on 'node1' succeededCRS-2676: Start of 'ora.cssd' on 'node1' succeededASM created and started successfully.Disk Group OCRVOTE created successfully.clscfg: -install mode specifiedSuccessfully accumul

30、ated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'.Operation successful.CRS-4256: Updating the profileSuccessful addition of voting disk 540fb05eb3844feabfe3959578c282f1.Successful addition of voting disk 5608478ff1cd4f1cbf70f9d01ea120a2.Successful addition of

31、voting disk 108c03b12f8f4f43bf047c41c61e360c.Successfully replaced voting disk group with +OCRVOTE.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced#  STATE    File Universal Id           

32、     File Name Disk group-  -    -                - - 1. ONLINE   540fb05eb3844feabfe3959578c282f1 (/dev/asm-diskb) OCRVOTE 2. ONLINE &

33、#160; 5608478ff1cd4f1cbf70f9d01ea120a2 (/dev/asm-diskc) OCRVOTE 3. ONLINE   108c03b12f8f4f43bf047c41c61e360c (/dev/asm-diskd) OCRVOTELocated 3 voting disk(s).CRS-2672: Attempting to start 'ora.asm' on 'node1'CRS-2676: Start of 'ora.asm' on 'node1&

34、#39; succeededCRS-2672: Attempting to start 'ora.OCRVOTE.dg' on 'node1'CRS-2676: Start of 'ora.OCRVOTE.dg' on 'node1' succeededConfigure Oracle Grid Infrastructure for a Cluster . succeededrootnode2 etc# /oracle/oraInventory/orainstRoot.shChanging permissions of /oracle/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/oraInventory to oinstall.The execution of the script is complete.rootnode2 etc# /oracle/grid/root.shPerforming root u