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

配置双机has

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

  1. 主机上配置
  2. Oracle用户登录主节点。
  3. 添加监听器。51Testing软件测试网 i'SF`|%v

    E\/G S%DL)@0$cd $ORACLE_HOME/network/admin/51Testing软件测试网D/XMb @

    R{7E1JI RX3a0$vi listener.ora

    kl1| `v/P0

    #cpU)zEAhv0“listener.ora”文件中修改如下内容:

    ,Kk}g$zUT]o0
    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软件测试网 m)iugu:xY-R n

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

    4SFe`KgX7Q8I)_1s1k0

    v:F9|#W+kSx~051Testing软件测试网0H/w4Kin

  4. 修改tnsnames.ora。

    Z"[ m;l#Kx-|pw!?0

    y_n%S6{)w8w,HMF0$cd $ORACLE_HOME/network/admin/51Testing软件测试网Ny8e+U%Q$\4[m$IfK[

    51Testing软件测试网#B%{)o)k _

    $vi tnsnames.ora

    }-P0w ]*t0HA2|0

    e]ZP'A6M v1yB0“tnsnames.ora”文件中修改如下内容:51Testing软件测试网)nS][#Bbo _c

    MMSGDB =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = mmsgdb)
          )
        )
    51Testing软件测试网GL uR3h

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

    /U&d7oJqN0

    P9Gwz~(|@ Y2E051Testing软件测试网P%PH,P*s]!t

  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. K/LSpzbALOA*}0如果显示“ora.LISTENER.lsnr”,表示默认监听已经添加,则不需要继续添加默认监听。51Testing软件测试网 vf o3h/xp ncVi

    • cp{?)v5j0如果没有显示“ora.LISTENER.lsnr”,表示默认监听未添加,请按照6继续添加默认监听。

      :k/a*yDu Lr8v&A wJ0
    • 51Testing软件测试网$cs0W(p)U`

      如果显示“ora.DG_ORA.dg”,表示DG_ORA已经创建成功,则不需要添加ASM实例。51Testing软件测试网 i)Wq V2~:GStOx&Oh

    • JO].^v7A~0如果没有显示“ora.DG_ORA.dg”,表示DG_ORA未创建成功,请按照6添加ASM实例。

      9F;y$[V^H8s.C0

    2Svm3l$xB?051Testing软件测试网&V#t7C"y-L(|0H0P4`L

    1. 添加默认监听和ASM实例。
    2. 检查空间大小。

      N vZ/AQ0%/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软件测试网h~'o4_:d)zo

      #uf4B'W7M\O@G }0屏幕显示如下所示:51Testing软件测试网q$A'o:k*ujF7sO

      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. yDj8P4iebzM0执行如下命令,添加默认监听。51Testing软件测试网:ZL.` u`+T

      51Testing软件测试网$ija$f8U5kf

      $netca -silent -responsefile /home/oracrs/product/11gR2/grid/network/install/netca_typ.rsp

      *K*s{k(hp [051Testing软件测试网/X0bE9zK#m

      添加成功则显示如下信息:51Testing软件测试网+_%B4w%PG9H&E ?

      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软件测试网 w@Y0\(NH?6S

      执行如下命令,添加ASM实例。51Testing软件测试网7C \:X;wlln%g

      说明:
      在添加ASM实例前,请以root用户登录到主节点,执行sh /etc/init.d/after.local

      #s8G]}}/|0D0$asmca -silent -oui_internal -sysAsmPassword AsmSys123 -asmsnmpPassword AsmSnmp123 -configureASM -diskString '/dev/diskgroup' -diskGroupName dg_ora -diskList /dev/diskgroup/dg_ora -redundancy EXTERNAL51Testing软件测试网 o6^s#wPh

      "B&RX A+p ke0屏幕显示如下信息表示ASM实例创建成功。51Testing软件测试网Ouy3}!CR

      Disk Group dg_ora created successfully.
      51Testing软件测试网j,h Q.hvm-PqR

      $export asmspfile=`asmcmd spget`51Testing软件测试网)R!AJ;WT L'y)ob

      ,K,M7t:AXB"YP+pF0$asmcmd spset $ORACLE_HOME/dbs/spfile+ASM.ora

      4@]5k.`1Y$bba5Q;J0
    51Testing软件测试网 `-} QM2kQ Q.m

    }8[KRA7C$}0
    1. 51Testing软件测试网+x;M }Qld%}R

      执行如下命令,检查HAS状态。

      ,hs3vJ V,n(XZ0

      @["Z _fHe0

      _G)xy-z?M y0$crsctl stat res -t

      _0Z-j:D C9v[%}8I051Testing软件测试网S1POdC

      屏幕显示如下信息:

      D7{ e/s%s&^9o)a0
      --------------------------------------------------------------------------------
      NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
      --------------------------------------------------------------------------------
      Local Resources
      备机上配置:
    2. 以Oracle用户登录备节点。
    3. 添加监听器。51Testing软件测试网D nS|6Qjd

      s\s:e;f\.^C0$cd $ORACLE_HOME/network/admin/

      E)g%dg0q0

      &XV I P&v!Y ~0$vi listener.ora51Testing软件测试网uvsf#_G H

      51Testing软件测试网'y'sB6M-|7H As

      “listener.ora”文件中修改如下内容:51Testing软件测试网)i J,O:M!eZdw

      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

      #r I-b/`xt0floatIP”修改为双机浮动IP地址。

      _0M |0a K_$F,B0

      DH@h8k~lb*_B0

      8nMK6RR0
    4. 修改tnsnames.ora。

      J#S/q3hf5Z,{o051Testing软件测试网Dc,V{MgYI

      $cd $ORACLE_HOME/network/admin/51Testing软件测试网w0w:Cu6r

      _0@t&x:|0$vi tnsnames.ora

      6O%@%v+jL9Q+}051Testing软件测试网3|(k9S-m(M6u,U'MT

      “tnsnames.ora”文件中修改如下内容:51Testing软件测试网7Anl g$G| sCf

      MMSGDB =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
            (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = mmsgdb)
            )
          )
      51Testing软件测试网p&r.k\ r2_

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

      2_1D*o%?^"E:J0

      C;]1B9A8})x051Testing软件测试网*a.w9{KoFIb#m:u

    5. 以grid用户登录备节点。
    6. 在备节点上执行如下命令检查空间大小。

      OXk @ubq051Testing软件测试网 d*n;tO.FT5Hya7F?

      $/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软件测试网!w @(W{@#z

      51Testing软件测试网~Pat h

      屏幕显示如下信息:51Testing软件测试网a!MnS.e w,~:kT!Zi

      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软件测试网h,ZzJ` rU

      51Testing软件测试网4]U!zX b'["Wc1o

    7. 启动HAS,查看HAS状态。51Testing软件测试网%G k0gH'j$Mj3f

      51Testing软件测试网'SfN+A.L F

      $crsctl modify resource "ora.cssd" -attr "AUTO_START=1"

      )M2n1CN,gXxOO051Testing软件测试网 ? d YF-K?1]'b

      $crsctl stop has -f

      5};^z^Pp0

      Q-e ~]x5d&sw0$crsctl start has

      8T!w4{]E'w0
      屏幕显示如下信息时,表示HAS启动成功。
      CRS-4123: Oracle High Availability Services has been started.
      51Testing软件测试网2DNk;vn3z q(DD)W

      $crsctl stat res -t

      -b;g @ B*f5b/S051Testing软件测试网M/d I_ E

      屏幕显示如下信息:51Testing软件测试网|3K2v;f^!LD

      --------------------------------------------------------------------------------
      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
      51Testing软件测试网8E3Ow~3j8\.vkS

      如果“ora.DG_ORA.dg”没有显示,请执行如下操作添加相应的资源。51Testing软件测试网^I7XP,}6`H ZH`\

      1. 以root用户登录备节点。
      2. 51Testing软件测试网9p2Z][-\!`@:`m5B

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

        (G~GEBM0

        \kr+C.\1Zua'v0#more /etc/init.d/after.local51Testing软件测试网C;nY:k8q~wv9Ev@

        51Testing软件测试网/D \N3L^

        显示类似如下信息时,表示“DG_ORA”对应的scsi信息为“scsi-360022a110003135eae8c38ec00000001”。

        #@ RT$V(U{B0
        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. (q4E7Jp;[ox IP0执行如下命令,查看“DG_ORA”scsi对应的物理分区。51Testing软件测试网q,`v"~+`_3i&Mz \;Z

        d)I sU!p%r qX0#ls -lt /dev/disk/by-id/scsi*

        c5QN6N{N~(J051Testing软件测试网?&J9Wk2a\2L

        显示类似如下信息时,表示“scsi-360022a110003135eae8c38ec00000001”对应的物理分区为“sdb”。51Testing软件测试网$bS/?0M1S v8]B,QF/u'O

        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. 51Testing软件测试网$b%u+OX ZLLj

        更改物理分区的属主。

        0ty&u'F T#Tl:U8B051Testing软件测试网_k8ez_[

        #chown -R grid:oinstall /dev/sdb51Testing软件测试网9hb$]u%C't_ D

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

    TAG:

     

    评分:0

    我来说两句

    日历

    « 2024-05-24  
       1234
    567891011
    12131415161718
    19202122232425
    262728293031 

    数据统计

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

    RSS订阅

    Open Toolbar