配置双机has

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

主机上配置
以Oracle用户登录主节点。
添加监听器。51Testing软件测试网sy@7SG
C7wA3l|Ac0$cd $ORACLE_HOME/network/admin/
?;~B pm'Q%On X0$vi listener.ora51Testing软件测试网#d;t Xb |1M
51Testing软件测试网._ ue2g]}v
在“listener.ora”文件中修改如下内容：
%\3x)f.E:f2X0
```
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
```
j3o'kM0[H b0“floatIP”修改为双机浮动IP地址。
"V mZH*L`~v!D0
i,eR6P:` _wsB0
[F,BtJeF0
修改tnsnames.ora。51Testing软件测试网9f9V]\1I
$cd $ORACLE_HOME/network/admin/
(jwI%L5zVp1S051Testing软件测试网4S]P-f9KMk7{
$vi tnsnames.ora
F3bD}/T d0在“tnsnames.ora”文件中修改如下内容：
I(`!tlt!X h"Y9G0
```
MMSGDB =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = mmsgdb)
      )
    )
```
51Testing软件测试网5JhStcu'h(nc:_
“floatIP”修改为双机浮动IP地址。
3n}/q9Yg/P0
以grid用户登录主节点。

执行如下命令，查看HAS状态。
$crsctl stat res -t

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

6Z4A Vf-U? p)G*d0如果显示“ora.LISTENER.lsnr”，表示默认监听已经添加，则不需要继续添加默认监听。
.WD/`7NcmI#rw0

如果没有显示“ora.LISTENER.lsnr”，表示默认监听未添加，请按照6继续添加默认监听。51Testing软件测试网^.u9XF1r
51Testing软件测试网1yi}"c*^Un
如果显示“ora.DG_ORA.dg”，表示DG_ORA已经创建成功，则不需要添加ASM实例。51Testing软件测试网 lvG&?)`
zu-}!j]7v+W,Vl0如果没有显示“ora.DG_ORA.dg”，表示DG_ORA未创建成功，请按照6添加ASM实例。51Testing软件测试网r2}zi(@m

添加默认监听和ASM实例。
检查空间大小。
hFO1h+[yin0%/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
)snT,q$Yu UkC0
6{*TB:C$GR0屏幕显示如下所示：
2R`-`+k1\hO#ko g0
```
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
```

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

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

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

Parsing command line arguments:
    Parameter &quot;silent&quot; = true
    Parameter &quot;responsefile&quot; = /home/oracrs/product/11gR2/grid/network/install/netca_typ.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Listener &quot;LISTENER&quot;already exists.
Oracle Net Services configuration successful. The exit code is 0

N)vOl/x'aO0执行如下命令，添加ASM实例。
)X_d[6W.Do_'O0
说明：
在添加ASM实例前，请以root用户登录到主节点，执行sh /etc/init.d/after.local
/Z-H yOvI#N*g0$asmca -silent -oui_internal -sysAsmPassword AsmSys123 -asmsnmpPassword AsmSnmp123 -configureASM -diskString '/dev/diskgroup' -diskGroupName dg_ora -diskList /dev/diskgroup/dg_ora -redundancy EXTERNAL51Testing软件测试网kj?/m:EW
7zgv(Z3x e!rG:t0屏幕显示如下信息表示ASM实例创建成功。51Testing软件测试网7w \9ii!v9`
```
Disk Group dg_ora created successfully.
```
51Testing软件测试网1BpSGXp8vA6O
$export asmspfile=`asmcmd spget`51Testing软件测试网 ^@z/}9A
51Testing软件测试网X`0P/l7` U B X
$asmcmd spset $ORACLE_HOME/dbs/spfile+ASM.ora51Testing软件测试网g8Up$OWyH

-e@'S$]{x)kW$S0

51Testing软件测试网*B#i[q%R7V
执行如下命令，检查HAS状态。51Testing软件测试网pjet1k*]w(I
51Testing软件测试网9@:][?D'g*y y
(y Kk._l)U4o0$crsctl stat res -t
51Testing软件测试网[,a+{7Nf
屏幕显示如下信息：
+f a`sBNx;|0
```
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
备机上配置：
```

以Oracle用户登录备节点。
添加监听器。ii"|(M_	Jks8|0
/e$T/Fo@:YG#DC#[0$cd $ORACLE_HOME/network/admin/51Testing软件测试网]C|0g0Bx
51Testing软件测试网%p'Z5?U:?i&K.[d$vi listener.ora51Testing软件测试网U(K	z+b;K%C@6e[
)XS0SS3IfcT[0在“listener.ora”文件中修改如下内容：
5})Wj`?2pOv0LISTENER =
  (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软件测试网aswcL“floatIP”修改为双机浮动IP地址。
9m#tp}'XM051Testing软件测试网Tf/B+T&P9J1cX51Testing软件测试网:qiDUyuiZc
修改tnsnames.ora。}+OT5?|8q6p1qS%j(v0
tfoiIV0$cd $ORACLE_HOME/network/admin/51Testing软件测试网[1@u`2p*J
d+kkY6bN%u0$vi tnsnames.ora51Testing软件测试网*`oox*J.G
*N }%^2wT)h*L#X0在“tnsnames.ora”文件中修改如下内容：51Testing软件测试网N6q+se%|(rPH
MMSGDB =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = mmsgdb)
      )
    )
TN0C	HkOax0“floatIP”修改为双机浮动IP地址。
)}$Y~vi1eW^7c051Testing软件测试网C"Q:_a
u'_
m%jK\"LO0
以grid用户登录备节点。
在备节点上执行如下命令检查空间大小。51Testing软件测试网N#Bf^YlT&GAK
DM/G0rw-M0$/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
0g3z']y%Yk:VJ8u0,VeXDwX?0屏幕显示如下信息：51Testing软件测试网XJ(h	D5EG"n8g`
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
;^H5})?3nz6gfH$z?0
'U
_EAf0
启动HAS，查看HAS状态。b,W%s,JQ AJE051Testing软件测试网@P4JtZb;\/]~
Y3h	H
$crsctl modify resource "ora.cssd" -attr "AUTO_START=1"51Testing软件测试网I%vp0t#U%Q'r	R	K
51Testing软件测试网?5OR+v+o&o	G$crsctl stop has -f
$hh,?;~-}DLa0'Bu%^kx#w%E\0$crsctl start has
~3M@NG	x$Jx0屏幕显示如下信息时，表示HAS启动成功。CRS-4123: Oracle High Availability Services has been started.

\#jQE$g3U fq0$crsctl stat res -t51Testing软件测试网*r
H0jrb*@0b8c,B.{n!L!z
D)x;n\,ao8\Y0屏幕显示如下信息：51Testing软件测试网:K~_%h'i6R&w
--------------------------------------------------------------------------------
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软件测试网6o.zNI*k(~8d^如果“ora.DG_ORA.dg”没有显示，请执行如下操作添加相应的资源。
^Q/OS*nr0以root用户登录备节点。
5D{;o d:hs0执行如下命令，查看“DG_ORA”对应的scsi信息。51Testing软件测试网qV)C(C#Cjl!J.A-[
51Testing软件测试网s6pEUR|"Jk#more /etc/init.d/after.local51Testing软件测试网.CYG+qA!Ja,p@
51Testing软件测试网pvS2hUR#kXd显示类似如下信息时，表示“DG_ORA”对应的scsi信息为“scsi-360022a110003135eae8c38ec00000001”。51Testing软件测试网&f%dh5|.BjIW ^
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_*
mawW+]T;A0执行如下命令，查看“DG_ORA”scsi对应的物理分区。
uk:fe,D051Testing软件测试网?[GFW#ls -lt /dev/disk/by-id/scsi*51Testing软件测试网T;EkGKwh	YQRb
51Testing软件测试网Q,]0FtAN:IBt显示类似如下信息时，表示“scsi-360022a110003135eae8c38ec00000001”对应的物理分区为“sdb”。
Y)yl	\|*kX0lrwxrwxrwx 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
51Testing软件测试网	J2]{$ag
q1m更改物理分区的属主。

h'})b
uo_D00Sni*IqUY0#chown -R grid:oinstall /dev/sdb
]Ji%~6I4t/A0
以grid用户登录备节点，设置DISPLAY环境变量，具体操作请参见设置DISPLAY环境变量。
执行asmca命令，启动ASMCA安装配置界面。