Oracle 11g RAC + DG安装详解--02

二、安装Grid Infrastructure

1. 上传Grid Infrastructure 和oracle11g 安装文件

2. 安装vncserver

节点1

[root@TRAC1 rpm]# rpm -ivh tigervnc-server1.1.0-24.el6.x86_64.rpm

warning: tigervnc-server-1.1.0-24.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY

Preparing...                ########################################### [100%]

   1:tigervnc-server        ########################################### [100%]

[root@TRAC1 rpm]#

3. 解压缩grid 软件

节点1

[root@TRAC1 software]# unzip p13390677_112040_Linux-x86-64_3of7.zip

修改cvu_config

[root@TRAC1 grid]# sed -i 's/CV_ASSUME_DISTID=OEL4/CV_ASSUME_DISTID=OEL6/' /home/software/grid/stage/cvu/cv/admin/cvu_config

节点2

[root@TRAC2 software]# unzip p13390677_112040_Linux-x86-64_3of7.zip

修改cvu_config

[root@TRAC2 grid]# sed -i 's/CV_ASSUME_DISTID=OEL4/CV_ASSUME_DISTID=OEL6/' /home/software/grid/stage/cvu/cv/admin/cvu_config

4. 安装cvuqdisk-1.0.9-1.rpm

cd /home/software/grid/rpm/

rpm -ivh cvuqdisk-1.0.9-1.rpm

5. 准备安装Grid Infrastructure

节点1 启动vncserver

[root@TRAC1 grid]# su - grid

[grid@TRAC1 ~]$ vncserver

You will require a password to access your desktops.

Password:

Verify:

xauth:  file /home/grid/.Xauthority does not exist

New 'TRAC1:1 (grid)' desktop is TRAC1:1

Creating default startup script /home/grid/.vnc/xstartup

Starting applications specified in /home/grid/.vnc/xstartup

Log file is /home/grid/.vnc/TRAC1:1.log

[grid@TRAC1 ~]$

6. 安装Grid Infrastructure

[grid@TRAC1 grid]$ cd /home/software/grid/

[grid@TRAC1 grid]$ ls

install  readme.html  response  rpm  runcluvfy.sh  runInstaller  sshsetup  stage  welcome.html

[grid@TRAC1 grid]$ ./runInstaller

6.1 第一个脚本root 运行：

节点1

[root@TRAC1 /]# /home/app/grid/oraInventory/orainstRoot.sh

Changing permissions of /home/app/grid/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/app/grid/oraInventory to oinstall.

The execution of the script is complete.

节点2

[root@TRAC2 ~]# /home/app/grid/oraInventory/orainstRoot.sh

Changing permissions of /home/app/grid/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/app/grid/oraInventory to oinstall.

The execution of the script is complete.

6.2 第二个脚本root 运行：

节点1

[root@TRAC1 /]# /home/app/grid/crs/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /home/app/grid/crs

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

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 script.

Now product-specific root actions will be performed.

Using configuration parameter file: /home/app/grid/crs/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - 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 Clusterware entries to upstart

CRS-2672: Attempting to start 'ora.mdnsd' on 'TRAC1'

CRS-2676: Start of 'ora.mdnsd' on 'TRAC1' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'TRAC1'

CRS-2676: Start of 'ora.gpnpd' on 'TRAC1' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'TRAC1'

CRS-2672: Attempting to start 'ora.gipcd' on 'TRAC1'

CRS-2676: Start of 'ora.cssdmonitor' on 'TRAC1' succeeded

CRS-2676: Start of 'ora.gipcd' on 'TRAC1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'TRAC1'

CRS-2672: Attempting to start 'ora.diskmon' on 'TRAC1'

CRS-2676: Start of 'ora.diskmon' on 'TRAC1' succeeded

CRS-2676: Start of 'ora.cssd' on 'TRAC1' succeeded

ASM created and started successfully.

Disk Group VOT created successfully.

clscfg: -install mode specified

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4256: Updating the profile

Successful addition of voting disk 2458bdc83f4e4f5cbfc3a4942a2096c3.

Successful addition of voting disk 72d50e2a50994f64bfbab3bfcfec8c08.

Successful addition of voting disk 04df90281c1f4f38bfd6a234f8d17244.

Successfully replaced voting disk group with +VOT.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   2458bdc83f4e4f5cbfc3a4942a2096c3 (/data/oradata/votdisk6) [VOT]

 2. ONLINE   72d50e2a50994f64bfbab3bfcfec8c08 (/data/oradata/votdisk5) [VOT]

 3. ONLINE   04df90281c1f4f38bfd6a234f8d17244 (/data/oradata/votdisk4) [VOT]

Located 3 voting disk(s).

CRS-2672: Attempting to start 'ora.asm' on 'TRAC1'

CRS-2676: Start of 'ora.asm' on 'TRAC1' succeeded

CRS-2672: Attempting to start 'ora.VOT.dg' on 'TRAC1'

CRS-2676: Start of 'ora.VOT.dg' on 'TRAC1' succeeded

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

节点2

[root@TRAC2 ~]# /home/app/grid/crs/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /home/app/grid/crs

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

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 script.

Now product-specific root actions will be performed.

Using configuration parameter file: /home/app/grid/crs/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - successful

Adding Clusterware entries to upstart

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node TRAC1, number 1, and is terminating

An active cluster was found during exclusive startup, restarting to join the cluster

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

 

7. 检查集群：

节点1

[grid@TRAC1 ~]$ crs_stat -t

Name           Type           Target    State     Host       

------------------------------------------------------------

ora....ER.lsnr ora....er.type ONLINE    ONLINE    TRAC1   

ora....N1.lsnr ora....er.type ONLINE    ONLINE    TRAC1   

ora.VOT.dg     ora....up.type ONLINE    ONLINE    TRAC1   

ora.asm        ora.asm.type   ONLINE    ONLINE    TRAC1   

ora.cvu        ora.cvu.type   ONLINE    ONLINE    TRAC1   

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....network ora....rk.type ONLINE    ONLINE    TRAC1   

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    TRAC1   

ora.ons        ora.ons.type   ONLINE    ONLINE    TRAC1   

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    TRAC1   

ora....SM1.asm application    ONLINE    ONLINE    TRAC1   

ora....C1.lsnr application    ONLINE    ONLINE    TRAC1   

ora....ac1.gsd application    OFFLINE   OFFLINE              

ora....ac1.ons application    ONLINE    ONLINE    TRAC1   

ora....ac1.vip ora....t1.type ONLINE    ONLINE    TRAC1   

ora....SM2.asm application    ONLINE    ONLINE    TRAC2   

ora....C2.lsnr application    ONLINE    ONLINE    TRAC2   

ora....ac2.gsd application    OFFLINE   OFFLINE              

ora....ac2.ons application    ONLINE    ONLINE    TRAC2   

ora....ac2.vip ora....t1.type ONLINE    ONLINE    TRAC2 

节点2

[grid@TRAC2 ~]$ crs_stat -t

Name           Type           Target    State     Host       

------------------------------------------------------------

ora....ER.lsnr ora....er.type ONLINE    ONLINE    TRAC1   

ora....N1.lsnr ora....er.type ONLINE    ONLINE    TRAC1   

ora.VOT.dg     ora....up.type ONLINE    ONLINE    TRAC1   

ora.asm        ora.asm.type   ONLINE    ONLINE    TRAC1   

ora.cvu        ora.cvu.type   ONLINE    ONLINE    TRAC1   

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              

ora....network ora....rk.type ONLINE    ONLINE    TRAC1   

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    TRAC1   

ora.ons        ora.ons.type   ONLINE    ONLINE    TRAC1   

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    TRAC1   

ora....SM1.asm application    ONLINE    ONLINE    TRAC1   

ora....C1.lsnr application    ONLINE    ONLINE    TRAC1   

ora....ac1.gsd application    OFFLINE   OFFLINE               

ora....ac1.ons application    ONLINE    ONLINE    TRAC1   

ora....ac1.vip ora....t1.type ONLINE    ONLINE    TRAC1   

ora....SM2.asm application    ONLINE    ONLINE    TRAC2   

ora....C2.lsnr application    ONLINE    ONLINE    TRAC2   

ora....ac2.gsd application    OFFLINE   OFFLINE              

ora....ac2.ons application    ONLINE    ONLINE    TRAC2   

ora....ac2.vip ora....t1.type ONLINE    ONLINE    TRAC2  

8. 修改asm_hbeat 参数

[grid@TRAC1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 19 12:09:47 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%asm_hb%' order by ksppinm;

hidden parameter

--------------------------------------------------------------------------------

value

--------------------------------------------------------------------------------

_asm_hbeatiowait

15

_asm_hbeatwaitquantum

2

SQL> alter system set "_asm_hbeatiowait"=120 sid='*' scope=spfile;

重启asm 和数据库