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

配置双机has

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

  1. 主机上配置
  2. Oracle用户登录主节点。
  3. 添加监听器。51Testing软件测试网 PS XpRF

    51Testing软件测试网.sO5D$c7vi-X

    $cd $ORACLE_HOME/network/admin/51Testing软件测试网9bRyQIUbZ y

    ~#z"|K9Xb2sFV0$vi listener.ora

    )Y]#f)K!n051Testing软件测试网0H%@9A-z&eJvJ

    “listener.ora”文件中修改如下内容:51Testing软件测试网4KtTi'ic

    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

    /lq{a v T0floatIP”修改为双机浮动IP地址。

    ]'pzTRY5dq"k0

    X{!Rg Avxni0

    c0_4M6e8q1g0
  4. 修改tnsnames.ora。

    4Md }d.Bc$] E:?051Testing软件测试网8\@/~nC-j8b\

    $cd $ORACLE_HOME/network/admin/51Testing软件测试网`/];O2\B\&W

    51Testing软件测试网eeL W8\6t

    $vi tnsnames.ora51Testing软件测试网;[ P!Nk(~g

    51Testing软件测试网cK!|9D F#^/C:w

    “tnsnames.ora”文件中修改如下内容:51Testing软件测试网 c:m |5Pm)Pu1G

    MMSGDB =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = mmsgdb)
          )
        )
    51Testing软件测试网D;t5P#NS FEZ9_

    floatIP”修改为双机浮动IP地址。51Testing软件测试网7KU4Y.X)~O

    `)U?m|%r[ N$pH051Testing软件测试网#W*z%Y9Y)}*fK*V/b

  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软件测试网)\O:G*y6H ^_

      如果显示“ora.LISTENER.lsnr”,表示默认监听已经添加,则不需要继续添加默认监听。51Testing软件测试网OW a7T#E6C8z(Q

    • 8y'J2JM2@X:z0如果没有显示“ora.LISTENER.lsnr”,表示默认监听未添加,请按照6继续添加默认监听。51Testing软件测试网K)Pz$`r&};n v3M

    • 51Testing软件测试网6H,t,WGh

      如果显示“ora.DG_ORA.dg”,表示DG_ORA已经创建成功,则不需要添加ASM实例。51Testing软件测试网@%JOpX+nQ

    • 51Testing软件测试网 @R"EP"}0n

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

      5r&S|$UK;v4g-c0

    H1Fs1T+|uy0

    "Mq6GZ],OI,Zv0
    1. 添加默认监听和ASM实例。
    2. 检查空间大小。

      ~8`v'r!nZ9y{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

      9voiu$Fr051Testing软件测试网#B*i)Q0Z,o3z4Rq

      屏幕显示如下所示:

      hW$s6|bI0
      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软件测试网P EH ~s9cor

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

      D+K3dS'LN0

      {~ }W.[ I7Y9c7l0$netca -silent -responsefile /home/oracrs/product/11gR2/grid/network/install/netca_typ.rsp

      'm3C!?:x O1uFD^w051Testing软件测试网jg9V O)H"l-g

      添加成功则显示如下信息:51Testing软件测试网@*D9cO3PnV RJ#l_

      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. 1oodT;am7w0执行如下命令,添加ASM实例。51Testing软件测试网VF$v\-` @|

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

      N_,e!Z+xI5VN R0$asmca -silent -oui_internal -sysAsmPassword AsmSys123 -asmsnmpPassword AsmSnmp123 -configureASM -diskString '/dev/diskgroup' -diskGroupName dg_ora -diskList /dev/diskgroup/dg_ora -redundancy EXTERNAL51Testing软件测试网J7Vn2Hn6a*|of EM

      ?a:S1gA0f0屏幕显示如下信息表示ASM实例创建成功。51Testing软件测试网y LS z2q

      Disk Group dg_ora created successfully.
      51Testing软件测试网U O,p`1f

      $export asmspfile=`asmcmd spget`51Testing软件测试网9xs VZ_&K.m ^BEm9B

      ;E `KZUO1z0$asmcmd spset $ORACLE_HOME/dbs/spfile+ASM.ora51Testing软件测试网!j"Y:z Ls/Avl

    qt0m1b_2X!w m051Testing软件测试网j!e$}y6Wi3Yr9m g

    1. 51Testing软件测试网TeVqL drL

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

      t1g%]2GV3aRR051Testing软件测试网3icT9JH v!h s

      51Testing软件测试网 j8ceJ&j7^

      $crsctl stat res -t51Testing软件测试网Vc2|$Bd9aJE,r;Q

      p8H2{H$C`-awi0屏幕显示如下信息:

      Vh~1AvR o0
      --------------------------------------------------------------------------------
      NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
      --------------------------------------------------------------------------------
      Local Resources
      备机上配置:
    2. 以Oracle用户登录备节点。
    3. 添加监听器。51Testing软件测试网3Gyb `)j1} gV

      8F)A5C#S6LW?MW0$cd $ORACLE_HOME/network/admin/51Testing软件测试网%a;CmZm3oKe

      &Z+I#e/o$Tg0$vi listener.ora51Testing软件测试网gt3a ~@|9G3I

      51Testing软件测试网E*]*q+g9r X e%?

      “listener.ora”文件中修改如下内容:51Testing软件测试网/ssm\$TG

      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软件测试网 W0}i2g0q4w3q

      floatIP”修改为双机浮动IP地址。51Testing软件测试网p8e2g'?m4\|R(Tm

      V#oRu[0\}q0

      3GX:V2S.X$R'Z0
    4. 修改tnsnames.ora。51Testing软件测试网t)|TEV~\?)n$y

      51Testing软件测试网gQN;SG4wY

      $cd $ORACLE_HOME/network/admin/51Testing软件测试网e+v@uG;]x#PO#t

      51Testing软件测试网,y"\1H$g"HP

      $vi tnsnames.ora

      $q5f7eg3I r051Testing软件测试网Bm*{QK{

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

      7L^2{ QE ymRR ['G(n0
      MMSGDB =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
            (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = mmsgdb)
            )
          )

      0s'C9e~0L8}Y(C0floatIP”修改为双机浮动IP地址。

      k5Iz%r^W~5k051Testing软件测试网"V9@6DN+l1je*?

      g&~xx5j|1V0
    5. 以grid用户登录备节点。
    6. 在备节点上执行如下命令检查空间大小。51Testing软件测试网yd(Zlo V

      ?jH%v/v[{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

      5?p;QZ W,{;qm^0

      r5W%R*I ~0屏幕显示如下信息:

      a Y\#`+{7U|e0
      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

      cu2LM"~ U.UP0

      9SH5g(E }R0
    7. 启动HAS,查看HAS状态。

      nP Lbs S+W`w"C P0

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

      k,O7l-_L0?S;~y051Testing软件测试网s S.g1`U H-`};`~

      $crsctl stop has -f

      8x+~'Ac"y&Z~051Testing软件测试网0N_F#U*aH ei]e

      $crsctl start has

      $n RDhD_1FO"J*CY0
      屏幕显示如下信息时,表示HAS启动成功。
      CRS-4123: Oracle High Availability Services has been started.

      ;Im/u6rO*Vc#z#k0$crsctl stat res -t

      ;D7E7L5v{[*n0

      ]6{:COq{QW0屏幕显示如下信息:51Testing软件测试网 {9E-ah'`nU5i;U&mv

      --------------------------------------------------------------------------------
      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软件测试网 J/K"J?#m r&L^'P

      如果“ora.DG_ORA.dg”没有显示,请执行如下操作添加相应的资源。51Testing软件测试网+ng `0J md,L ]

      1. 以root用户登录备节点。
      2. PnEh*E(j|K!e0执行如下命令,查看“DG_ORA”对应的scsi信息。

        w(~{`]F,Y J051Testing软件测试网8rQg%ko OXX

        #more /etc/init.d/after.local

        w6z:Oe-r$X"eVF0

        \2xu;wU"b*j_f0显示类似如下信息时,表示“DG_ORA”对应的scsi信息为“scsi-360022a110003135eae8c38ec00000001”。51Testing软件测试网8G:J{%h/F8i^%|

        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. 51Testing软件测试网3E+|@q)|)A

        执行如下命令,查看“DG_ORA”scsi对应的物理分区。51Testing软件测试网 y9S7]By4Z

        H*sl#]TWX$A0#ls -lt /dev/disk/by-id/scsi*

        q!F1C,j&|$k3fv9N/]^;k0

        n f*q.gu9^%^0显示类似如下信息时,表示“scsi-360022a110003135eae8c38ec00000001”对应的物理分区为“sdb”。

        n0DqPzEo;Y0
        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软件测试网{:xXL%mZzz2C

        更改物理分区的属主。

        `gFzDM051Testing软件测试网8bO q7H3}{y-L:n'p

        #chown -R grid:oinstall /dev/sdb51Testing软件测试网!P;c!HUZ#u.tj$N

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

    TAG:

     

    评分:0

    我来说两句

    日历

    « 2024-05-01  
       1234
    567891011
    12131415161718
    19202122232425
    262728293031 

    数据统计

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

    RSS订阅

    Open Toolbar