从0搭建RAC实验环境（三）

ゝ一世哀愁。 2022-08-12 01:14 182阅读 0赞

GRID、ORACLE安装篇

由于位置原因图片未上传，给一个连接[http://download.csdn.net/detail/u013820054/7952385][http_download.csdn.net_detail_u013820054_7952385] 这是从0搭建RAC实验环境的word文档。

两节点安装缺失包后安装grid

1、

![Image 1][]

2、

![Image 1][]

3、Cluster name  随便起   SCAN Name 必须和前面配置一样（不能带\_）

![Image 1][]

4、

![Image 1][]

5、

![Image 1][]

6、

![Image 1][]

7、这里很奇怪，没有看到我的raw4，后面解决

![Image 1][]

8、

![Image 1][]

9、

![Image 1][]

10、

![Image 1][]

11、已确保安装的ORACLE\_BASE目录是属于grid:oinstall

但安装时总是报：OUI-10182 The effective user ID does not match the owner of the file..........

解决方法：用root帐户在/etc下建立文件oraInst.loc,并写入以下内容:

inventory\_loc=/u01/app/oraInventory

inst\_group=oinstall

重新执行安装程序即可。

![Image 1][]

12、

![Image 1][]

13、按顺序，第一个运行完，在运行第二个

![Image 1][]

运行脚本必须都为succeeded。
    [root@rac1 raw]# /u01/app/11.2.0/grid/root.sh
    Running Oracle 11g root.sh script...
    
    The following environment variables are set as:
        ORACLE_OWNER= grid
        ORACLE_HOME=  /u01/app/11.2.0/grid
    
    Enter the full pathname of the local bin directory: [/usr/local/bin]: 
       Copying dbhome to /usr/local/bin ...
       Copying 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 by
    Database Configuration Assistant when a database is created
    Finished running generic part of root.sh script.
    Now product-specific root actions will be performed.
    2014-09-10 23:11:55: Parsing the host name
    2014-09-10 23:11:55: Checking for super user privileges
    2014-09-10 23:11:55: User has super user privileges
    Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
    Creating trace directory
    LOCAL ADD MODE 
    Creating OCR keys for user 'root', privgrp 'root'..
    Operation successful.
      root wallet
      root wallet cert
      root cert 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 cert 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 cert
    Adding daemon to inittab
    CRS-4123: Oracle High Availability Services has been started.
    ohasd is starting
    CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
    CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
    CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
    CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
    CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
    CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
    CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
    CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
    CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
    CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded
    
    ASM created and started successfully.
    
    DiskGroup OCR_VOTE created successfully.
    
    clscfg: -install mode specified
    Successfully accumulated necessary OCR keys.
    Creating OCR keys for user 'root', privgrp 'root'..
    Operation successful.
    CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
    CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded
    CRS-4256: Updating the profile
    Successful addition of voting disk 084fec0c7a4f4f2cbf63b61e46a73331.
    Successful addition of voting disk 748dc79ee4614f45bfc76e3fb78a58d9.
    Successful addition of voting disk 5ff80e77545e4f20bfd673774e560869.
    Successfully replaced voting disk group with +OCR_VOTE.
    CRS-4256: Updating the profile
    CRS-4266: Voting file(s) successfully replaced
    ##  STATE    File Universal Id                File Name Disk group
    --  -----    -----------------                --------- ---------
     1. ONLINE   084fec0c7a4f4f2cbf63b61e46a73331 (/dev/raw/raw3) [OCR_VOTE]
     2. ONLINE   748dc79ee4614f45bfc76e3fb78a58d9 (/dev/raw/raw2) [OCR_VOTE]
     3. ONLINE   5ff80e77545e4f20bfd673774e560869 (/dev/raw/raw1) [OCR_VOTE]
    Located 3 voting disk(s).
    CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
    CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
    CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
    CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
    CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
    CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
    CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'
    CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeeded
    CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
    CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
    CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
    CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
    CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
    CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
    CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
    CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
    CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
    CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
    CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
    CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
    CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
    CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
    CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
    CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.asm' on 'rac1'
    CRS-2676: Start of 'ora.asm' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
    CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.evmd' on 'rac1'
    CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.asm' on 'rac1'
    CRS-2676: Start of 'ora.asm' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.OCR_VOTE.dg' on 'rac1'
    CRS-2676: Start of 'ora.OCR_VOTE.dg' on 'rac1' succeeded
    CRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'
    CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeeded
    
    rac1     2014/09/10 23:19:19     /u01/app/11.2.0/grid/cdata/rac1/backup_20140910_231919.olr
    Preparing packages for installation...
    cvuqdisk-1.0.7-1
    Configure Oracle Grid Infrastructure for a Cluster ... succeeded
    Updating inventory properties for clusterware
    Starting Oracle Universal Installer...
    
    Checking swap space: must be greater than 500 MB.   Actual 2975 MB    Passed
    The inventory pointer is located at /etc/oraInst.loc
    The inventory is located at /u01/app/oraInventory
    'UpdateNodeList' was successful.
    [root@rac1 raw]#

14、

![Image 1][]

查看日志
    INFO: Checking Single Client Access Name (SCAN)...
    INFO: Checking name resolution setup for "rac-scan"...
    INFO: ERROR: 
    INFO: PRVF-4664 : Found inconsistent name resolution entries for SCAN name "rac-scan"
    INFO: ERROR:  
    INFO: PRVF-4657 : Name resolution setup check for "rac-scan" (IP address: 192.168.6.41) failed
    INFO: ERROR:  
    INFO: PRVF-4664 : Found inconsistent name resolution entries for SCAN name "rac-scan"
    INFO: Verification of SCAN VIP and Listener setup failed
    
    1：通过参考Metalink[ID 887471]文论：由于配置了/etc/hosts来解析SCAN，导致未走DNS来进行SCAN的解析，爆出此错误，可以考虑忽略掉，或者删除/etc/hosts文件中的SCAN解析部分，并且再次通过nslookup验证DNS的解析是否正常即可。
    2：[INS-20802] Oracle Net Configuration Assistant failed
    是oracle数据库的鼓掌，须要补丁p8670579_112010_LINUX
    
    检查crs
    [grid@rac2 ~]$ crs_stat -t
    Name           Type           Target    State     Host        
    ------------------------------------------------------------
    ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1        
    ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1        
    ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac1        
    ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
    ora.eons       ora.eons.type  ONLINE    ONLINE    rac1        
    ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
    ora....network ora....rk.type ONLINE    ONLINE    rac1        
    ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
    ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
    ora....SM1.asm application    ONLINE    ONLINE    rac1        
    ora....C1.lsnr application    ONLINE    ONLINE    rac1        
    ora.rac1.gsd   application    OFFLINE   OFFLINE               
    ora.rac1.ons   application    ONLINE    ONLINE    rac1        
    ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
    ora....SM2.asm application    ONLINE    ONLINE    rac2        
    ora....C2.lsnr application    ONLINE    ONLINE    rac2        
    ora.rac2.gsd   application    OFFLINE   OFFLINE               
    ora.rac2.ons   application    ONLINE    ONLINE    rac2        
    ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
    ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1        
    ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1

安装数据库软件

1、Only安装oracle 软件

2、

![Image 1][]

3、一路默认

DBCA建库

1、  dbca建库之前用grid用户执行asmca，新建数据文件磁盘组，点击create新建diskgroup，产生之后点击mount all

![Image 1][]

2、dbca   ---默认—默认—选择数据文件所在磁盘组

![Image 1][]

3、默认~~~

[http_download.csdn.net_detail_u013820054_7952385]: http://download.csdn.net/detail/u013820054/7952385
[Image 1]: