我们拒绝平庸,拒绝随波逐流,拒绝墨守成规,让梦想不再流浪。

配置双机has

上一篇 / 下一篇  2014-05-27 17:01:13 / 个人分类:总结

  1. 主机上配置
  2. Oracle用户登录主节点。
  3. 添加监听器。

    .T8DJ![+JAu0

    wA"jF(Y0Eo0$cd $ORACLE_HOME/network/admin/51Testing软件测试网*Gv;{!l3n3a frz

    ^%H&KHW Q9Y}'y0$vi listener.ora

    4Y4UO;Ad4S[0

    J,Ou4I"Wl)~f0“listener.ora”文件中修改如下内容:

    ] { BE.x J'P0
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
          (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
        )
      )
    
    ADR_BASE_LISTENER = /home/oracrs/base
    
    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON

    $x$zaM#hw)R0floatIP”修改为双机浮动IP地址。51Testing软件测试网 r Ld'BX_0yw

    )G0h/|3aA$c2dt \ax ^0

    .x[1X+{/Ga Z0
  4. 修改tnsnames.ora。51Testing软件测试网'E}!tAO3i

    $?B [8x6T;\"^w0$cd $ORACLE_HOME/network/admin/51Testing软件测试网zn"L6Qm F4S#A

    51Testing软件测试网gO S7^5@

    $vi tnsnames.ora51Testing软件测试网t#i5JUE

    e*Ps$cA v~0“tnsnames.ora”文件中修改如下内容:

    f,wBE4u"F)F{!T0
    MMSGDB =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = mmsgdb)
          )
        )
    51Testing软件测试网DGE\q x7X G@

    floatIP”修改为双机浮动IP地址。

    qc'JqBb)V0

    %[Y ch~+[^;q x0

    zX K&n+Z0
  5. 以grid用户登录主节点。
    1. 执行如下命令,查看HAS状态。
    2. $crsctl stat res -t
    3. --------------------------------------------
      NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
      --------------------------------------------------------------------------------
      Local Resources
      --------------------------------------------------------------------------------
      ora.LISTENER.lsnr
                     ONLINE  ONLINE       mmsg01                                       
      ora.asm
                     ONLINE  ONLINE       mmsg01                   Started             
      ora.ons
                     OFFLINE OFFLINE      mmsg01                                       
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.cssd
            1        ONLINE  ONLINE       mmsg01                                       
      ora.diskmon
            1        OFFLINE OFFLINE                                                   
      ora.evmd
            1        ONLINE  ONLINE       mmsg01
    4. 51Testing软件测试网s'A!Mb_2vD

      如果显示“ora.LISTENER.lsnr”,表示默认监听已经添加,则不需要继续添加默认监听。

      #SaF`#hJo k;O0
    • w2[jUD/}%G-^0如果没有显示“ora.LISTENER.lsnr”,表示默认监听未添加,请按照6继续添加默认监听。

      q5ir r#I#Q/k0
    • 51Testing软件测试网!y7S2O;R4je+b,a Ub

      如果显示“ora.DG_ORA.dg”,表示DG_ORA已经创建成功,则不需要添加ASM实例。51Testing软件测试网$tw/TyP6a"O

    • 51Testing软件测试网4yh y3jD p&m

      如果没有显示“ora.DG_ORA.dg”,表示DG_ORA未创建成功,请按照6添加ASM实例。51Testing软件测试网]L`.yj@IH)Rt

    /F0K%w M*Gl2G#yAY6AU0

    *iI!_(}D^qU0
    1. 添加默认监听和ASM实例。
    2. 检查空间大小。

      /Qi#Zz2NM ^0%/home/oracrs/product/11gR2/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true "CLUSTER_NODES={}" ORACLE_HOME=/home/oracrs/product/11gR2/grid

      ^PfSv C5n Z0

      Bgw K{+wp%Pj0屏幕显示如下所示:

      5}U:`.A%\YD0
      Starting Oracle Universal Installer...Checking swap space: must be greater than 500 MB.   Actual 16386 MB    PassedThe inventory pointer is located at /etc/oraInst.loc
      The inventory is located at /opt/oraInventory
    3. 51Testing软件测试网]P8DKm*f'P~"~

      执行如下命令,添加默认监听。

      @HiP)E0

      *F&Sj6u'kv7\~.p0$netca -silent -responsefile /home/oracrs/product/11gR2/grid/network/install/netca_typ.rsp

      raO:R+d TA051Testing软件测试网)~?oq_+mU:H

      添加成功则显示如下信息:

      It H;[L0
      Parsing command line arguments:
          Parameter "silent" = true
          Parameter "responsefile" = /home/oracrs/product/11gR2/grid/network/install/netca_typ.rsp
      Done parsing command line arguments.
      Oracle Net Services Configuration:
      Profile configuration complete.
      Listener "LISTENER"already exists.
      Oracle Net Services configuration successful. The exit code is 0
    4. 51Testing软件测试网Uqp2L"v"J

      执行如下命令,添加ASM实例。

      $v~1Q7];uY&}A+D0
      说明:
      在添加ASM实例前,请以root用户登录到主节点,执行sh /etc/init.d/after.local
      51Testing软件测试网4E:U e6OL

      $asmca -silent -oui_internal -sysAsmPassword AsmSys123 -asmsnmpPassword AsmSnmp123 -configureASM -diskString '/dev/diskgroup' -diskGroupName dg_ora -diskList /dev/diskgroup/dg_ora -redundancy EXTERNAL51Testing软件测试网%~1W p W B2R

      51Testing软件测试网#J _4[.gC4T

      屏幕显示如下信息表示ASM实例创建成功。51Testing软件测试网gH3r0A-c \

      Disk Group dg_ora created successfully.

      J6Z,k k9y#jT6@0$export asmspfile=`asmcmd spget`51Testing软件测试网'E X,`Z0l

      51Testing软件测试网y^$S2JGT

      $asmcmd spset $ORACLE_HOME/dbs/spfile+ASM.ora

      -nCW+T:xCDduW0

    V+b0TrB%M,az051Testing软件测试网-y OF$m]4^O&@4U

    1. Z]p9_x[,X)xmo0执行如下命令,检查HAS状态。51Testing软件测试网8`7U*d7r[c-k-\

      51Testing软件测试网4_e2fn5TOel

      51Testing软件测试网FA6V1i&aGi({%\ s

      $crsctl stat res -t51Testing软件测试网|4l!h9uj

      g6wT-U#C_t} [0屏幕显示如下信息:51Testing软件测试网J7uQD+^GN ]

      --------------------------------------------------------------------------------
      NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
      --------------------------------------------------------------------------------
      Local Resources
      备机上配置:
    2. 以Oracle用户登录备节点。
    3. 添加监听器。51Testing软件测试网2iMTK8kJ e[

      )m&IP7_m1T.XO0$cd $ORACLE_HOME/network/admin/

      D"x\0V;`0

      6jS d7dhl[d~0$vi listener.ora

      ~7e%C&?6fkbtp0

      2i'jQ8B fC+O2wXl0“listener.ora”文件中修改如下内容:

      5^^ IoYq)\0
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
            (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
          )
        )
      
      ADR_BASE_LISTENER = /home/oracrs/base
      
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
      51Testing软件测试网T)?"r8aH|M7GL

      floatIP”修改为双机浮动IP地址。51Testing软件测试网y+l#o?!P7g2s

      51Testing软件测试网f P7}\C da4Rq

      51Testing软件测试网\f5k1K5IBu V

    4. 修改tnsnames.ora。51Testing软件测试网 QM!z8S)tW!s#z2}

      lQ}.e"_|6`N,OR;|0$cd $ORACLE_HOME/network/admin/

      i,kS~(H051Testing软件测试网"h{)VhS

      $vi tnsnames.ora51Testing软件测试网,Bu7b(ptkq

      51Testing软件测试网7]6Kx4G/i0kYm

      “tnsnames.ora”文件中修改如下内容:

      !Qg/n ` u|0mr0
      MMSGDB =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
            (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = mmsgdb)
            )
          )

      2EM#r7R}J%j0floatIP”修改为双机浮动IP地址。51Testing软件测试网[2AzJ#t[/g3\ E-P

      51Testing软件测试网|;F1i F ODi

      51Testing软件测试网fNP@-}t4d^6^[

    5. 以grid用户登录备节点。
    6. 在备节点上执行如下命令检查空间大小。51Testing软件测试网%yl8c w A/vw&j

      51Testing软件测试网l7@@ d)kD

      $/home/oracrs/product/11gR2/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true "CLUSTER_NODES={}" ORACLE_HOME=/home/oracrs/product/11gR2/grid51Testing软件测试网,Qm1v%sW

      uKjF,Uu NOTo0屏幕显示如下信息:

      $m&m8Ek"_;A{0
      Starting Oracle Universal Installer...
      
      Checking swap space: must be greater than 500 MB.   Actual 16386 MB    Passed
      The inventory pointer is located at /etc/oraInst.loc
      The inventory is located at /opt/oraInventory
      51Testing软件测试网-B8n"i3[#^%Gu1N

      51Testing软件测试网wPI-O-V\rVH2M0l

    7. 启动HAS,查看HAS状态。51Testing软件测试网 Q?*WW s+z hmy

      i5|+D(\5~0$crsctl modify resource "ora.cssd" -attr "AUTO_START=1"

      \5P1X'y0~i0

      9Uk.X$F3QgGD0$crsctl stop has -f51Testing软件测试网a+\#Le+s

      `)hSkW3Hj,r+{/E0$crsctl start has

      /oh8jX,t,}+[0
      屏幕显示如下信息时,表示HAS启动成功。
      CRS-4123: Oracle High Availability Services has been started.
      51Testing软件测试网*P7[ I~%}&?(a*x

      $crsctl stat res -t

      9e2~nZ]1rH051Testing软件测试网p8x1`F2m7NlIj

      屏幕显示如下信息:

      g?+` u8d@SJ(G0
      --------------------------------------------------------------------------------
      NAME           TARGET  STATE        SERVER                   STATE_DETAILS
      --------------------------------------------------------------------------------
      Local Resources
      --------------------------------------------------------------------------------ora.DG_ORA.dgONLINE  ONLINE       mmsg02
      ora.LISTENER.lsnr
                     ONLINE  ONLINE       mmsg02
      ora.asm
                     ONLINE  ONLINE       mmsg02                  Started
      ora.ons
                     OFFLINE OFFLINE      mmsg02
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.cssd
            1        ONLINE  ONLINE       mmsg02
      ora.diskmon
            1        OFFLINE OFFLINE
      ora.evmd
            1        ONLINE  ONLINE       mmsg02

      6H+y\G9j#y#@Dr0如果“ora.DG_ORA.dg”没有显示,请执行如下操作添加相应的资源。51Testing软件测试网"N-g-x4p|!j%C

      1. 以root用户登录备节点。
      2. 51Testing软件测试网o[*n2n8sM*^ {

        执行如下命令,查看“DG_ORA”对应的scsi信息。

        /Thm#|Hc051Testing软件测试网$^,^ uh/r(pL4V"f

        #more /etc/init.d/after.local51Testing软件测试网'W-YO%uii

        51Testing软件测试网pl4pHH LU

        显示类似如下信息时,表示“DG_ORA”对应的scsi信息为“scsi-360022a110003135eae8c38ec00000001”。51Testing软件测试网*?.A:{,I1@

        mkdir -p /dev/diskgroup
        chmod 770 /dev/diskgroup
        chown grid:oinstall /dev/diskgroup
        
        ln -f -s /dev/disk/by-id/scsi-360022a110003135eae8c38ec00000001/dev/diskgroup/dg_ora
        chmod 660 /dev/diskgroup/dg_*
        chown -R grid:oinstall /dev/diskgroup/dg_*
      3. L AwZa0执行如下命令,查看“DG_ORA”scsi对应的物理分区。51Testing软件测试网/r6{5}'Yh4~,fN

        7|'N y;qQe Z0#ls -lt /dev/disk/by-id/scsi*

        T5~h*}0mv[d051Testing软件测试网 Xv.Y LU;lr

        显示类似如下信息时,表示“scsi-360022a110003135eae8c38ec00000001”对应的物理分区为“sdb”。

        aY7aE*L0
        lrwxrwxrwx 1 root root  9 Mar 30 04:07 /dev/disk/by-id/scsi-360022a110003135e8f4e665d00000002 -> ../../sdc
        lrwxrwxrwx 1 root root  9 Mar 30 04:07 /dev/disk/by-id/scsi-360022a110003135eae8c38ec00000001-> ../../sdb
        lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part1 -> ../../sda1
        lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part2 -> ../../sda2
        lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part6 -> ../../sda6
        lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part7 -> ../../sda7
        lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part5 -> ../../sda5
        lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part3 -> ../../sda3
        lrwxrwxrwx 1 root root  9 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07 -> ../../sda
      4. x!wmei%c0更改物理分区的属主。

        1Z M_s"@"HM051Testing软件测试网1YDGjDf.rHR^!J

        #chown -R grid:oinstall /dev/sdb

        2Fs,K [;| w0
      5. 以grid用户登录备节点,设置DISPLAY环境变量,具体操作请参见设置DISPLAY环境变量
      6. 执行asmca命令,启动ASMCA安装配置界面。

    TAG:

     

    评分:0

    我来说两句

    日历

    « 2024-06-02  
          1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30      

    数据统计

    • 访问量: 111531
    • 日志数: 89
    • 图片数: 1
    • 文件数: 15
    • 建立时间: 2013-03-01
    • 更新时间: 2018-08-23

    RSS订阅

    Open Toolbar