Linux_Oracle_11g_R2_RAC_安装配置详细过程

 

 

 

环境:
9j"c*j{Mv'x22494861OracleLinux AS 5.5两台
8a1v7e,aG(N8A22494861Oracle 11gR2

1、IP规划

127.0.0.1 localhost.localdomain localhost

#public ip
4Z*QL3s
Q}*uB2d1y22494861192.168.10.211  rac1ITPUB个人空间7~B


w6P[
192.168.10.212 rac2

#priv ip
"~"L${ x1Yg-x7y2249486110.10.10.211 rac1prvITPUB个人空间8dn[1]L"{
bX)K]c'V
10.10.10.212 rac2prv

#vip ip
+VmB2@ E8u22494861192.168.10.213 rac1vipITPUB个人空间6[]4^Y$Ob1K&{2@4w"`;x}
192.168.10.214 rac2vip

#scan ipITPUB个人空间`b&YC)F'u!V!V U
192.168.10.215  racscan

2、磁盘规划ITPUB个人空间,Y1u1J,c@9}&L6q#Y
   
3\Z Ot4rp3y�c*{22494861+CRS        三个2G的盘
#G-b[1]u
R [%i‑t22494861+DGDATA     三个10G的盘ITPUB个人空间X@­{ Q*?
p‑d
+DGRECOVERY 两个5G的盘

/usr/sbin/groupadd -g 501 oinstallITPUB个人空间7D+u:^"};]
`]
/usr/sbin/groupadd -g 502 dbaITPUB个人空间}2s-iY@[_
/usr/sbin/groupadd -g 503 operITPUB个人空间*D%{}%z�_f
/usr/sbin/groupadd -g 504 asmadminITPUB个人空间{*A�k{[1]F3v5U
/usr/sbin/groupadd -g 505 asmoperITPUB个人空间%jQ1Vm­x
sUy-Q
/usr/sbin/groupadd -g 506 asmdba
~,} [!iw@%o‑s22494861/usr/sbin/useradd-g oinstall -G dba,asmdba,oper oracle
4D XOp6V!]`:G22494861/usr/sbin/useradd-g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid

[root@ora1 ~]# id oracle
­?o!~3C�Mu22494861uid=501(oracle) gid=501(oinstall)groups=501(oinstall),502(dba),503(oper),506(asmdba)ITPUB个人空间Vh_;{s
bt[1]o `
[root@ora1 ~]# id grid
'X�r­i.J
om0e22494861uid=502(grid)gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)

mkdir /oracle/app/ITPUB个人空间-cPT/Y/[


Q
chown -R grid:oinstall /oracle/app/ITPUB个人空间j[1]Ct^�q+{
v
chmod -R 775 /oracle/app/

mkdir -p /oracle/app/oraInventoryITPUB个人空间6n1miE,vx­W*D
chown -R grid:oinstall /oracle/app/oraInventoryITPUB个人空间F4v f


O%Q[1]xB4A
t
chmod -R 775 /oracle/app/oraInventory

mkdir -p /oracle/app/gridITPUB个人空间$t |%D
]0Q"{
mkdir -p /oracle/app/oracleITPUB个人空间9J*A*t9y|!}^
chown -R grid:oinstall /oracle/app/gridITPUB个人空间 d/T#j
s­Ay5MKl2F
chown -R oracle:oinstall /oracle/app/oracle


?D"I:_+BG22494861chmod -R 775 /oracle/app/oracleITPUB个人空间%g y,I^.tl
]9n4K
chmod -R 775 /oracle/app/grid

ITPUB个人空间_@|'`2l&bH
O-\&z:N
passwd grid

passwd oracle

2、操作系统版本:

[root@rac1 ~]# lsb_release -aITPUB个人空间r


K ~EY ]&PE\
LSB Version:   :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
&K l"Z#@4I5g22494861DistributorID: EnterpriseEnterpriseServer
z_4edN(D/kbt6E`22494861Description:   Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
;K
@3g&i
V
el22494861Release:       5.5ITPUB个人空间n[1E]e8~iQu
Codename:       Carthage
1K8z w�u6Rc R M22494861[root@rac1 ~]# uname -a
]*Y'ur0h3h-B22494861Linuxrac1 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41EDT 2010 i686 i686 i386 GNU/LinuxITPUB个人空间 |h&d)EDf-F
t
B
[root@rac1 ~]#

修改系统参数:
P
?­T
lI0v22494861vi /etc/security/limits.conf

#ORACLE SETTINGITPUB个人空间
Buo‑J"C,J
grid                soft    nproc   2047ITPUB个人空间"OZ%N


m(WX%ps)C
grid                hard    nproc   16384ITPUB个人空间2J\c ~:o'l9B'M&z
grid                soft    nofile  1024
,e Snt%g?3E w­t22494861grid                hard    nofile  65536ITPUB个人空间�XT[1]Q:J1b,~tw.}
oracle              soft    nproc   2047ITPUB个人空间9[pg%c
?3f!V
oracle              hard    nproc   16384ITPUB个人空间'v"N7`
I.o*u6c9ub
oracle              soft    nofile  1024
%q+R-Q7By'?
Cdm22494861oracle              hard    nofile  65536



Fy5mW[kX0r;CE'R22494861vi/etc/pam.d/login

#ORACLE SETTINGITPUB个人空间
S
`$|7^F4o7P
session    required     pam_limits.so

# vi /etc/sysctl.conf
r$dh-{A#}#Dl22494861#ORACLESETTING
q
f­i­Xq22494861fs.aio-max-nr = 1048576ITPUB个人空间7y


_
P;d"M,Z,^,aS
fs.file-max = 6815744ITPUB个人空间|­P"Z
w4GC
kernel.shmall = 2097152ITPUB个人空间^*a(U.Tx4t-_ @um
kernel.shmmax = 536870912ITPUB个人空间 u*F
xy?.I)e8i
kernel.shmmni = 4096
k4w
Q!j­ORp22494861kernel.sem = 250 32000 100 128
@3O(v6V
yz&?uK22494861net.ipv4.ip_local_port_range = 9000 65500
[1]k(@s�M‑GRR
A6g22494861net.core.rmem_default= 262144ITPUB个人空间
I9n,g‑v,V[1]r(~,~%h
net.core.rmem_max = 4194304
Y`L7r~s1J_22494861net.core.wmem_default= 262144
'_9[rZ�Y�W0C22494861net.core.wmem_max = 1048586



]|6\\G.}l`-gZ B)~22494861gird时间同步所需要的设置(11gR2新增检查项)ITPUB个人空间9Q$V-G2Ry~'Y
#Network Time Protocol SettingITPUB个人空间‑]5{xc2\lT
/sbin/service ntpd stop
:E;nKQ YI22494861chkconfigntpd off
(d3v+Pej8C1U�Q Y22494861rm /etc/ntp.conf
`$A%D2z(R+x


SP1}\22494861mv /etc/ntp.conf to /etc/ntp.conf.org

/dev/shm 共享内存不足的处理
d
J?p3E�M%{9^v


?22494861解决方法:
%J6@Z)g‑E:m
p~‑h[1]YEe22494861例如:为了将/dev/shm的大小增加到1GB,修改/etc/fstab的这行:默认的:ITPUB个人空间 [8\4D|;Z
`B
none     /dev/shm      tmpfs   defaults        0 0
4x
UES
w(T‑z*\22494861改成:
^
Aa*P#rm‑?
g4q A&H M22494861none    /dev/shm       tmpfs   defaults,size=1024m       0 0ITPUB个人空间8d I)d�N8n
B
size参数也可以用G作单位:size=1G。ITPUB个人空间0x.}
b,zE4ZYK
重新mount /dev/shm使之生效:
-^6W&No‑Z\[1]B8cd;a22494861#mount -o remount /dev/shm
,W5bzJl22494861或者:

JY
w#WN22494861# umount /dev/shm
fP.|9R {
Cb22494861# mount -aITPUB个人空间xQl
L
c
O(Pz
马上可以用"df -h"命令检查变化。

ITPUB个人空间3i0b�D_ d
修改gird、oracle用户的.bash_profile文件:

#grid 用户配置文件 ORACLE_HOSTNAME请自行设置
-C5H
L2Y‑@0P*x22494861TMP=/tmp; export TMP
t5JT4D�y0FZ22494861TMPDIR=$TMP; export TMPDIR

ORACLE_SID=+ASM1; export ORACLE_SID
PUt)V].b22494861ORACLE_BASE=/oracle/app/oracle;export ORACLE_BASE
M(n#d[1]W


k"`22494861ORACLE_HOME=/oracle/app/grid/product/11.2.0;export ORACLE_HOME
,c.GO%\(Z22494861NLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"; export NLS_DATE_FORMAT
)]$B.U{.V RDaF7`
K­g&m:C22494861THREADS_FLAG=native; export THREADS_FLAG

PATH=$ORACLE_HOME/bin:$PATH; export PATH
w7p j4|2p0L(T-f!o!l22494861THREADS_FLAG=native;export THREADS_FLAG

PATH=$ORACLE_HOME/bin:$PATH; export PATH

if [ $USER = "oracle" ] || [ $USER = "grid" ]; thenITPUB个人空间|


G9xx4t,H)H0F,bUK
        if [ $SHELL = "/bin/ksh"]; then
O&\B2U
s:M22494861           ulimit -p 16384ITPUB个人空间5l‑Y)d$T­t#N3r{*T
             ulimit -n 65536
‑PX6N o%J+e2}:]#A%w22494861 else
7a*f(E4MI$Kr
c22494861   ulimit -u 16384 -n 65536ITPUB个人空间&C;Q
GqJ'Sp$n$e
      fiITPUB个人空间8?1X$AME2o
    umask 022ITPUB个人空间*{7ptb4P5h A)rBz
fi

ITPUB个人空间z-}‑w*`e6dh�E
#oracle用户配置文件 ORACLE_HOSTNAME请自行设置
‑} ]"{%V j R22494861#Oracle Settings oracle
H@�`+p‑aHg$ur�e22494861TMP=/tmp; export TMP
8Y7_8V[1]F!v^9N1H22494861TMPDIR=$TMP;export TMPDIR

ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASEITPUB个人空间6L)~3E!z$N2F| wr w
ORACLE_HOME=$ORACLE_BASE/product/11.2.0;export ORACLE_HOMEITPUB个人空间lxh2tk7U)BT
ORACLE_SID=racdb1; export ORACLE_SID
+S+yk K[1]T+c]H22494861ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH
;]5|4~;i)f_­C22494861PATH=$ORACLE_HOME/bin:$PATH;export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHITPUB个人空间?J


z[-B3~(qz
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; exportCLASSPATH
o)V1|8KO&x+s ~22494861NLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"; export NLS_DATE_FORMATITPUB个人空间[1]g}UW1A
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG

if [ $USER = "oracle" ] || [ $USER = "grid" ]; thenITPUB个人空间x F'{1p6T b;Z;c­H
        if [ $SHELL = "/bin/ksh"]; then
V Q8~*Z.b


X3|‑L\22494861        ulimit -p 16384
W.B.inW V vnp22494861             ulimit -n 65536ITPUB个人空间9^0~(Av;{Rc"_f5~!~
        elseITPUB个人空间@ZX.Z:h*p
X[1]v
             ulimit -u 16384 -n 65536ITPUB个人空间|8{~g;wX9a
        fi
!o~D
LDE8Q22494861       umask 022
XP-^%h fiC)v22494861fi


tW;o4I(d22494861配置信任关系ITPUB个人空间g+J-t*N2f
设置SSH,
­rt;F$u6^M[1]e224948611).在主节点RAC1上以grid,oracle用户身份生成用户的公匙和私匙ITPUB个人空间? @m!p;O0^B2N'S
# ping rac2-eth0
+c!]Om G


I{"TK,lU22494861# ping rac2-eth1ITPUB个人空间os&dDI|/dV
# su - oracleITPUB个人空间1il.q R q7f M
$ mkdir ~/.sshITPUB个人空间­d8Ap/BU
$ ssh-keygen -t rsaITPUB个人空间 M[;\1K�w
$ ssh-keygen -t dsa

2).在副节点RAC2、RAC3上执行相同的操作,确保通信无阻ITPUB个人空间�@(T!G%f s
N­P&T


N(d[1]Ub
_
# ping rac1-eth0
1C‑S�{
z
ez22494861# ping rac1-eth1
{­L{1e[1]nZ4Iv­I9e22494861#su - oracleITPUB个人空间;| `Yf9UY
$ mkdir ~/.sshITPUB个人空间�n5d@C M/[7Bm‑j
$ ssh-keygen -t rsa
|2[ hCd22494861$ ssh-keygen-t dsa

3).在主节点RAC1上oracle用户执行以下操作
5I&S.j~Xz#D |;H22494861$cat ~/.ssh/id_rsa.pub >> ./.ssh/authorized_keys
Kmy‑_kTE(RbU[1][22494861$ cat~/.ssh/id_dsa.pub >> ./.ssh/authorized_keysITPUB个人空间*E%U {+P+bL�USZ f
$ ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys

D�hI(l{,L6K22494861$ ssh rac2 cat ~/.ssh/id_dsa.pub >>~/.ssh/authorized_keysITPUB个人空间'X^a*C)a
vj;b
$ scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys

4).主节点RAC1上执行检验操作ITPUB个人空间­W[o!Q


@%J4Q
$ ssh rac1 dateITPUB个人空间R | rv @ v+L6M
$ ssh rac2 date
[(v4o#Li­?@;P22494861$ sshrac3 dateITPUB个人空间!G+aY4fa!SH
$ ssh rac1priv date

?8`[1]y kj-O2Fx22494861$ssh rac2priv dateITPUB个人空间:xm5k�z
E9g
$ ssh rac3priv date

ITPUB个人空间6C3c\@ e {,a
y,e
5).在副节点RAC2上执行检验操作ITPUB个人空间�Q


{3H%T ^7x
m(z~
$ ssh rac1 date
/C
t-vL2I ip%ZT22494861$ ssh rac2 date
,A t4w*X7s22494861$ ssh rac3dateITPUB个人空间+g�`a'_|!j-vN:i
k'O,~
$ ssh rac1priv dateITPUB个人空间‑Y)a;E/q)O2h
$ ssh rac2priv dateITPUB个人空间a"d/|,o8g*?)t
P@
$ ssh rac3priv dateITPUB个人空间‑B1q AKM;x+l/_

 

 

安装ASM

oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm
0}Z[1]n
S­g(n;r'w'I|O22494861oracleasmlib-2.0.4-1.el5.i386.rpmITPUB个人空间;{


W/IQ)N0id;J
oracleasm-support-2.1.3-1.el5.i386.rpm

 

格式化硬盘


p


~(w.e"d22494861Disk /dev/sdd: 2147 MB, 2147483648bytesITPUB个人空间0XW"^8@
x$G&o
255 heads, 63 sectors/track, 261 cylindersITPUB个人空间(mF$Z"\V
`$R
RP3W
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start        End      Blocks   Id  System
%Zlm


Qn5XT-J
E22494861/dev/sdd1              1         261    2096451   83  Linux

Disk /dev/sde: 2147 MB, 2147483648 bytesITPUB个人空间�p6u`X+H
255 heads, 63 sectors/track, 261 cylindersITPUB个人空间0U!} c xN:zW
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start        End      Blocks   Id  System
jfTc9L8R
Q9d22494861/dev/sde1              1         261    2096451   83  Linux

Disk /dev/sdf: 2147 MB, 2147483648 bytes
6F I,f


WC(eD22494861255 heads, 63 sectors/track, 261cylindersITPUB个人空间n;C6W"n~H!w
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start        End      Blocks   Id  System
L­S5c `)ua22494861/dev/sdf1              1         261    2096451   83  Linux

Disk /dev/sdg: 10.7 GB, 10737418240 bytes
9rVgA9q0a/@22494861255heads, 63 sectors/track, 1305 cylinders
4\)j9MO.aG­L,gA22494861Units= cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start        End      Blocks   Id  SystemITPUB个人空间.m


k W
f-|[
pb
/dev/sdg1              1        1305   10482381   83  Linux

Disk /dev/sdh: 10.7 GB, 10737418240 bytes
k0V{
O�zZ*Y?#V9O22494861255 heads, 63 sectors/track, 1305 cylindersITPUB个人空间N5sT@


RF�`
l
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start         End     Blocks   Id  SystemITPUB个人空间P?M&r)w2a7d
/dev/sdh1              1        1305   10482381   83  Linux

Disk /dev/sdi: 10.7 GB, 10737418240 bytesITPUB个人空间r$@E n.R;p'R
255 heads, 63 sectors/track, 1305 cylinders
*W3`gk*[22494861Units =cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start        End      Blocks   Id  System
4_8@&z'V2f c�\D22494861/dev/sdi1              1        1305   10482381   83  Linux

Disk /dev/sdj: 5368 MB, 5368709120 bytesITPUB个人空间N�\&nQ[1]M
255 heads, 63 sectors/track, 652 cylindersITPUB个人空间8o A'bv,^@!?%U'n
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start        End      Blocks   Id  System
7xn*c$Z[1]MvQ6x22494861/dev/sdj1              1         652    5237158+  83  Linux

Disk /dev/sdk: 5368 MB, 5368709120 bytes
(Y�H#N.D8t22494861255 heads, 63 sectors/track, 652 cylinders
2{5b#X&u&~i22494861Units= cylinders of 16065 * 512 = 8225280 bytes

   Device Boot     Start        End      Blocks   Id  System
&G0p5Oz


k+pu!d3cP(e22494861/dev/sdk1              1         652    5237158+  83  Linux

 

配置ASMITPUB个人空间~A$j:F


l1pI
 ITPUB个人空间~(q�^H+aS
 [root@ora1 ~]# /etc/init.d/oracleasm  configure
!Li%C:HYV-c`22494861Configuringthe Oracle ASM library driver.

This will configure the on-boot properties of the OracleASM library
h2QZ$R Q,VR$a22494861driver. The following questions will determine whether the driver is
.a%FH


r
D&Z22494861loaded on boot and what permissions it will have. The current valuesITPUB个人空间{2Q"|)Z0n
will be shown in brackets ('[]').  Hitting <ENTER> without typing anITPUB个人空间w9{[1]A+uj
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: gridITPUB个人空间+h


z+U2C�C
E;Y
Default group to own the driver interface []: asmadminITPUB个人空间[1]{#j,c0kY
p]U
Start Oracle ASM library driver on boot (y/n) [n]: yITPUB个人空间
T3j
tA2m$L-~
{‑b'a
Scan for Oracle ASM disks on boot (y/n) [y]: y
2D Q2PJUW
~22494861Writing Oracle ASM library driver configuration: doneITPUB个人空间^ \X5mQ2b
J5F
Initializing the Oracle ASMLib driver: [  OK  ]
M
]0U
bQP8~th22494861Scanning the system for Oracle ASMLib disks:[  OK  ]ITPUB个人空间.r]k[8]&|Duf8y
 
}C)f3`
T7S%n22494861 创建asm盘ITPUB个人空间
I1s­hA5_1~"t,mh0_
   ITPUB个人空间3? h&eO
kd
+CRS        三个2G的盘ITPUB个人空间&gHn R A0Es#L+F
+DGDATA     三个10G的盘
Vk,_w,M22494861+DGRECOVERY两个5G的盘

/dev/sdd:   2097152
YL n5MI6|Y%g
w*jn.Y22494861/dev/sde:   2097152ITPUB个人空间"v^^zh[1][
/dev/sdf:   2097152
cVh-f-c‑eSf-s22494861/dev/sdg: 10485760ITPUB个人空间‑?FZOq
/dev/sdh:  10485760
s�NqI#I!x22494861/dev/sdi:  10485760
:T I.M5c)A-e&N$\t0E;y­dt22494861/dev/sdj:   5242880
pfSS[1]T0ci[$D6N22494861/dev/sdk:  5242880

[root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS1/dev/sdd1ITPUB个人空间\(wj,B$e$[cs
Marking disk "CRS1" as an ASM disk: [  OK  ]ITPUB个人空间8^ ji0dF1U#Ls'?
[root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS2 /dev/sde1ITPUB个人空间,Q'S}[1]W
r!h[1]~g1K*e
Marking disk "CRS2" as an ASM disk: [  OK  ]
%w;F


A;U
g22494861[root@ora2 asm]# /etc/init.d/oracleasmcreatedisk CRS3 /dev/sdf1
.U7\gx4YB7Z
Max{22494861Marking disk "CRS3" as an ASM disk: [ OK  ]ITPUB个人空间A"qK3j$i.u9c_L
[root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA1 /dev/sdg1
&y:}6Nw'R\22494861Markingdisk "DATA1" as an ASM disk: [FAILED]
eCz
s!lcXb22494861[root@ora2 asm]# /etc/init.d/oracleasmcreatedisk DATA1 /dev/sdg1ITPUB个人空间4j9EN1S�^/{P‑S
Marking disk "DATA1" as an ASM disk: [  OK  ]
|S"l8ji[1]h5`#l{5?d22494861[root@ora2asm]# /etc/init.d/oracleasm createdisk DATA2 /dev/sdh1ITPUB个人空间t([
J.N5U
Marking disk "DATA2" as an ASM disk: [  OK  ]
:EWPz9[(U9Y22494861[root@ora2asm]# /etc/init.d/oracleasm createdisk DATA3 /dev/sdi1
HB;sV
k1R8TM22494861Marking disk "DATA3" as an ASM disk: [ OK  ]
2i
~"r;G#r22494861[root@ora2 asm]#/etc/init.d/oracleasm createdisk REC1 /dev/sdj1ITPUB个人空间:k3k-e c$R[1]~J
Marking disk "REC1" as an ASM disk: [  OK  ]
q(i‑\
G DuX5hO22494861[root@ora2 asm]#/etc/init.d/oracleasm createdisk REC2 /dev/sdk1
&k;e\5lx0TE3U%d22494861Markingdisk "REC2" as an ASM disk: [  OK  ]

ITPUB个人空间!R{8n‑B%DRN
[root@ora2 asm]# /etc/init.d/oracleasmscandisks               
%V&U"QRL22494861Scanningthe system for Oracle ASMLib disks: [  OK  ]ITPUB个人空间
k7|5~8I7v+_oF­C
[root@ora2 asm]# /etc/init.d/oracleasm listdisksITPUB个人空间P:|
GrZ _5o
iwy
CRS1ITPUB个人空间7r-WK:w‑l�pK'F
CRS2
/O­q


S
xo‑@ hF22494861CRS3ITPUB个人空间$T*Nz H&HQOx
DATA1ITPUB个人空间
Pl+t
r;h:C*Ccp
DATA2
mQP$G V3C)X!{1|{+z22494861DATA3
K-Eso
mV­lmG22494861REC1ITPUB个人空间6_(R%B9~ E%K7fb
REC2

安装cvuqdisk包并验证

在两个 Oracle RAC 节点上安装操 作系统程序包 cvuqdisk。如果没有 cvuqdisk,集群验证实用程序就无法发现共享磁盘,当运行(手动运行或在Oracle Grid Infrastructure 安装结束时自动运行)集群验证实用程序时,您会收到这样的错误消息:“Package cvuqdisk not installed”。使用适用于您的硬件体系结构(例如,x86_64 或 i386)的cvuqdisk RPM。
)T(fG‑V
}‑Wk22494861cvuqdisk RPM 包含在 Oracle GridInfrastructure 安装介质上的 rpm 目录中。ITPUB个人空间!qY


u5}3rUM(M9S
设置环境变量 CVUQDISK_GRP,使其指向作为cvuqdisk 的所有者所在的组(本文为 oinstall):

export CVUQDISK_GRP=oinstall

使用 CVU 验证是否满足 Oracle 集群件要求
1G [2S!{1L-^:d22494861记住要作为 grid 用户在将要执行 Oracle 安装的节点 (racnode1) 上运行。此外,必须为 grid 用户配置通过用户等效性实现的 SSH 连通性。


~


H-pQS22494861在grid软件目录里运行以下命令:

./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup-verbose

 

[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -nrac1,rac2 -fixup -verbose

Performing pre-checks for cluster services setup

Checking node reachability...

 

检查过程省略...

 

使用 CVU 验证硬件和操作系统设置

./runcluvfy.sh stage -post hwos -n rac1,rac2 -verbose

[grid@rac1 grid]$ ./runcluvfy.sh stage -post hwos -nrac1,rac2 -verbose

Performing post-checks for hardware and operating systemsetup

Checking node reachability...

 

检查过程省略...

 

6、
$T"j F@{p4E


m22494861su - grid
7BF;Xgn F[1]S,p22494861./runInstaller

scan配置:ITPUB个人空间?:e F:}E!]
H#t
cluster scan: sanclustersITPUB个人空间&W‑}i5VAp7r
scanname:  racscan
1H


g2a1^
N'`&`22494861scanport:  1521

ITPUB个人空间3@!P'O‑M+}@ e j
/oracle/app/oraInventory/orainstRoot.sh

[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shITPUB个人空间g;p R-S
R9u2O#s)E
Changing permissions of /oracle/app/oraInventory.
.s y\!]4DoZ.r-o)}22494861Addingread,write permissions for group.
G#sMg�mr$A~22494861Removing read,write,execute permissions for world.

Changing groupname of /oracle/app/oraInventory to oinstall.
!b8]�g�| r,l22494861The execution of the script. is complete.

[root@rac2 soft]# /oracle/app/oraInventory/orainstRoot.shITPUB个人空间i.^
|4M,Y;{C
Changing permissions of /oracle/app/oraInventory.
9hg‑ak9LA}&C G22494861Addingread,write permissions for group.
yK R'X'Ot&Jo22494861Removingread,write,execute permissions for world.

Changing groupname of /oracle/app/oraInventory to oinstall.
.AA'PQ/v"C7^,k22494861Theexecution of the script. is complete.

 

 

/oracle/app/grid/product/11.2.0/root.sh

[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shITPUB个人空间$`8WT}h8lFJ
Changing permissions of /oracle/app/oraInventory.ITPUB个人空间G4^D0gc-w
Adding read,write permissions for group.
X2o |8A


Uk[1]M:g22494861Removingread,write,execute permissions for world.

Changing groupname of /oracle/app/oraInventory to oinstall.

O YZ2q$Ka`e


?'e22494861The execution of the script. is complete.ITPUB个人空间i)m6U�y,v6w-ppx"cI
[root@rac1 soft]# /oracle/app/grid/product/11.2.0/root.sh
?"pXI#M"ER
_+N22494861Running Oracle 11g root.sh script...

The following environment variables are set as:ITPUB个人空间2Zb$c*B9U,q*k&N Ca3y
    ORACLE_OWNER= grid
cv8e6T;J,x22494861   ORACLE_HOME=  /oracle/app/grid/product/11.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
­p)z(Z{
e6R*I)AO6C22494861   Copying dbhome to /usr/local/bin ...

s2r8_)I6k22494861   Copying oraenv to /usr/local/bin ...ITPUB个人空间Q1O;{6w6fp0y
c0k[1]y
   Copying coraenv to /usr/local/bin ...



@­T\,j2O+uC0I22494861Creating /etc/oratab file...ITPUB个人空间6G*]([!A
q2E
w1h
Entries will be added to the /etc/oratab file as needed byITPUB个人空间7n5i4b2w4nTV#wY
Database Configuration Assistant when a database is created
7i'[5b1p8?22494861Finishedrunning generic part of root.sh script.
*v9A` U8p&Q9J} ~7u22494861Nowproduct-specific root actions will be performed.

2010-07-28 16:19:03: Parsing the host name

Z8_ZIyx�a224948612010-07-2816:19:03: Checking for super user privileges
%})I A+a!P2T�x�Ng


I224948612010-07-2816:19:03: User has super user privileges
b
sjj;N*?(w
y-VI22494861Using configuration parameter file:/oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsITPUB个人空间F)n
M[1]}I}&i‑Lt-M
Creating trace directoryITPUB个人空间9Y}1Z
~-^G
LOCAL ADD MODEITPUB个人空间W!X bF
N,{ V
?
Creating OCR keys for user 'root', privgrp 'root'..
%m G {v/@;` J22494861Operationsuccessful.ITPUB个人空间
l+ZH,MP%s2m"o�d!Fz
  root wallet
x&} {6~p)X22494861 root wallet cert
U:tx
_‑~7} W"N22494861  root cert export
({H o_&A8q1v22494861 peer walletITPUB个人空间
|He-RN'NL{
  profile reader walletITPUB个人空间i3SEr%tz
a
  pa walletITPUB个人空间‑YAF�MT[G
  peer wallet keys
[1]F]M{a'J,g+F*N�M|22494861  pawallet keys
6g%g{Qz"@22494861 peer cert requestITPUB个人空间8f.s)M/\+QK)D­w4T"V
  pa cert requestITPUB个人空间? g1Y3kd
  peer cert
P8z7m0k!O J%e0p�R22494861  pa cert
enM5fH)wM'U22494861 peer root cert TP
7Cpf`Gw5Z4]22494861 profile reader root cert TP
2ItANl8i­X
D*k22494861  pa root cert TPITPUB个人空间2s[1]wa1R'j4jL
  peer pa cert TPITPUB个人空间r9u%EF*A5F Q
  pa peer cert TP

z
x[1]wV5C22494861 profile reader pa cert TPITPUB个人空间;VW;m2@%xr‑}
  profile reader peer cert TP
O4v:m8}%BZ.?�Ys7T22494861  peer user cert
)qCt]&wK5{(M'F22494861 pa user certITPUB个人空间-x.^BW1y­lc0__
Adding daemon to inittabITPUB个人空间�m6j2@­d,T \b
CRS-4123: Oracle High Availability Services has been started.ITPUB个人空间 H
R Od
|8n
ohasd is starting
3b+{%d nW ~22494861CRS-4123:Oracle High Availability Services has been started.
{5n(Ne&pS+y22494861ohasd isstarting
t5Aw U1A22494861CRS-2672:Attempting to start 'ora.gipcd' on 'rac1'
U6K4aHMH/n%sA5sT22494861CRS-2672:Attempting to start 'ora.mdnsd' on 'rac1'ITPUB个人空间Y;Y.IW
X6x
CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
D[1]B;COs
u22494861CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededITPUB个人空间:A'D6jz*S‑d%E6\4h[1]eN
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
&|PXQ1OZ&Ub!s22494861CRS-2676:Start of 'ora.gpnpd' on 'rac1' succeeded
8{J k[1]~!gn-fz22494861CRS-2672:Attempting to start 'ora.cssdmonitor' on 'rac1'ITPUB个人空间Q(sT
Rj ^T0b�o2W
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
8B‑d['}(}nX$I22494861CRS-2672:Attempting to start 'ora.cssd' on 'rac1'
d deFy9h4G0]E6D22494861CRS-2672:Attempting to start 'ora.diskmon' on 'rac1'
9?_d1b`­I8J+Z%|22494861CRS-2676:Start of 'ora.diskmon' on 'rac1' succeeded
$Y
J#V1U1w.q­{{7g8[|H22494861CRS-2676: Start of 'ora.cssd' on 'rac1'succeeded
!\"J
A#J%|3@22494861CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'ITPUB个人空间�D,Yb$rdY5A G
CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded

ASM created and started successfully.

DiskGroup CRS created successfully.

clscfg: -install mode specifiedITPUB个人空间?'j-eID
Im2YZ2I7D
Successfully accumulated necessary OCR keys.
h|&_|f


e­\ sW2M9HS22494861Creating OCR keys for user 'root',privgrp 'root'..
~5u q:G
m+AJ
O6r6NV22494861Operation successful.ITPUB个人空间B#L:m z&]]
CRS-2672: Attempting to start 'ora.crsd' on 'rac1'

Q*x_(N8u22494861CRS-2676: Start of 'ora.crsd' on 'rac1' succeededITPUB个人空间,V*|@;W[1]~L7TPoy
CRS-4256: Updating the profileITPUB个人空间VVc8NZ8x7P
A"I
Successful addition of voting disk a81aaf52b2b74ff5bf7a773e7966ea7c.ITPUB个人空间-D$h8^S8~8c6j‑[
Successfully replaced voting disk group with +CRS.ITPUB个人空间x(f2ci%J
CRS-4256: Updating the profileITPUB个人空间
n$y
r*xB/Exh
CRS-4266: Voting file(s) successfully replaced
*u+O!|
e v1_Dn22494861##  STATE   File UniversalId               File Name Disk groupITPUB个人空间[1][
D&U4A o0K&T,l
--  -----   -----------------               --------- ---------ITPUB个人空间z8Z
b;^8W1[ I
 1. ONLINE   a81aaf52b2b74ff5bf7a773e7966ea7c(ORCL:CRS1) [CRS]ITPUB个人空间Q
u
]J!\
Located 1 voting disk(s).ITPUB个人空间6c"aRe?a`YeX
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
,K6U|Hb'Q
V22494861CRS-2677: Stop of 'ora.crsd' on 'rac1' succeededITPUB个人空间­c'{6AK­_
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
*DC w,TE L5X_ wS m22494861CRS-2677:Stop of 'ora.asm' on 'rac1' succeededITPUB个人空间!d%B t ~.wL+J;q
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'ITPUB个人空间l)R:E;d^ Y7a'E
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeededITPUB个人空间8Z
N VA x1S't
f
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'ITPUB个人空间u$b1z wD
Q
CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeededITPUB个人空间­y1N[ LK8jJ/F8_
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'

LVE.T1`j22494861CRS-2677: Stop of 'ora.cssd' on 'rac1'succeeded

K‑M m_i)D‑^.d‑u$W22494861CRS-2673: Attempting to stop'ora.gpnpd' on 'rac1'
q[1]BJ
f8K­w22494861CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
2s1J j6}f#k
H22494861CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'ITPUB个人空间'b&j-E$D]R*e}6K
[
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeededITPUB个人空间o1k�zl9{#x4L&}
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'ITPUB个人空间
c‑Bch[
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
$r:G,C!\J*R'vk3v3}U22494861CRS-2672:Attempting to start 'ora.mdnsd' on 'rac1'ITPUB个人空间%hI \]2R+D0?
CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
i­Vv-J+o7j
C22494861CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
\i�L/A:Q.qW�r-m22494861CRS-2676: Start of 'ora.gipcd' on 'rac1' succeededITPUB个人空间L1lO)J[z8k8X�cD|
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
r‑Q+c1W)H"cz*x qL22494861CRS-2676:Start of 'ora.gpnpd' on 'rac1' succeededITPUB个人空间#`4w
EsA3]
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
6V*[[1]^z
Q22494861CRS-2676: Start of 'ora.cssdmonitor' on 'rac1'succeededITPUB个人空间2q-i1D"_/A&Af
CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
Zk B[1]]b6yP2e#S22494861CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'ITPUB个人空间‑Y6nvL&H ]+_s!r
CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
nG4C[1]z$mSP22494861CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded

@ND-|6R~*a22494861CRS-2672: Attempting to start 'ora.ctssd' on'rac1'ITPUB个人空间0B$}:skXYG(f
CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded
Zcm
VK
K_­?22494861CRS-2672: Attempting to start'ora.asm' on 'rac1'
AB"B"Qp)^22494861CRS-2676:Start of 'ora.asm' on 'rac1' succeeded
X­t [[1]r+of3f0uq22494861CRS-2672:Attempting to start 'ora.crsd' on 'rac1'
%pH8zOX4x0I
nO‑d:E22494861CRS-2676: Start of 'ora.crsd' on 'rac1' succeededITPUB个人空间‑s
I#\3S2\
O
CRS-2672: Attempting to start 'ora.evmd' on 'rac1'
$_2u­o1Q n‑m
]22494861CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded
Z
c2b‑Y.n22494861CRS-2672: Attempting to start 'ora.asm' on 'rac1'
#i­GT~\22494861CRS-2676:Start of 'ora.asm' on 'rac1' succeededITPUB个人空间,?.F
P0O
n
CRS-2672: Attempting to start 'ora.CRS.dg' on 'rac1'
;nI�j,w'|r;Y22494861CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeeded
.X9e­~u)uz22494861CRS-2672:Attempting to start 'ora.registry.acfs' on 'rac1'ITPUB个人空间s?/G Ty:E$Y­e,~
CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeeded

rac1     2010/07/28 16:31:27    /oracle/app/grid/product/11.2.0/cdata/rac1/backup_20100728_163127.olr
9z[1]M1jw;z8fS
e I(r22494861Configure Oracle Grid Infrastructure for a Cluster ...succeededITPUB个人空间


m;cxw`!L�z3i[1]_
Updating inventory properties for clusterwareITPUB个人空间\
V,Q‑qva.\
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 971MB    PassedITPUB个人空间1xydi3X


R0q
The inventory pointer is located at /etc/oraInst.loc
^ }+^h8ro,gwr_22494861Theinventory is located at /oracle/app/oraInventoryITPUB个人空间
yXrD
K [
'UpdateNodeList' was successful.

 

[root@rac2 soft]# /oracle/app/grid/product/11.2.0/root.sh
#Ba3fh]Gi22494861Running Oracle 11g root.sh script...

The following environment variables are set as:ITPUB个人空间y(|'q*Jh~+`‑z‑Y[1]H2W
    ORACLE_OWNER= grid
x'r:v0k­m9Tv/P5i22494861   ORACLE_HOME=  /oracle/app/grid/product/11.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
8t7y@Te&bR.G4t^22494861Thefile "dbhome" already exists in /usr/local/bin.  Overwrite it?(y/n)
IC1\)L$N*Q*J22494861[n]: yITPUB个人空间[�GL F8M;R u
   Copying dbhome to /usr/local/bin ...
1E-l+z4?v'byg‑p22494861Thefile "oraenv" already exists in /usr/local/bin.  Overwrite it?(y/n)
M!P;R,nL:L z!h22494861[n]: yITPUB个人空间3k3];n5_}E p#Wh
   Copying oraenv to /usr/local/bin ...
Tn2N!C&X/O&YO22494861Thefile "coraenv" already exists in /usr/local/bin.  Overwrite it?(y/n)ITPUB个人空间�f


b/~%D n(N4e-NF4M
h_
[n]: yITPUB个人空间8P
^
R|9e#gu
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed byITPUB个人空间{D;p8C#\!N3A:g:JI
Database Configuration Assistant when a database is created
2Mc@:ZQh6fI6d/?22494861Finishedrunning generic part of root.sh script.
&\&m'Uj:UA {O


f22494861Now product-specific root actions will beperformed.
Dm/^1L5vnj
N!M%d224948612010-08-02 14:32:28: Parsing the host name

WB�q(n+zF m/x224948612010-08-02 14:32:28: Checking for super user privileges
3DOD9G~)bz e224948612010-08-0214:32:28: User has super user privilegesITPUB个人空间
G5Yc.b"\ GH�[/g
Using configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_params

}
J&Oz-x*S;I,L
w
@22494861Creating trace directoryITPUB个人空间\Fb7`*t.H�|q*Z
LOCAL ADD MODE
-N d:{,n2o2TP­T22494861CreatingOCR keys for user 'root', privgrp 'root'..
,ewCieS
F_22494861Operation successful.

L [0z(u E9w9r22494861Adding daemon to inittab
`k)L h:x­wj*I_22494861CRS-4123:Oracle High Availability Services has been started.
[1]n`h
Y_-c22494861ohasd is starting
[1]v?P"A.sp+_Yu22494861CRS-4402:The CSS daemon was started in exclusive mode but found an active CSS daemon onnode rac1, number 1, and is terminating
#K/C_u-k2Z22494861An activecluster was found during exclusive startup, restarting to join the cluster
}7cXrc22494861CRS-2672:Attempting to start 'ora.mdnsd' on 'rac2'ITPUB个人空间2i*\X1Z
_
CRS-2676: Start of 'ora.mdnsd' on 'rac2' succeededITPUB个人空间 a�P2@�aJ�_`q
CRS-2672: Attempting to start 'ora.gipcd' on 'rac2'
Ck7b7Z)K7Gl22494861CRS-2676:Start of 'ora.gipcd' on 'rac2' succeeded
9bJ­^.C"x2b22494861CRS-2672:Attempting to start 'ora.gpnpd' on 'rac2'
Sa$O,c&N:rn22494861CRS-2676:Start of 'ora.gpnpd' on 'rac2' succeeded
9B:O['TB3M6c ]22494861CRS-2672:Attempting to start 'ora.cssdmonitor' on 'rac2'ITPUB个人空间2o |w {‑h O\Er
CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeeded
lhzK�]\/O­}
{vU22494861CRS-2672: Attempting to start'ora.cssd' on 'rac2'
{BO/\6Pw22494861CRS-2672:Attempting to start 'ora.diskmon' on 'rac2'
u:cs9Nz'u22494861CRS-2676: Startof 'ora.diskmon' on 'rac2' succeeded
x,o­J2mn�q9aB22494861CRS-2676: Start of 'ora.cssd' on 'rac2' succeededITPUB个人空间­H9A8?dN
CRS-2672: Attempting to start 'ora.ctssd' on 'rac2'
3S[1]`!D
l*F;d|iA[1]B22494861CRS-2676:Start of 'ora.ctssd' on 'rac2' succeededITPUB个人空间J:BO
o:?2f2S+m2sl
R
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac2'
m)W5A,U {-uo22494861CRS-2676:Start of 'ora.drivers.acfs' on 'rac2' succeeded
;{Fwa^7L3uZ�|22494861CRS-2672: Attempting to start 'ora.asm' on 'rac2'
G"l
cl$r22494861CRS-2676: Start of 'ora.asm' on 'rac2' succeeded
5q D
f#P\
Ob-E22494861CRS-2672: Attempting to start 'ora.crsd' on 'rac2'

Z
a{ Q
pmD@3Y‑e22494861CRS-2676: Start of 'ora.crsd' on 'rac2' succeeded
,m C ?6h4@1D:N‑x22494861CRS-2672:Attempting to start 'ora.evmd' on 'rac2'
6G.|aX)^B7o6hN22494861CRS-2676:Start of 'ora.evmd' on 'rac2' succeeded

rac2     2010/08/02 14:37:51    /oracle/app/grid/product/11.2.0/cdata/rac2/backup_20100802_143751.olr
:Y;H[1]d
R.vU
}22494861Configure Oracle Grid Infrastructure for a Cluster ...succeeded
3n(E
z/DD$@ T0o
c%z22494861Updating inventory properties for clusterware
[1]Ql5h!s@‑tv22494861Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 1202MB    Passed
1~(P-e&J[22494861Theinventory pointer is located at /etc/oraInst.locITPUB个人空间5f6a!x­|�B;j&\B't
The inventory is located at /oracle/app/oraInventory
t$_R~4mb3zU z22494861'UpdateNodeList'was successful.


F‑}4CO1z7m­q6l#f
P22494861[grid@rac2 ~]$ srvctl enable oc4j
&^­n_‑J:}!Ycv,L(e
~22494861PRKO-2116 : OC4J is already enabled
NN9X z&{'KN22494861[grid@rac2~]$ srvctl start oc4j
:UM2LE+J }22494861[grid@rac2 ~]$srvctl enable nodeappsITPUB个人空间V
G ~0{x#p2h&D
PRKO-2415 : VIP is already enabled on node(s): rac1,rac2
­[(e4cc:J PxHA22494861PRKO-2416: Network resource is already enabled.
$S�~fc9`r4v22494861PRKO-2417 : ONS is already enabled on node(s): rac1,rac2ITPUB个人空间*{#ho6e&]1b!H
PRKO-2418 : eONS is already enabled on node(s): rac1,rac2

[grid@rac2 ~]$ crs_stat -t
|6h2em%Y[1]X22494861Name          Type          Target    State    Host       


g c B @Qa
S-G/`22494861------------------------------------------------------------ITPUB个人空间G‑r8{m0T Rw.dl+k
ora.CRS.dg     ora....up.type ONLINE   ONLINE    rac1       ITPUB个人空间.yrM;O#p G
X0`
ora....ER.lsnr ora....er.type ONLINE    ONLINE   rac1       
-JY1o!E‑l4v+p+y22494861ora....N1.lsnrora....er.type ONLINE    ONLINE   rac1       ITPUB个人空间n0`9U)d`y�o
ora.asm        ora.asm.type  ONLINE    ONLINE   rac1       
XG*BI5B#g
M ]@*|22494861ora.eons      ora.eons.type  ONLINE    ONLINE   rac1       ITPUB个人空间[1]EsE&OU.]/~
ora.gsd        ora.gsd.type  ONLINE    ONLINE   rac1       
1R*Ob
O�P­|j­J2YL#{.Q22494861ora....network ora....rk.type ONLINE   ONLINE    rac1       ITPUB个人空间.Y"X[1]kFJ­DA
ora.oc4j       ora.oc4j.type ONLINE    ONLINE   rac2       ITPUB个人空间P$l zAv;uRM$C,i
ora.ons        ora.ons.type  ONLINE    ONLINE   rac1       ITPUB个人空间WA?.qb
ora....SM1.asm application    ONLINE   ONLINE    rac1       
[1]}b4k;Y[1]MI5a)Q@�O22494861ora....C1.lsnr application   ONLINE    ONLINE   rac1       
2n:t#o�q(eg22494861ora.rac1.gsd   application   ONLINE    ONLINE   rac1       
(sau A]^'JcO%|22494861ora.rac1.ons  application    ONLINE    ONLINE   rac1       ITPUB个人空间.T8{gY&oo)]
ora.rac1.vip   ora....t1.type ONLINE   ONLINE    rac1       
qd2Q1?(e+fh22494861ora....SM2.asmapplication    ONLINE    ONLINE   rac2       
L*B5n;A(^#t
y D22494861ora....C2.lsnr application   ONLINE    ONLINE   rac2       
­}jv.[3T4T q3x+a]22494861ora.rac2.gsd  application    ONLINE    ONLINE   rac2       
H­T xR4l9~:bG~/i22494861ora.rac2.ons  application    ONLINE    ONLINE   rac2       
R*]+[ jm­O­{f22494861ora.rac2.vip  ora....t1.type ONLINE    ONLINE   rac2       
)p L'JG-Jm9Vri22494861ora....ry.acfsora....fs.type ONLINE    ONLINE   rac1       ITPUB个人空间5[i
s? ff6b
ora.scan1.vip  ora....ip.type ONLINE   ONLINE    rac1 

6、
f fDkA'z Ib2O�D
]C22494861su - gridITPUB个人空间REld/H? {1h
./runInstaller

scan配置:ITPUB个人空间'x$oiKSiq
cluster scan: sanclusters
8F"KZ(Qk


C OY }{22494861scanname:  racscanITPUB个人空间 ` ~‑v0OV:Pd
scanport:  1521


N%ot]-`$r22494861/oracle/app/oraInventory/orainstRoot.sh

[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.shITPUB个人空间q {)R"wZVm
Changing permissions of /oracle/app/oraInventory.
\9I z K,`YT2M22494861Addingread,write permissions for group.

Pp[1]n~


v
ac22494861Removing read,write,execute permissionsfor world.

Changing groupname of /oracle/app/oraInventory to oinstall.ITPUB个人空间[1]X6S:N‑M‑I3Z
The execution of the script. is complete.

[root@rac2 soft]# /oracle/app/oraInventory/orainstRoot.shITPUB个人空间3w0IO


u*VfG%?
Changing permissions of /oracle/app/oraInventory.ITPUB个人空间0|:R N$e4WV1B:[4U
Adding read,write permissions for group.ITPUB个人空间1B
w7i3S#f C
]
Removing read,write,execute permissions for world.

Changing groupname of /oracle/app/oraInventory to oinstall.ITPUB个人空间5`
N


d$[!Q8c
The execution of the script. is complete.

 

 

/oracle/app/grid/product/11.2.0/root.sh

[root@rac1 soft]# /oracle/app/oraInventory/orainstRoot.sh
S)`$p3m
m2}�^#O+f22494861Changing permissions of /oracle/app/oraInventory.
5n(IGi,k
z"t22494861Adding read,write permissions for group.ITPUB个人空间({
YA;g+Gm
Removing read,write,execute permissions for world.

Changing groupname of /oracle/app/oraInventory to oinstall.ITPUB个人空间­p�c$Jj6w5xo"\EX3zs!Lt
The execution of the script. is complete.ITPUB个人空间(H


{6@s,d#e7T
[root@rac1 soft]# /oracle/app/grid/product/11.2.0/root.sh
/]1Nkz8f B
J22494861Running Oracle 11groot.sh script...

The following environment variables are set as:
][1]HG,f/xT~22494861   ORACLE_OWNER= gridITPUB个人空间7O)f4T _.s8N
    ORACLE_HOME=  /oracle/app/grid/product/11.2.0

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


V,Pp)U0r
Y‑Hd22494861   Copying dbhome to /usr/local/bin ...ITPUB个人空间3kD*V*U0Z
I1d)\1@
   Copying oraenv to /usr/local/bin ...ITPUB个人空间(^&l I­s}&qnav)@C
   Copying coraenv to /usr/local/bin ...

 

ITPUB个人空间!R)Tvu7H+eP"H[!o w
Creating /etc/oratab file...
S*W]7w.Y&L_M22494861Entrieswill be added to the /etc/oratab file as needed byITPUB个人空间e m7\ Q W0ML


jw3Pw
Database Configuration Assistant when a database is createdITPUB个人空间‑S0G!J4t­?.]
\*k
Finished running generic part of root.sh script.ITPUB个人空间&B'Ot,^ p+opz�l
Now product-specific root actions will be performed.

2010-07-28 16:19:03: Parsing the host name
n�JN[1]ig8X4I;K
e224948612010-07-28 16:19:03: Checking forsuper user privileges
}'P?oz%A/G224948612010-07-28 16:19:03:User has super user privileges
D&`-[ l}hm22494861Usingconfiguration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_params

q*N#gg V
}-~S6Y22494861Creating trace directory
]*ku[1]^7{9^22494861LOCALADD MODEITPUB个人空间nQ^"\Mxu
Creating OCR keys for user 'root', privgrp 'root'..ITPUB个人空间-P]
w[�I
Operation successful.ITPUB个人空间7hTk H:q;T4L
  root walletITPUB个人空间0u?(k%Q9gR
  root wallet certITPUB个人空间*B)D,V*d'y_ `
  root cert exportITPUB个人空间Y4[j m2U EG6VM
  peer walletITPUB个人空间 |1h&[;j0P(V*?8x7F
  profile reader walletITPUB个人空间 _~
q4{*x‑|r
  pa wallet
+OG-g8J'B$M22494861 peer wallet keysITPUB个人空间N C7pX0P!\IY
  pa wallet keys
+cB8Xt2|2Q22494861 peer cert requestITPUB个人空间@5vTT3`.J)`"]
  pa cert requestITPUB个人空间k Y%CD1y*b0wo
k
  peer cert
*L-q1fBt7T \$i22494861  pacert

H"v#C$Zv7i!cT
k/K­W­b c22494861  peer root cert TPITPUB个人空间U)O-k3n3Ld
  profile reader root cert TP
Nd
Ip‑vR
\6C22494861  pa root cert TPITPUB个人空间f L |D[1]?i!@l7y+y
  peer pa cert TPITPUB个人空间Nd+Dt^3t A,O
  pa peer cert TPITPUB个人空间wz?OBb
  profile reader pa cert TP
~\*c3n _vK22494861 profile reader peer cert TPITPUB个人空间;r
R
c0W-]q/EQ3~
  peer user certITPUB个人空间Efne6X;m+sR
  pa user cert
!I#y$c@!U!J‑H22494861Addingdaemon to inittab
5_W&E&V3H[1]g!l/a@&J22494861CRS-4123:Oracle High Availability Services has been started.ITPUB个人空间h9y5_%q%B1h2V
ohasd is startingITPUB个人空间{o7o^ Z(\)c
CRS-4123: Oracle High Availability Services has been started.

v"f4yb'\ Z0q


[9x22494861ohasd is startingITPUB个人空间!R n7K
Q
w H0LK-[+r
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
|s1y
tie)hp22494861CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
'jb5Q:M-Y3d:~v0\]22494861CRS-2676:Start of 'ora.gipcd' on 'rac1' succeededITPUB个人空间 f8a4x[1]p!a5k‑I7C
^ rD0s
CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
)da'x
bO22494861CRS-2672: Attempting to start 'ora.gpnpd' on'rac1'ITPUB个人空间(xQ.i7d}.maS
CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded
1h;C/?
N.D/\
]/y22494861CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'ITPUB个人空间;t6ls4D;D
p
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeededITPUB个人空间­T"l#\K%O
H­E+O'n
CRS-2672: Attempting to start 'ora.cssd' on 'rac1'ITPUB个人空间u7Q+l­GV
CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'

J;o/^c [i&yeA22494861CRS-2676: Start of 'ora.diskmon' on'rac1' succeededITPUB个人空间
m$I2t:S cC
CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
[E5c/gt6M22494861CRS-2672:Attempting to start 'ora.ctssd' on 'rac1'
$R3hR+^F3cz:x22494861CRS-2676:Start of 'ora.ctssd' on 'rac1' succeeded

ASM created and started successfully.

DiskGroup CRS created successfully.

clscfg: -install mode specifiedITPUB个人空间


IH6Q$Y(U
Successfully accumulated necessary OCR keys.
-Z)i5ah*^
^{|S22494861Creating OCR keys for user 'root',privgrp 'root'..
:^n­\C#k.t[1]R?22494861Operationsuccessful.
0r9E;h e4F
c)L:}*k22494861CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
_
d Z_
Vu�}22494861CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded
,Py.^-[5v#cz-k+k22494861CRS-4256:Updating the profileITPUB个人空间*gvNQ$N.L~%Ztk
Successful addition of voting disk a81aaf52b2b74ff5bf7a773e7966ea7c.ITPUB个人空间4M Z6N!c[#K8u
Successfully replaced voting disk group with +CRS.
!J0b8A
\�X22494861CRS-4256: Updating the profile
;J8\@(M;s*~qw22494861CRS-4266:Voting file(s) successfully replaced
#}t%v/y)}$A'j22494861## STATE    File UniversalId               File Name Disk group
O
x}Y%~q#}�~9eq22494861--  -----    -----------------               --------- ---------
$w1KB-uQV22494861 1.ONLINE   a81aaf52b2b74ff5bf7a773e7966ea7c (ORCL:CRS1) [CRS]ITPUB个人空间
RI8Y gx.I7E@-e
Located 1 voting disk(s).ITPUB个人空间S Zh{
x$a
g
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
9s&_
_­c ?
P[0@22494861CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
W­r
SG} t'^22494861CRS-2673: Attempting to stop 'ora.asm' on 'rac1'ITPUB个人空间y"gi g |
_*wp7@
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
M8Z4jW1rR }#U22494861CRS-2673:Attempting to stop 'ora.ctssd' on 'rac1'
o0{0D9L5f5n4Ij22494861CRS-2677:Stop of 'ora.ctssd' on 'rac1' succeeded

xu
V-] n_22494861CRS-2673: Attempting to stop 'ora.cssdmonitor' on'rac1'
[1]H[1]e V9i6xa22494861CRS-2677:Stop of 'ora.cssdmonitor' on 'rac1' succeeded

`-Q[1]`$z*K|*v.KN22494861CRS-2673:Attempting to stop 'ora.cssd' on 'rac1'ITPUB个人空间T8E lP(G.e
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
'_
{ u!U\XTR"Z22494861CRS-2673: Attempting to stop 'ora.gpnpd' on'rac1'
~
W*Z
I
~1bAd,j22494861CRS-2677: Stop of 'ora.gpnpd' on 'rac1'succeededITPUB个人空间�\L v*UK8Z:[4B
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
&J+B%s1_Zc22494861CRS-2677:Stop of 'ora.gipcd' on 'rac1' succeeded
[1]G
F/F0}7t)`M
H­pR22494861CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'ITPUB个人空间6Z2M4b
Y.z:{
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
f‑m)~‑K
uF&a;f'T K-N22494861CRS-2672: Attempting to start 'ora.mdnsd'on 'rac1'
8B‑V[1]_
N+?}22494861CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededITPUB个人空间 e3h A-O‑|[1]k1KU-{
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'

o1\;[3^*GL*`
\B%x22494861CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
{H"H#Gd4F5r,^1dI,?-cT$K22494861CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
W8u?‑er22494861CRS-2676: Startof 'ora.gpnpd' on 'rac1' succeededITPUB个人空间"tx[‑A&p7R
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'ITPUB个人空间FPC }w.z1R
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
.j�c!{$l_V3{22494861CRS-2672: Attempting to start 'ora.cssd' on 'rac1'ITPUB个人空间aR d+AJ6k[
CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'ITPUB个人空间 b[1]q;i2|4s­X$]
\
[;@
CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
"XYvGOzt22494861CRS-2676:Start of 'ora.cssd' on 'rac1' succeededITPUB个人空间3x
VK[1]V5vi-M)n
CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'ITPUB个人空间oy1rg;R3Ud
CRS-2676: Start of 'ora.ctssd' on 'rac1' succeededITPUB个人空间T4S1|&mw,b/E
CRS-2672: Attempting to start 'ora.asm' on 'rac1'
+{
t5] A+@22494861CRS-2676: Start of 'ora.asm' on 'rac1' succeeded
iD5N%},ta$Z­d
TAb22494861CRS-2672: Attempting to start 'ora.crsd' on'rac1'
F)vF)l7G22494861CRS-2676:Start of 'ora.crsd' on 'rac1' succeededITPUB个人空间^ Dwf?
CRS-2672: Attempting to start 'ora.evmd' on 'rac1'ITPUB个人空间I7K:C4d3K;J4c:~3n%Cw
CRS-2676: Start of 'ora.evmd' on 'rac1' succeededITPUB个人空间rNZF'|$gT
OT
CRS-2672: Attempting to start 'ora.asm' on 'rac1'
u­_;gN%[[1]}
Y"Eu22494861CRS-2676: Start of 'ora.asm' on 'rac1' succeeded
q7SD)q#UJ22494861CRS-2672:Attempting to start 'ora.CRS.dg' on 'rac1'
w:W5zE5Q
mJ4h5S22494861CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeededITPUB个人空间x/|"u-dR0F)x,Dq
CRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'

_a r:v gC,o22494861CRS-2676: Start of'ora.registry.acfs' on 'rac1' succeeded

rac1     2010/07/2816:31:27     /oracle/app/grid/product/11.2.0/cdata/rac1/backup_20100728_163127.olr
@1G?D(t9j,O‑X~22494861ConfigureOracle Grid Infrastructure for a Cluster ... succeededITPUB个人空间y


I�P#\CSE
Updating inventory properties for clusterwareITPUB个人空间 [M7t/bZ&X
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500MB.   Actual 971 MB    Passed
#GY­X[1]ovFuw22494861The inventory pointer is located at/etc/oraInst.locITPUB个人空间
p2[8J%M6w_
H-aQJ
The inventory is located at /oracle/app/oraInventoryITPUB个人空间@g9o�r&l


x}
'UpdateNodeList' was successful.

 

[root@rac2 soft]# /oracle/app/grid/product/11.2.0/root.sh
GUdY3h22494861RunningOracle 11g root.sh script...

The following environment variables are set as:ITPUB个人空间5l8o#L k!K
    ORACLE_OWNER= gridITPUB个人空间-[‑R)F+`9O
    ORACLE_HOME=  /oracle/app/grid/product/11.2.0

Enter the full pathname of the local bin directory:[/usr/local/bin]:ITPUB个人空间3R/~)g`2r v)Q


}
]
The file "dbhome" already exists in /usr/local/bin.  Overwriteit? (y/n)ITPUB个人空间{V5Xvu[1]f5d0N|
[n]: yITPUB个人空间(DO:u7R ef
   Copying dbhome to /usr/local/bin ...ITPUB个人空间`;l0Q�T3qI~ S
The file "oraenv" already exists in /usr/local/bin.  Overwriteit? (y/n)ITPUB个人空间5|C­}/YZ(e"a6X
[n]: yITPUB个人空间
P i$MK;g.{[1]w
f
   Copying oraenv to /usr/local/bin ...
c6i7u
Q5YZC,Mx-YN22494861The file "coraenv" already existsin /usr/local/bin.  Overwrite it? (y/n)ITPUB个人空间$K
J*q*w aGT
O)A
[n]: y
.?/v@~.V@t[ d
^22494861   Copying coraenv to /usr/local/bin...

Entries will be added to the /etc/oratab file as neededby
n2T7h`
s N
^w@2x
`22494861Database Configuration Assistant when a database is created
H8{A/Z
n22494861Finished running generic part of root.sh script.ITPUB个人空间 FD4^[1]AE%h:N
Now product-specific root actions will be performed.ITPUB个人空间"b


pE,T{#_e[1]RQ
2010-08-02 14:32:28: Parsing the host nameITPUB个人空间{.}!a-zh
w
2010-08-02 14:32:28: Checking for super user privilegesITPUB个人空间7K1S!N OQ.C
2010-08-02 14:32:28: User has super user privileges
Qv%ZSe
@22494861Using configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_params
`k,uh~22494861Creatingtrace directory
g,pfZ'c/c22494861LOCAL ADDMODEITPUB个人空间$TL5yOY
Creating OCR keys for user 'root', privgrp 'root'..
'r‑qNBx,W22494861Operationsuccessful.
H/l7B;sm
l&T22494861Adding daemon to inittab
‑e L1TyDG9M.c3F22494861CRS-4123:Oracle High Availability Services has been started.ITPUB个人空间;c,G+]‑N
n&N#P
P'B6c7t
ohasd is startingITPUB个人空间(R&v+G0n‑aR‑v5y%r
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSSdaemon on node rac1, number 1, and is terminatingITPUB个人空间:^ s.J"g­}z$^O X
An active cluster was found during exclusive startup, restarting to join theclusterITPUB个人空间 e�RO'g6y
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac2'ITPUB个人空间 ?O$jrq
h{�bI
CRS-2676: Start of 'ora.mdnsd' on 'rac2' succeededITPUB个人空间!Zh1~4v*M~
CRS-2672: Attempting to start 'ora.gipcd' on 'rac2'ITPUB个人空间
D}q i+bB7P.}*v
YVk
CRS-2676: Start of 'ora.gipcd' on 'rac2' succeeded
u9@
h4c7j"^C`22494861CRS-2672: Attempting to start'ora.gpnpd' on 'rac2'ITPUB个人空间*j5D)E!fY#M(a
CRS-2676: Start of 'ora.gpnpd' on 'rac2' succeeded
g/A0L/Fe5UoW‑}22494861CRS-2672:Attempting to start 'ora.cssdmonitor' on 'rac2'
P1~X3C$s
p22494861CRS-2676: Start of 'ora.cssdmonitor' on 'rac2'succeeded
Og-[
w&Zfq1V22494861CRS-2672: Attempting to start'ora.cssd' on 'rac2'
~ d%wP6\22494861CRS-2672:Attempting to start 'ora.diskmon' on 'rac2'ITPUB个人空间D/L8O+g
Mx
^+d
CRS-2676: Start of 'ora.diskmon' on 'rac2' succeeded
e
M.Ngym9j'd?([22494861CRS-2676: Start of 'ora.cssd' on 'rac2'succeeded
@w-z4{ XR22494861CRS-2672:Attempting to start 'ora.ctssd' on 'rac2'ITPUB个人空间"r/o_X,rj8\7}k
CRS-2676: Start of 'ora.ctssd' on 'rac2' succeededITPUB个人空间*Q8R{N}:qF`
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'rac2'ITPUB个人空间
S3a
lW6eeP4O8J
CRS-2676: Start of 'ora.drivers.acfs' on 'rac2' succeeded
q.?6cz$J{Q22494861CRS-2672:Attempting to start 'ora.asm' on 'rac2'

{~X‑FN22494861CRS-2676: Start of 'ora.asm' on 'rac2' succeededITPUB个人空间[1]t1|!]aP
}/s9?2Q4Q
CRS-2672: Attempting to start 'ora.crsd' on 'rac2'
)n%H
m
{$R/K‑b5Z22494861CRS-2676: Start of 'ora.crsd' on'rac2' succeededITPUB个人空间 m‑?8Q@[1]|&X t}[1]g2H
CRS-2672: Attempting to start 'ora.evmd' on 'rac2'
-U
B/cd5v­~^%?(\-w(x:mf
d22494861CRS-2676: Start of 'ora.evmd' on 'rac2' succeeded

rac2     2010/08/0214:37:51     /oracle/app/grid/product/11.2.0/cdata/rac2/backup_20100802_143751.olrITPUB个人空间0zb c
@ENp[J'y+D
Configure Oracle Grid Infrastructure for a Cluster ... succeededITPUB个人空间.]txe


Q
~
Updating inventory properties for clusterwareITPUB个人空间 \TN[1]m9vp,Q1ql0O4G
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500MB.   Actual 1202 MB    Passed
ae-`4FrT22494861Theinventory pointer is located at /etc/oraInst.locITPUB个人空间&KH/T+RG(\/k$O
The inventory is located at /oracle/app/oraInventoryITPUB个人空间j


E Tv W;q`
'UpdateNodeList' was successful.

ITPUB个人空间
NTSE2Ez
[grid@rac2 ~]$ srvctl enable oc4j
0M
][1]g1F_:N e22494861PRKO-2116: OC4J is already enabled
O'k-o6@^‑DL22494861[grid@rac2~]$ srvctl start oc4jITPUB个人空间#LZ&z*h[1]l iP$D l@}-N
[grid@rac2 ~]$ srvctl enable nodeapps
2d/dz
v0H:J"r2[‑v22494861PRKO-2415 : VIP is already enabled on node(s):rac1,rac2


RX[3pa&oP22494861PRKO-2416 : Networkresource is already enabled.ITPUB个人空间-O@ X
V�l ?8c7[+Y
PRKO-2417 : ONS is already enabled on node(s): rac1,rac2ITPUB个人空间�_(b,tTzC^S5k
PRKO-2418 : eONS is already enabled on node(s): rac1,rac2

[grid@rac2 ~]$ crs_stat -t
/{)F"r&b-Ss22494861Name          Type          Target    State    Host       
r u;~
s.{Z^‑U*j22494861------------------------------------------------------------
]hV(K?^22494861ora.CRS.dg    ora....up.type ONLINE    ONLINE   rac1       ITPUB个人空间C8y5c3`9Yg
ora....ER.lsnr ora....er.type ONLINE    ONLINE   rac1       ITPUB个人空间"g`K9dk
d[1]EH
R9^
ora....N1.lsnr ora....er.type ONLINE    ONLINE   rac1       
&\-\"PC


OS22494861ora.asm       ora.asm.type   ONLINE    ONLINE   rac1       ITPUB个人空间6U xdps0Z­@
ora.eons       ora.eons.type ONLINE    ONLINE   rac1       ITPUB个人空间NQ4T? ZqPJ+w
ora.gsd        ora.gsd.type  ONLINE    ONLINE   rac1       ITPUB个人空间w5BI4p2HX
h[
ora....network ora....rk.type ONLINE    ONLINE   rac1       
6iu#l"}L K\
|
X22494861ora.oc4j      ora.oc4j.type  ONLINE    ONLINE   rac2       
v;g(Z
c+_e22494861ora.ons       ora.ons.type   ONLINE    ONLINE   rac1       

G%k*z`-R+u22494861ora....SM1.asmapplication    ONLINE    ONLINE   rac1       ITPUB个人空间;g c
F _rA
ora....C1.lsnr application    ONLINE   ONLINE    rac1       ITPUB个人空间�Z
u-C
a0WI.z
ora.rac1.gsd   application    ONLINE   ONLINE    rac1       

P%Rp8QE22494861ora.rac1.ons   application   ONLINE    ONLINE   rac1       ITPUB个人空间N:gN0[6u+Es
ora.rac1.vip   ora....t1.type ONLINE   ONLINE    rac1       
0yAb3h%{N ? [uN22494861ora....SM2.asmapplication    ONLINE    ONLINE   rac2       ITPUB个人空间E5I%Vj6l#P
k
ora....C2.lsnr application    ONLINE   ONLINE    rac2       
8m$TqhOz-Z:lT:Q22494861ora.rac2.gsd  application    ONLINE    ONLINE   rac2       ITPUB个人空间f2Fi&H sZ$}3C[$ooh I
ora.rac2.ons   application    ONLINE   ONLINE    rac2       
9? Ty)f
q ?­l{/c/C`22494861ora.rac2.vip   ora....t1.typeONLINE    ONLINE   rac2       ITPUB个人空间*PD h'u-Q
ora....ry.acfs ora....fs.type ONLINE    ONLINE   rac1       ITPUB个人空间-hv‑z:`9^{)?"Pu
ora.scan1.vip  ora....ip.type ONLINE   ONLINE    rac1 

ITPUB个人空间­V1q$drL/T
 

资源组状态:
yyN \m!T`22494861crsctlstatus resource -t

[grid@rac2 ~]$ crsctl status resource -t


&zO~o
@%w RHO/{O22494861NAME          TARGET  STATE       SERVER                  STATE_DETAILS       Local ResourcesITPUB个人空间mc%g'dH+i
B
ora.CRS.dg
l @p
hp22494861              ONLINE  ONLINE      rac1                                        ITPUB个人空间*qx1p$D D4W
              ONLINE  ONLINE      rac2                                        
8P a4BPe22494861ora.LISTENER.lsnrITPUB个人空间$J!r
]_g{
              ONLINE  ONLINE      rac1                                        ITPUB个人空间O3^9}v\L:x‑Qh9h(D
              ONLINE  ONLINE      rac2                                        ITPUB个人空间I[1]S$hx-u
ora.asm
K.V0[c‑p2m;byl22494861              ONLINE  ONLINE      rac1                    Started            
B&\'u XT/q22494861              ONLINE  ONLINE      rac2                    Started            
&o$op)_


N(c[1]g#t‑U
k22494861ora.eons

p0~4?'`MnI22494861              ONLINE  ONLINE      rac1                                        ITPUB个人空间6k'MsR#C1Qm‑])f
              ONLINE  ONLINE      rac2                                        
!@*^;O/S ?q22494861ora.gsdITPUB个人空间*O,iCb }~!U*my
              ONLINE  ONLINE      rac1                                        
G
A8VG u)l"h22494861              ONLINE  ONLINE      rac2                                        
c)f,NU%Z$v)t4{5a22494861ora.net1.networkITPUB个人空间r.U
F |'Z e~-n
              ONLINE  ONLINE      rac1                                        ITPUB个人空间 E
b)t#x
Zi
Iz2y
              ONLINE  ONLINE      rac2                                        
C2t
H:P�m[1]D
a"n,J22494861ora.onsITPUB个人空间N'e2}‑{;B
              ONLINE  ONLINE      rac1                                        
J0f1B w­w22494861              ONLINE  ONLINE      rac2                                        
mVS{ Zp4u22494861ora.registry.acfs
7E V.B(v�O#~ [l9}22494861              ONLINE  ONLINE      rac1                                        ITPUB个人空间 F5]
Fa]]+x
p)L#EQ
              ONLINE  ONLINE      rac2     

                                   ITPUB个人空间H
e J7x U`y"v
Cluster Resources

ITPUB个人空间 k(?6x$e.VH1az^G
ora.LISTENER_SCAN1.lsnrITPUB个人空间.X }
R*D5T/\ J
      1       ONLINE  ONLINE      rac1                                        
U~�F7p V


D22494861ora.oc4j
(K ^
Y;[K$p22494861     1        ONLINE ONLINE      rac2                                        
,PN A%d[1]J-u22494861ora.rac1.vipITPUB个人空间v;|r\:fw!Cz l
      1       ONLINE  ONLINE      rac1                                        ITPUB个人空间4g5vr4I{.l^M
u
ora.rac2.vipITPUB个人空间)F b:y[1]] gq`1V
      1       ONLINE  ONLINE      rac2                                        ITPUB个人空间j:{[1]i�i+p:m%A
ora.scan1.vip

xJBDfC‑A
hg22494861     1        ONLINE ONLINE      rac1                                    ITPUB个人空间+j.pxH+f^@.C6_)^
  

检查集群节点:
jr2\J)N


md22494861olsnodes -l

检查 Oracle 集群注册表 (OCR):

ocrcheck

[grid@rac1 ~]$  ocrcheck
/O({q_UQ/K8U22494861Statusof Oracle Cluster Registry is as follows :ITPUB个人空间6gS6yHn
        Version                 :          3ITPUB个人空间J3d7C


ge,dm
         Total space(kbytes)     :     262120
r Ds1Lr
F }22494861         Used space(kbytes)      :      2404
^ f9V%n%S
VJo{22494861         Availablespace (kbytes) :     259716ITPUB个人空间$tU,l6[+vPQ
        ID                      : 1095774749

M
GV9e!P3| M'J22494861        Device/File Name        :       +CRS
pt9i!yR/Ms;U
Q22494861                                   Device/File integrity check succeeded

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

         Clusterregistry integrity check succeeded

         Logicalcorruption check bypassed due to non-privileged user

  
3x
G5Q
d
BZc22494861  ITPUB个人空间0fO\S-b)U‑E2J5?
[grid@rac2 ~]$ ocrcheckITPUB个人空间 S9[Yx]tTU
Status of Oracle Cluster Registry is as follows :
#F&K\!`5e
n5v[#Oe#r22494861        Version                 :          3ITPUB个人空间'}%S+gO%E�w­R


s|
         Total space (kbytes)    :     262120ITPUB个人空间
A)l$s\5m@
         Used space(kbytes)      :      2404ITPUB个人空间#h�Z­z.w,Kt1f
         Available space (kbytes):     259716ITPUB个人空间 eH4W*oH‑S
        ID                      : 1095774749
+Z%@{+vZ
w&G m
B22494861        Device/File Name        :       +CRSITPUB个人空间 _ c?S­Z
                                   Device/File integrity check failed

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

                                   Device/File not configured

         Clusterregistry integrity check failed

         Logicalcorruption check bypassed due to insufficient quorum

检查表决磁盘:

crsctl query css votedisk

[grid@rac1 ~]$ crsctl query css votedisk
YuY\5A I#K22494861## STATE    File UniversalId               File Name Disk group
K2d5Xag W4z22494861-- -----   -----------------               --------- ---------
|(?(Jy*ab22494861 1.ONLINE   589c0071c9304fecbff651e64eeb281a (ORCL:CRS1) [CRS]ITPUB个人空间.w C(w"xV0`
Located 1 voting disk(s).

ITPUB个人空间o:}x"Y,OU
Gu6M@
Oc4j,gsd服务默认是disable的,如果要启动,启用即可ITPUB个人空间rC3H9tg
[node1:grid]srvctl status oc4j
n
v"|q{22494861OC4J is disabled

[node1: grid]srvctl status nodeappsITPUB个人空间q5mEi$X
VIP node1-vip is enabledITPUB个人空间TY5pzSE0E
VIP node1-vip is running on node: node1
gu6^'T}9w5l‑u)B22494861VIPnode2-vip is enabledITPUB个人空间[�y-i5R,SI$N
VIP node2-vip is running on node: node2
6b.G
j2j!{&c-L [*J22494861Network is enabledITPUB个人空间;n`'~"?Y:~p
Network is running on node: node1ITPUB个人空间+J5LW8c-XB‑H
Network is running on node: node2
q1\/}K2o!w22494861GSDis disabledITPUB个人空间3a tIN8~xkM
^1Z[1]f
GSD is not running on node: node1
7J-V(P


h'k5u‑N22494861GSD is not running on node: node2ITPUB个人空间#Q-wP-N
y
ONS is enabledITPUB个人空间a;jPBefS
ONS daemon is running on node: node1ITPUB个人空间
u‑~['q]h*z
`
N9[&m
ONS daemon is running on node: node2
,}2S)]z‑wZ6`"t22494861eONSis enabledITPUB个人空间5J Y;\T�A UW-}^$ak#J
eONS daemon is running on node: node1
"l*xe1L'P+wG22494861eONSdaemon is running on node: node2

[node1:grid]$srvctl enable oc4jITPUB个人空间2Z[1]M8J!oO­I)J(xO­A4t
[node1:grid]$srvctl start oc4j
­M+c


\
[5`/P ]1{"iH�b![22494861[node1:grid]$srvctl enable nodeapps
,uj+^L8A0s[1]@�p Ti­J22494861[node1:grid]$srvctl start nodeapps

重启grid cluster

ITPUB个人空间:[XO"p)z
为数据和快速恢复区创建 ASM 磁盘组:ITPUB个人空间


Q/Nk zA}
f:[W
g~
asmcaITPUB个人空间(g"R*v2F
Q.T_

 

su - oracle
[1]u


[0w#j0lx
?&|22494861./runInstaller

[root@rac2 ~]# /oracle/app/oracle/product/11.2.0/root.sh
3n6x!he‑j22494861RunningOracle 11g root.sh script...

The following environment variables are set as:
"[ga&Wn g-`$z22494861   ORACLE_OWNER= oracle
bDs4v4[­F1^?22494861   ORACLE_HOME=  /oracle/app/oracle/product/11.2.0

Enter the full pathname of the local bin directory:[/usr/local/bin]:
b P/N
lG {*E b&C22494861The file "dbhome" already exists in/usr/local/bin.  Overwrite it? (y/n)
t1ZBF}2AK


u22494861[n]: y
#x6y.Z-t6D
q(k‑\22494861   Copying dbhome to/usr/local/bin ...
J[1]z6?+a!y!K$x22494861Thefile "oraenv" already exists in /usr/local/bin.  Overwrite it?(y/n)ITPUB个人空间 ^
k9Tdx%zd"X
t
[n]: yITPUB个人空间(l.LY,h)q*@5[.Y{:Qaz
   Copying oraenv to /usr/local/bin ...
Nl)e(J^22494861The file"coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
B&m}l9U1u;e(Y22494861[n]:y
hO'oCXI)uw4n3s%p22494861  Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as neededbyITPUB个人空间0rh3{/?O‑k6p
Database Configuration Assistant when a database is createdITPUB个人空间7b^tZ-f ^
Finished running generic part of root.sh script.
3}7z)j�aY-DR)["m3c22494861Now product-specific root actions will be performed.
-w@+Z A ]+m u3mo22494861Finishedproduct-specific root actions.

[root@rac2 ~]# crs_stat -t

 

 

Creating /etc/oratab file...z'N!?)h'Mfm
Entries will be added to the /etc/oratab file as needed byG7A1Mpvp�k
Database Configuration Assistant when a database is createdspace.itpub.net:U
r5H[1]e:w
a;Q`)RF
Finished running generic part of root.sh script.oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net TN�?$G
X/cy
Now product-specific root actions will be performed.ITPUB个人空间$v


?(s�E2l'q9o
Fq~
2010-07-28 16:19:03: Parsing the host name

B
]5k�m3^H2010-07-28 16:19:03: Checking forsuper user privileges
        B3yR
a&g#d
sITPUB个人空间2010-07-28 16:19:03: User has super user privileges

r0O
_ i^[1]R;\(xITPUB个人空间Usingconfiguration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_paramsz!OMkdAK‑T
Creating trace directory
‑E'hj6@U(W
GE
xLOCAL ADD MODE
u­r~m­o,yCreating OCR keysfor user 'root', privgrp 'root'..
ClN4~
r[1]yITPUB个人空间Operationsuccessful.
M8jG'E
R!D1s\!Poracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net  rootwallet
?[)?
H(k  root wallet certspace.itpub.net(H
U
r7Hu;Qi.Z
  root cert export~�qxdl#u.oo
  peer walletoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netq
z
q[1]nw7Pk
D
L
  profile reader wallet
(S,qJu       d.[8^0Rss  pa wallet
V}Ow-_2^B6t*p
[space.itpub.net  peer wallet keysi5Q
vA*s
q+iq'O
  pa wallet keysoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net3[_T
zu�[H$[
  peer cert request
*gW1? [@oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net  pacert request
U'i:n-ay6N/|
l4M        j/b
  peer certITPUB个人空间9pHa;lM6x7^5}3QV
  pa certspace.itpub.net4AzVwl
  peer root cert TP
;f$P*K4S
F-}  profile reader root cert TPp
Z.I‑pi kxW}
  pa root cert TPoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net8P
m[N­K,qo
  peer pa cert TPspace.itpub.net8L@pz-w}@
  pa peer cert TP
f?(W"]
|
M&k2i$X  profile reader pa cert TP

{$B2h4yZ
CSxu  profile reader peer cert TP­v+m"?6vC‑T
  peer user certspace.itpub.net!p*Q8a0P9l
MAx4`!U
  pa user cert)sFp+\M}n
Lj
mP
Adding daemon to inittaboracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net}
sFJV
CRS-4123: Oracle High Availability Services has been started.ITPUB个人空间{
{A!g1PR
ohasd is starting]c       l[1]|)oo
f^
CRS-4123: Oracle High Availability Services has been started.
elvm:b
{'HF        tTohasd is starting3Fe$W9a*d5k#bD
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
!K
s"ZBqB o-Moracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCRS-2672:Attempting to start 'ora.mdnsd' on 'rac1'AA9Ab$r\ P'_V.J
CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded-Y:T6z Kh6?­b
W#Rd
CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
‑|
Z#OF.eaCRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
;k$Ar7a       F7t8l
}3\d/DCRS-2676: Start of 'ora.gpnpd' on 'rac1'succeeded

M‑WY9p;x        z0wMspace.itpub.netCRS-2672:Attempting to start 'ora.cssdmonitor' on 'rac1'j'[�wU
l.h
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
(B*D­~:P/fE
[oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCRS-2672:Attempting to start 'ora.cssd' on 'rac1'space.itpub.net
J7vY        f1tw
CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'space.itpub.netD
g5r­f`
CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
­b‑Gd;}­p"H!`‑wCRS-2676:Start of 'ora.cssd' on 'rac1' succeeded

NL8p3DZ%lQ[w0Coracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCRS-2672:Attempting to start 'ora.ctssd' on 'rac1'
[1]b+~       B;F)wD-X#zITPUB个人空间CRS-2676: Start of'ora.ctssd' on 'rac1' succeeded+r+DS*r
X-{*J:P
ASM created and started successfully./JFa0BK
DiskGroup CRS created successfully.ITPUB个人空间&h0w‑N6UyO2{
clscfg: -install mode specified
)a9@v,j-{
W%dBsoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSuccessfullyaccumulated necessary OCR keys.
(C5@u7yW7s){|       Y        kSCreating OCR keys for user'root', privgrp 'root'..
~L/?Z‑t|ALeW!lspace.itpub.netOperationsuccessful.

f�Z
M)}
JCRS-2672: Attempting to start 'ora.crsd' on 'rac1'
`2V X5d^(bSB0^.nCRS-2676:Start of 'ora.crsd' on 'rac1' succeeded
T]
@:e;v+mITPUB个人空间CRS-4256: Updating the profile
3t
tn,?v3Pspace.itpub.netSuccessful addition of voting diska81aaf52b2b74ff5bf7a773e7966ea7c.
E6~)fH0{       [(T�r$p&qoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSuccessfully replaced voting disk group with +CRS.
HEd
xj%qmoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCRS-4256:Updating the profileoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net8q[gV1~?fn
CRS-4266: Voting file(s) successfully replaced
5`Dx(Kk0y;o(k
G2e"d##  STATE    File Universal Id               File Name Disk grouporacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
l!C5{K‑Ht
--  -----    -----------------               --------- ---------
;k\'SD;C
DH 1. ONLINE   a81aaf52b2b74ff5bf7a773e7966ea7c(ORCL:CRS1) [CRS]
[1]tY6M%`
A1BzLocated 1 voting disk(s).
,c}D       \1F#\�GCRS-2673: Attempting to stop 'ora.crsd'on 'rac1'oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net(R$C)gN
]CF4V#]m&y
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
^8o
cd4{4I‑Xoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCRS-2673:Attempting to stop 'ora.asm' on 'rac1'
@
RE5H        BCRS-2677: Stop of'ora.asm' on 'rac1' succeededITPUB个人空间8KS*wi-kJ
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
[1]k+w3^
T.@-h.ACRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded%TY5E*K8@7M
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'
/B!^
zo(Y7a@:^ITPUB个人空间CRS-2677: Stop of 'ora.cssdmonitor'on 'rac1' succeeded

_
d6_?        Ig­XaCRS-2673: Attempting tostop 'ora.cssd' on 'rac1'oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
nx
_&^[1]t2E
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded

FD
ma/u3~ITPUB个人空间CRS-2673: Attempting to stop'ora.gpnpd' on 'rac1' f
]^0M-KFS
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeededr\K,[@t9D4n
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
H"mS,eI~0S
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
r&m7X
Z
Y1DBO
\'t        mCRS-2673: Attempting to stop 'ora.mdnsd'on 'rac1'5Un(X8{
S*c&vH)Z
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeededspace.itpub.net8AM ?2F
m`
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'ITPUB个人空间‑C
T.R0O�f�x
R+Q
CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeededK!mX�EB7tM4Y
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
9?;m9E        P7bA.U9oK�}CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
7Y[1]y)Knr
V U#rG|CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
,g
JOI­z
M�C,|ITPUB个人空间CRS-2676: Start of 'ora.gpnpd' on'rac1' succeeded
v%v‑Gij.k
FKwITPUB个人空间CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'space.itpub.net-k­`|s
Z'ZeX
CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded
V-j+y[1]ZO{*T/u5rCRS-2672:Attempting to start 'ora.cssd' on 'rac1'

^g(B!n�EITPUB个人空间CRS-2672: Attempting to start'ora.diskmon' on 'rac1'
1_ @­ET
GF
d
D8XCRS-2676: Start of 'ora.diskmon' on 'rac1' succeededY*\9MP0b:Ym
CRS-2676: Start of 'ora.cssd' on 'rac1' succeededoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netMq(DEI3oM]c&P
CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'
X)b;ovTeoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCRS-2676:Start of 'ora.ctssd' on 'rac1' succeeded
,}6Dl[1]z!x,[rITPUB个人空间CRS-2672:Attempting to start 'ora.asm' on 'rac1':s
_@­X:?/w9H
CRS-2676: Start of 'ora.asm' on 'rac1' succeededITPUB个人空间'F(t$y3j
S8E+S&S
CRS-2672: Attempting to start 'ora.crsd' on 'rac1'space.itpub.net)U*Z6tg4}I&O,L
Z
CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded-]wE6D5Jy:I
E
CRS-2672: Attempting to start 'ora.evmd' on 'rac1'
[1]m‑A
A*{SX+I R3?        \CRS-2676: Start of 'ora.evmd' on'rac1' succeededspace.itpub.net1Dm[1]g}&i*g%G
GL­M]"R
CRS-2672: Attempting to start 'ora.asm' on 'rac1'9k'g‑y/A%h)x0M
CRS-2676: Start of 'ora.asm' on 'rac1' succeededITPUB个人空间8{E4q)j8o+_zk
CRS-2672: Attempting to start 'ora.CRS.dg' on 'rac1'&l:Wq8b{.j6OF
CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeeded

|8MMN[
BITPUB个人空间CRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'       oGD5J"s0n$ER
CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeeded
)h
Ey�|1[4Q1?a#Grac1    2010/07/28 16:31:27    /oracle/app/grid/product/11.2.0/cdata/rac1/backup_20100728_163127.olr
-e[1]uh*Lp/{!w0k@oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netConfigureOracle Grid Infrastructure for a Cluster ... succeeded‑Dpy%s*G$sA#b:`
Updating inventory properties for clusterware
8oL:^l[1]}DITPUB个人空间StartingOracle Universal Installer...
$gB8[ GJd
v8~
Rw
DChecking swap space: must be greater than 500MB.   Actual 971 MB    Passed

D0l
yy*O‑muYITPUB个人空间The inventory pointer is located at/etc/oraInst.locoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net&V+X]+^d}"~Nr
w
The inventory is located at /oracle/app/oraInventoryspace.itpub.net­rY
S4YS.^'n|y$z
'UpdateNodeList' was successful.
e!H:JV[space.itpub.net'C*a7W;Ao'o$w
[root@rac2 soft]# /oracle/app/grid/product/11.2.0/root.sh[1]\­O;Sx
L6J
B[1]Y!v
Running Oracle 11groot.sh script...
k‑d
bp#N‑r6h;xThe following environment variables are set as:$z
Y7I|2R;k
eLa
    ORACLE_OWNER= grid
        t8|,G
[�I._?)m   ORACLE_HOME=  /oracle/app/grid/product/11.2.0PW#@
{
oS�b-e@
Enter the full pathname of the local bin directory: [/usr/local/bin]: ?)kk$yI!y
z`­{4X
YVGZ
The file "dbhome" already exists in/usr/local/bin.  Overwrite it? (y/n)
i^ @
v m[n]: yBl%`L'l­w       H|
   Copying dbhome to /usr/local/bin ...ITPUB个人空间!B-{+Pw‑?­~
The file "oraenv" already exists in/usr/local/bin.  Overwrite it? (y/n)

w4x+v.r^%m;g[n]: y
I­Yx       jH,dspace.itpub.net   Copying oraenv to /usr/local/bin...space.itpub.netAD]\kAh_       A�]+l
The file "coraenv" already exists in/usr/local/bin.  Overwrite it? (y/n)
LB-U xkn'k‑~NITPUB个人空间[n]: y
.r�JJ0d3t+l,Dp:\   Copying coraenv to /usr/local/bin ...
f_*R5gs'h/gEntrieswill be added to the /etc/oratab file as needed by
1f#b:E`2W6{_f@DatabaseConfiguration Assistant when a database is created
FWY
u
k`Finished running generic part of root.sh script.
.\(x
l j:}#zT&B0Y(@2Aoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netNowproduct-specific root actions will be performed.)u
w8W­{;w'j!p
2010-08-02 14:32:28: Parsing the host name
2gh
r(_#q        \�a&H5@2010-08-02 14:32:28: Checking for super user privileges
X[1]kX%v;{"L!O2010-08-0214:32:28: User has super user privileges
g5i K[QEspace.itpub.netUsingconfiguration parameter file:/oracle/app/grid/product/11.2.0/crs/install/crsconfig_params
TvA*H$u(xCreating tracedirectory
.L!g‑y
Z[1]^
k!SLOCAL ADD MODE
htSO%E       mM7roracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCreatingOCR keys for user 'root', privgrp 'root'..
z
P1d)p
aoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netOperationsuccessful.[1]M2V
PgD
F
Adding daemon to inittaboracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netG;Q
ts%V*_,X[iJ
CRS-4123: Oracle High Availability Services has been started.-PW:_2]}4j5Y
F&c#Fe
ohasd is starting7T­mu
G&F}
J%L
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSSdaemon on node rac1, number 1, and is terminating0A
[
HH!T
An active cluster was found during exclusive startup, restarting to join theclusterJ`
C
l7qa�?4r
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac2'
WUO
K9Ke/M5y.g GtCRS-2676: Start of 'ora.mdnsd' on 'rac2' succeeded&y:tp‑Xe?Ky
CRS-2672: Attempting to start 'ora.gipcd' on 'rac2'(a
q7?9g
]$\q`
CRS-2676: Start of 'ora.gipcd' on 'rac2' succeeded
j+~       q4~*I        pFX'l4e-A8hITPUB个人空间CRS-2672:Attempting to start 'ora.gpnpd' on 'rac2'
s$dK2FtCRS-2676: Start of'ora.gpnpd' on 'rac2' succeeded
{FH;{Ku0Ej5QCRS-2672:Attempting to start 'ora.cssdmonitor' on 'rac2'

H
^%vT3i_;|?TS'k8RCRS-2676: Start of 'ora.cssdmonitor' on 'rac2'succeeded
f7CwIx.I-sCRS-2672:Attempting to start 'ora.cssd' on 'rac2'ITPUB个人空间B
e1P        ut­c
E8dy%m
CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'hLl$c2u
CRS-2676: Start of 'ora.diskmon' on 'rac2' succeeded
7e;th!~       H1Z.H)@space.itpub.netCRS-2676: Start of 'ora.cssd' on 'rac2' succeeded
8W
wA�sG-C[CRS-2672: Attempting to start'ora.ctssd' on 'rac2'ITPUB个人空间b)o+Fkx
CRS-2676: Start of 'ora.ctssd' on 'rac2' succeeded
Hl2j[k*k9hBspace.itpub.netCRS-2672:Attempting to start 'ora.drivers.acfs' on 'rac2'
;N        h3]­ej
y)n+BCRS-2676: Start of 'ora.drivers.acfs' on 'rac2'succeededm*J8i:C       ur!E&X W
CRS-2672: Attempting to start 'ora.asm' on 'rac2'le|;a4J3|R2v
CRS-2676: Start of 'ora.asm' on 'rac2' succeeded-iSz%A+|K2B)M$E
CRS-2672: Attempting to start 'ora.crsd' on 'rac2'
JJ'~2Jkjy5\#ACRS-2676:Start of 'ora.crsd' on 'rac2' succeededoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net‑BNK/q[g
CRS-2672: Attempting to start 'ora.evmd' on 'rac2'
{S‑q[1]t+H|Z
M"c?ITPUB个人空间CRS-2676: Start of 'ora.evmd' on'rac2' succeeded
#jY;uYjf&_#I)_&m
@.UITPUB个人空间rac2     2010/08/02 14:37:51    /oracle/app/grid/product/11.2.0/cdata/rac2/backup_20100802_143751.olr
^f|[1]gU,xg$zp0K#Z5xoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netConfigureOracle Grid Infrastructure for a Cluster ... succeededoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net:xh
v
g+s8Bh
Updating inventory properties for clusterware
(~#iu
`XC0[Starting Oracle Universal Installer...
1x
FD\
y(AzChecking swap space: must be greater than 500 MB.   Actual1202 MB    Passed
[1]E,b+YI/D
_9}­Loracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netTheinventory pointer is located at /etc/oraInst.locs^­}
r3a-t$w
The inventory is located at /oracle/app/oraInventoryoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net9H#I
R
a�R T
'UpdateNodeList' was successful.oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net8Bz*X.Gl#Y!j$w
f9A‑K*Fv       f&`
[grid@rac2 ~]$ srvctl enable oc4j
        F       O-\!xfPRKO-2116 : OC4J is already enabled0[)n6v9NJNa,n�j`e
[grid@rac2 ~]$ srvctl start oc4j
!S9_)H0zn%^
n-mITPUB个人空间[grid@rac2 ~]$ srvctl enable nodeappse5_
pw�YhF
U%n1Dt
PRKO-2415 : VIP is already enabled on node(s): rac1,rac2
"q
[u*s­E!X.V:A‑N‑k:A[1]yoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netPRKO-2416: Network resource is already enabled.[1]\
G)@
r!c/F
K+h
PRKO-2417 : ONS is already enabled on node(s): rac1,rac2/Bp[1]Kb'x:A[1]x
PRKO-2418 : eONS is already enabled on node(s): rac1,rac2oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net+}
^­x7@
U%J0VI*P!~
[grid@rac2 ~]$ crs_stat -t`‑V
jz#km[#v
Name           Type          Target    State    Host        
a(@%d5q+Uoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net------------------------------------------------------------oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netx$FO*EX
ora.CRS.dg     ora....up.type ONLINE   ONLINE    rac1        space.itpub.net�\b
]+[
G&DZ
ora....ER.lsnr ora....er.type ONLINE    ONLINE   rac1        
p/N*\%[
c‑g:ztora....N1.lsnr ora....er.type ONLINE    ONLINE   rac1        
.V‑pb6[Goracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora.asm       ora.asm.type   ONLINE   ONLINE    rac1        
1mAQ&i7p­Nora.eons      ora.eons.type  ONLINE    ONLINE   rac1        :wf;eb‑h
l(wM
ora.gsd        ora.gsd.type  ONLINE    ONLINE    rac1       
#d$W‑n+W*UT)b[LdITPUB个人空间ora....networkora....rk.type ONLINE    ONLINE    rac1       space.itpub.net�r1D:^[)m(Y
P�r9^\j
ora.oc4j       ora.oc4j.type  ONLINE   ONLINE    rac2        ITPUB个人空间;j%i(o6Q#D)ia2T
ora.ons        ora.ons.type  ONLINE    ONLINE    rac1       8u
XR-x hd#Q
V
ora....SM1.asm application    ONLINE    ONLINE   rac1        

g        e�A(F�ub'@ora....C1.lsnrapplication    ONLINE    ONLINE    rac1       
\(M]*I%V:Vora.rac1.gsd  application    ONLINE    ONLINE   rac1        `$w5~"x)R­@*w
ora.rac1.ons   application    ONLINE   ONLINE    rac1        I1l
j
T(Q1P
ora.rac1.vip   ora....t1.type ONLINE    ONLINE   rac1        
{"rtyS.Sspace.itpub.netora....SM2.asmapplication    ONLINE    ONLINE    rac2       :j4\+o^)O7a?$P1_
P
ora....C2.lsnr application    ONLINE    ONLINE   rac2        

f5W{_
D"T[1]F3Xoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora.rac2.gsd  application    ONLINE    ONLINE   rac2        oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net4Ez8y�EMzH
ora.rac2.ons   application    ONLINE   ONLINE    rac2        
        xn�N
]2Ioracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora.rac2.vip   ora....t1.type ONLINE   ONLINE    rac2        
i        Wn
L)^i8O
yora....ry.acfs ora....fs.type ONLINE    ONLINE   rac1        
dl$MB0?(g­dyspace.itpub.netora.scan1.vip  ora....ip.typeONLINE    ONLINE    rac1  space.itpub.net%RG$]2{d‑t1S
n'@Opb!w-B
v
oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
m        S&N­R CL6xs

9Z%\pZ'l(o
K#cITPUB个人空间
.k5r
U[1]Tf
&r
MJ+z/M
N)R资源组状态:^Q`l[1]t8A
crsctl status resource -t
/r�j&r1xS[1]i)fspace.itpub.net[grid@rac2 ~]$ crsctl status resource -t
;EhNH:h9k
/y9ls:Aa
t        Y,vX9Dspace.itpub.netNAME          TARGET  STATE       SERVER                  STATE_DETAILS      Local Resources
.[Q
aa6HGSA7LFspace.itpub.netora.CRS.dg1a8yTz(J*~/i4\.g
              ONLINE  ONLINE       rac1                                      
9IFb5G4v
nspace.itpub.net              ONLINE  ONLINE      rac2                                       
U
o-oI]
d7D[1]y
ora.LISTENER.lsnrspace.itpub.net­s,`x
O1yZ
pP
              ONLINE  ONLINE       rac1                                      
z�wf.l
@4e*q              ONLINE  ONLINE      rac2                                       
X1BP1s       |I#S
wspace.itpub.netora.asm
!_1X:kz5h,io‑i:E%}
pITPUB个人空间              ONLINE  ONLINE       rac1                   Started            
3V/mWrp"P7yOr             ONLINE  ONLINE       rac2                   Started            
;fab;t2G7o])}ora.eonsoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net;u
d8J A u
              ONLINE  ONLINE       rac1                                      S(c1v
[IU;td
              ONLINE  ONLINE       rac2                                      
*?7C~"^z5Bkspace.itpub.netora.gsdH.k�Tg#\-A
              ONLINE  ONLINE       rac1                                      space.itpub.net0vv       h\%]|o
              ONLINE  ONLINE       rac2                                      5~%`6iM
zF!Nn
ora.net1.networkspace.itpub.net4o5xj#?$f*z&E9tV
              ONLINE  ONLINE       rac1                                      
-fJ7?/e9k
{
s              ONLINE  ONLINE       rac2                                      
d
x3d[1]t
u)Sora.ons
E%s][1]Z*[g             ONLINE  ONLINE       rac1                                      
'C(Q6a
y#I^
y8S              ONLINE  ONLINE      rac2                                       
q!Dl\3D
jj
gora.registry.acfsN%w_U8p]
{ P‑g
              ONLINE  ONLINE       rac1                                      ITPUB个人空间
Ij7F']$T
arn
              ONLINE  ONLINE       rac2    oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net%H6a"Hu8N
U[1]w
s-Q
                                  
3eVg[
?9r
V
~!ftoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netClusterResources
8jZ
`"N�y#cU.}fspace.itpub.netITPUB个人空间"nm
?W�VZ
W
ora.LISTENER_SCAN1.lsnrspace.itpub.netA&|/O
h
e8E%?
      1       ONLINE  ONLINE       rac1                                      -MT%N&p8Bx ~qR
ora.oc4jKi
a­L,oHH
      1       ONLINE  ONLINE       rac2                                      
Xe
f/\"Uora.rac1.vip
lv/~i!copQ;Jw
      1       ONLINE  ONLINE       rac1                                      
n+W1k:R,rU%m*g
F#Sora.rac2.vip
gdbX
j(g      1       ONLINE  ONLINE       rac2                                      ~_2j
U?)P‑]4v"D‑K
ora.scan1.vipV3MM6~
Y!A
O/P
      1       ONLINE  ONLINE       rac1                                   .f%T#Q}
E;Hz
e$v4]
   4}xhXc7f5zD)U
检查集群节点:
rdq5j/w,?8Y"`S
W
olsnodes -l
6K8_/p)j(KD"?z"B[‑TITPUB个人空间检查 Oracle 集群注册表 (OCR):oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netz
Chv+h$X~}
ocrcheck
\
O
j[1]CO.e[grid@rac1~]$  ocrcheck
9YBs8\'c3q3s(n'b8[Statusof Oracle Cluster Registry is as follows :oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net[1]q"Mn@{
fvm
[
         Version                 :         3
r!iC-xZ/oE        Total space (kbytes)    :     262120"v$|+[ `;[­}
         Used space (kbytes)      :      2404ITPUB个人空间F
]el1y
         Available space (kbytes) :    259716
NH&K:c
kt)GNZoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net        ID                      : 1095774749oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net+?z#`1B.e
         Device/File Name        :       +CRSspace.itpub.net b#\­K
@~Q
f%n
s        `H:N
                                  Device/File integrity check succeededITPUB个人空间;o
z"O/p[1]iU
                                  Device/File not configured

D(m!_U3PY                                  Device/File not configuredITPUB个人空间"Ox+z:jJs6K*OE­x
                                  Device/File not configuredc4D­WH)[7j
                                  Device/File not configuredoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netC­BM0Q#d9O
         Cluster registry integrity checksucceeded
[1]nLp
SVU(l         Logical corruptioncheck bypassed due to non-privileged user
W%x)X'Q@0[]
YoITPUB个人空间   5k0G       lj*Ix
x[1]]5E
   .e)Y[QT1i‑x
[grid@rac2 ~]$ ocrcheck
8?{@dkv
dJz$~Status of Oracle Cluster Registry is asfollows :oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net\_!y7Pu&QPh
         Version                 :         38d]/j*@|%Ww
         Total space (kbytes)    :     262120A){.J3W!X4nU+o
         Used space (kbytes)     :       2404s
M'?b
b,i1W
         Available space (kbytes) :    259716
‑S
[:N/fn9UITPUB个人空间        ID                      : 1095774749
‑dj
H        y        [4L
gy         Device/File Name        :       +CRS
uu$bg!d6{Y6Q;T7^                                 Device/File integrity check failed
*I
i‑HD        to4Lspace.itpub.net                                 Device/File not configured
,|
{‑|5U3h        D,a(W                                  Device/File not configured

@4BV#o*il]@q'joracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net                                 Device/File not configured
jN
AC'i"j3l%~                                  Device/File not configured
(VW\c+\space.itpub.net        Cluster registry integrity check failed
        H�U\0U&r
\,y+Ln+M         Logicalcorruption check bypassed due to insufficient quorum*eZL Ai
检查表决磁盘:oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netm|9w
a�I^%V3RE
crsctl query css votedisk
Bu2_q[1]}!a{kITPUB个人空间[grid@rac1~]$ crsctl query css votedisk
YZ'df:P6M3KITPUB个人空间##  STATE   File Universal Id               File Name Disk group,X#m)p3`1R
--  -----    -----------------               --------- ---------ITPUB个人空间7Qz.q9].h
U:t
B
1. ONLINE   589c0071c9304fecbff651e64eeb281a (ORCL:CRS1) [CRS]
lGaKju;N
W:WLocated 1 voting disk(s).
QGK-V1\

v0}W:y
DY�s,bOc4j,gsd服务默认是disable的,如果要启动,启用即可­m‑j'{
q%a
[node1:grid]srvctl status oc4joracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netPDl)|-LLJ1vf4S
OC4J is disabled
*UI;A3d­z;^[node1:grid]srvctl status nodeapps
6G
C
e&Q;vrVIP node1-vip is enabledJT
k"C(x7N
z#z
VIP node1-vip is running on node: node1ITPUB个人空间YD:R.|p[U7[]9k
VIP node2-vip is enabledb(Jmy6l
VIP node2-vip is running on node: node2
`6BU[1]@`-`Networkis enabled
*|
I)R(K8Y/{~,iITPUB个人空间Network is running onnode: node1
[1]kQ:c|)zoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netNetworkis running on node: node2oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net1\,P:s)jg7owP
GSD is disabled
:S(Vr8_@o'Z"foracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netGSDis not running on node: node1space.itpub.net3h*N"dpI,o‑s
GSD is not running on node: node2
{(m
L,w‑]Xp‑R:[(Nspace.itpub.netONS is enabledCsw%Bp3k%R(Y
ONS daemon is running on node: node1j-@_bi
i)f
ONS daemon is running on node: node2
7Z"`O6}!A+yITPUB个人空间eONSis enabledITPUB个人空间/eC/M�U
R8o-@
SF
eONS daemon is running on node: node1
4mK2I)_6Z G
TITPUB个人空间eONS daemon is running on node: node2
|)}9WC6v*ty[node1:grid]$srvctlenable oc4j
0m$q[:j%T0v�poracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net[node1:grid]$srvctl start oc4j+E!|;Y q
~/|w
[node1:grid]$srvctl enable nodeappsp&@
~:R!E
[node1:grid]$srvctl start nodeapps
;Ei8r:m3poracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net重启grid cluster

T#E-\:k
vz1C
|[1]e#Q
){kW]_为数据和快速恢复区创建 ASM 磁盘组:R
F%V)F‑OY,K
d.D
asmca
­JeB\(i;Y,]­iITPUB个人空间
[1]{‑eC4M*m2WITPUB个人空间
~2z
o
{!x/cu­@:ispace.itpub.netsu - oraclespace.itpub.netS2z
l'`
m&u!r
./runInstaller8k7jGa
S        t1v
[root@rac2 ~]# /oracle/app/oracle/product/11.2.0/root.sh

w3|6c,t1{ITPUB个人空间Running Oracle 11g root.sh script...

OtIJ8f"X,PThe following environment variables are set as:
0^+V*H3Wf�T    ORACLE_OWNER= oracle
!\4X8]
E�Z PjCITPUB个人空间   ORACLE_HOME=  /oracle/app/oracle/product/11.2.0oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netg/~z3n}
pHlc2l
Enter the full pathname of the local bin directory: [/usr/local/bin]:
@&w
x$a!p[1]_T
[+Pspace.itpub.netThe file "dbhome" alreadyexists in /usr/local/bin.  Overwrite it? (y/n)

w/y7Q
R J
][n]: y
g_9y"R;u       i   Copying dbhome to /usr/local/bin ...[_&A;U
?7j­p
t
The file "oraenv" already exists in/usr/local/bin.  Overwrite it? (y/n)
!p!_s+~
m0F        P2Y‑_
toracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net[n]: y
a^#s3\u9Suf   Copyingoraenv to /usr/local/bin ...space.itpub.net(H2R"}4[@3F|-M*d‑\
The file "coraenv" already exists in/usr/local/bin.  Overwrite it? (y/n)
0pq-tv­H[n]: y
!]$p u7_]Ul#Vt  Copying coraenv to /usr/local/bin ...oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net&Gp�i/g1R!Y7f9R:Ui
Entries will be added to the /etc/oratab file as needed byspace.itpub.nete�[
O0v n@ E
Database Configuration Assistant when a database is created
iBJ
mcvITPUB个人空间Finished running generic part of root.sh script.%sb3^ \%^
d9h
SKx
Now product-specific root actions will be performed.
6e2|%J}"k2zY!Kb$[zFinishedproduct-specific root actions.
2u        }-a       e'kt;c[root@rac2 ~]# crs_stat -t
(a1i4hh3Faqspace.itpub.netSQL&gt;archive log list;       f!T‑CQ'K­]9F7kSw
Database log mode             Archive Mode
&Z+|r-m
YT7H­nrAutomatic archival            EnabledITPUB个人空间zR$f�{8w
}
Archive destination           USE_DB_RECOVERY_FILE_DEST
0y7[9]
tQ
o0{space.itpub.netOldest online log sequence    11
Q[1]vP-k‑[b0CJ4t(qspace.itpub.netNextlog sequence to archive   12
/m$@
@I
NCurrent log sequence          12W|yyq$~y8j)t


`#j
n#y`
N$sfSQL&gt; select max(sequence#) from v$archived_log
q
]*[gw5uspace.itpub.net
-]d]V-{
t
^6].boracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netcol NAMEformat a80B­i(n
\$f
space.itpub.netA[1]}eON6G4[
SQL&gt;  select SEQUENCE#,NAME,FIRST_TIME, NEXT_TIME FROMv$ARCHIVED_LOG ORDER BY SEQUENCE#;
HTH8S!l:X2jHoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net#[(u
U!_ w1g.n
space.itpub.net$P/G(\0Gj!T
SEQUENCE#  NAME                                                                                                                                        FIRST_TIME  NEXT_TIMEspace.itpub.netC6y-sH[1]\
---------- -----------------------------
4r0d|}&L*xt/PITPUB个人空间       11+DG_RECOVERY/racdb/archivelog/2010_05_18/thread_2_seq_11.257.719357641          18-MAY-10    18-MAY-10
GK(_%e:\"EhCspace.itpub.netjdJ+v|O2O
[&`}
--查看归档丢失的情况:­i­a*\cB2d1Lo%U'c�S(P

%Jm:]:]
i
S#@&E,}oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSELECTTHREAD#,LOW_SEQUENCE#,HIGH_SEQUENCE# from v$archive_gap;ITPUB个人空间
P*Y
p;]u)A.o
B3QU~
ITPUB个人空间
W5^f­pQDW%W
ITPUB个人空间a2K*]*S+F$a%d#B
--启动闪回
5pDU0p4V3C#z|(m5_space.itpub.net4\7Wt
mh�@
{-T
alter system set db_recovery_file_dest_size=2g scope=both;space.itpub.net
_m
`&D[1]`‑O

G[1]F­Yvj}alter system set db_recovery_file_dest='+DG_RECOVERY' scope=both;
&Z%Y,uPWspace.itpub.net
[H;w)J
i*D
alter database flashback ON;
:u7F*G Ys
-e(L:}pU8o"USQL&gt;show parameter recovery   

b+U6GuJITPUB个人空间space.itpub.net7a4s2Zy$C5v1z
T
NAME                               TYPE        VALUEITPUB个人空间       P�e;r9MER2@hk*_�e
------------------------------------ ----------- ------------------------------ITPUB个人空间T&dB p
Y4Z(n-X
db_recovery_file_dest               string      +DG_RECOVERY
9V/]%R
?F:~db_recovery_file_dest_size          big integer 2G8uB        v'K3?+M5L
G)`
recovery_parallelism                integer     0

 

 

tnsnames:
;P
SPeh-k^M  

D
j8^$|H
j6ioracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net  RACDB1=ITPUB个人空间,E"_x:@V*Bv‑L
  (DESCRIPTION =space.itpub.net
z
geqn(F$X2x
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))

kl(M,u­E|8c    (CONNECT_DATA =
'f_"_'NG8y"s]8Y     (SERVER = DEDICATED)
\.`0xLW])OQITPUB个人空间     (SERVICE_NAME = racdb)9IY
`7~3?
      (INSTANCE_NAME = racdb1)^ZQ Z!h�y0h
    )space.itpub.netBT


O/j
dcZ
  )

pQ_X@|HITPUB个人空间^r*]2T#M8{R
RACDB =_�{9Z0e       f6b
rq,a
q
  (DESCRIPTION =%uc
Vv
^DLje2e
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))
,}%G_­danspace.itpub.net   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))space.itpub.net7J$b6W5D]#l
    (LOAD_BALANCE = yes)
R9t&C}:_f
B1NJ
Eoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net   (CONNECT_DATA =oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net#fV]|�v&Ke7z
      (SERVER = DEDICATED)
^0j
V)i9w.a$[
      (SERVICE_NAME = racdb)1}E,J
h`4D}
      (FAILOVER_MODE =
7D_+j(hJ$|­F4Z(z
nspace.itpub.net       (TYPE = SELECT)

t^DC
hspace.itpub.net        (METHOD = BASIC)dsfz`5Y)X"Q"L
        (RETRIES = 180)
W.x2C`
X        (DELAY = 5)oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net2pdf+?:Sjc­L3o3~
      )space.itpub.net9y1]
S4|(P9U
    )
+Ubi)z(u.vh  )
3l‑[,x f
qaf
LITPUB个人空间'`:dU&U8[G?9o7`(H~
LISTENERS_RACDB =
'g2[(P)\,z.L4bK  (ADDRESS_LIST=
c:O,W@ |.g"o/GITPUB个人空间   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netIrk
i8H
F
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))
4z*xQ
u
A"a!Cr*R
Kspace.itpub.net  )
w�`0xW
Sz SL#?�W@
  

SK9H,I#d0`7I v
sUspace.itpub.netLISTENERS_RACDB1 =!F.?
|6}9a
  (ADDRESS_LIST =
7[^V(Ojj-h*dr   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.21)(PORT = 1521))space.itpub.net‑p$D
@5QB%w‑X
e
  )space.itpub.net:T(d
y
?
_
h5V
4M�w
g�G#bT
H
LISTENERS_RACDB2 =
o+kD)BF  (ADDRESS_LIST=
-i
K,m%?4@rU:R    (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.10.22)(PORT = 1521))ITPUB个人空间l%a&UZf}'B0g[1]G![;s
  )(]1[sY[
J
P;[2}!W
  X!G8IZ­z       A
  
$u:AF9i$@sspace.itpub.netEXTPROC_CONNECTION_DATA=
(`&}[1]P4gn­Y+bP1m&\oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net  (DESCRIPTION=
X+ht9b8j­Gteu
eoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net   (ADDRESS_LIST =6[)I       v p![}%?
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))ITPUB个人空间
Bj
kF
U#k
    )

l:F)x2jK(q­SITPUB个人空间    (CONNECT_DATA =
*~
i&DRl�q*X      (SID =PLSExtProc)
M
C6cF�WM/Y-jgb.Wspace.itpub.net     (PRESENTATION = RO)
$VA5v2NaT"@5^#|HITPUB个人空间   )
C']PaOK  )oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
L.K+e?
D)n9^

2O7|h!]gRACDB2 =space.itpub.net9vj4?;J       k        g
  (DESCRIPTION =
y-f(F#V
y:}7a
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.22)(PORT = 1521))
E;[*P�E0V,B-X
r\    (CONNECT_DATA =
&jdS8w6B%b3_space.itpub.net     (SERVER = DEDICATED)
0`$B­F{�o"Woracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net      (SERVICE_NAME = racdb)space.itpub.net4tb'l[1]f3I
A8I,N
s­E
      (INSTANCE_NAME = racdb2)ITPUB个人空间;dw7X8^S"y9b]
    )+\&?7O%m~&x
  )
7M u[1]D+L%Se*fforacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net  "{!D"w�|?K
  ITPUB个人空间"z'aT3}f[1]V/en
alter system set LOCAL_LISTENER = 'LISTENERS_RACDB1' scope=both sid='racdb1';ITPUB个人空间.l#eT]�u~        D:a
alter system set REMOTE_LISTENER = 'LISTENERS_RACDB' scope=both sid='racdb1';"M8H"PmB/\

+c,tS)f*|X[alter system setLOCAL_LISTENER = 'LISTENERS_RACDB2' scope=both sid='racdb2';ITPUB个人空间
Q(O2R%fov,y1{
alter system set REMOTE_LISTENER = 'LISTENERS_RACDB' scope=both sid='racdb2';
)\­|.O5_
p1Lr
KU"O.p
l%R(m9vITPUB个人空间############################################
~,E3p$H-A
A"BJ10、配置启动归档及闪回oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net#w
y0m%a-}RWO'y[1][A

HO:}        zJ?
^­Cn)P+zITPUB个人空间--先配归档才可以启动闪回
*laU6lXoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
k
V.B;o_
C9}alter system set cluster_database=false scope=spfileITPUB个人空间htv7CX2k
space.itpub.netl+^4`fpnJ/n
#alter system set db_recovery_file_dest='D:\oracle\flashdb' scope=both;Mv1Dq-x

;QQXr*UFITPUB个人空间altersystem switch logfile;S/RD"O
OW
}
h'f;G

|CT­e3U8J'O!~%ZH|startupmount
pDa)RTR*Xe
k ky‑C9cb-`ITPUB个人空间alterdatabase archivelog;J!bBl9]
`rI       ~:S8~2f6p)x
alter system set cluster_database=true scope=spfile(M1N?3@OO.xS#Tm

,d8Msj+U4k~oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netshutdownimmediate;
­i"S
?
~*I
gZU9RC3~
\/xav
Sa
startup

 

 

[root@rac2 ~]# crs_stat -t
uln7\5|.y­{L
xoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netName          Type          Target    State    Host        
/};N3|5GV3x9YWg------------------------------------------------------------oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net7k3h&wG`i
ora....SM1.asm application    ONLINE    ONLINE   rac1        
9I HZ9c       ^5o!D\ora....C1.lsnr application    ONLINE   ONLINE    rac1        
*TX&f](Jora.rac1.gsd  application    ONLINE    ONLINE   rac1        space.itpub.net        \5xi dn ~


L+|4\
ora.rac1.ons   application    ONLINE   ONLINE    rac1        
8J4S4wQ
w.M"T3b#p'Tora.rac1.vip   application   ONLINE    ONLINE    rac1       
^;BG&@;](G
Wsora....SM2.asm application    ONLINE   ONLINE    rac2        space.itpub.net
f$^6fH8J7Q,[o
b
ora....C2.lsnr application    ONLINE    ONLINE   rac2        
4K­e*v:y
`1E5xDora.rac2.gsd   application   ONLINE    ONLINE    rac2       
0}i­UPOITPUB个人空间ora.rac2.ons  application    ONLINE    ONLINE   rac2        
k.W
m|Soracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora.rac2.vip  application    ONLINE    ONLINE   rac2        
5]6ln
C,EB,^�K%iora.racdb.db  application    ONLINE    ONLINE   rac1        
9E
K&H
Q8D&d'yora....b1.inst application    ONLINE   ONLINE    rac1        
;u,M[#P7G+?6UForacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora....b2.instapplication    ONLINE    ONLINE    rac2       
?T-fn)D%i"Goracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora....db_s.csapplication    ONLINE    ONLINE    rac1       t5eM#|-L)y}
ora....db1.srv application    ONLINE    ONLINE   rac1        ITPUB个人空间,h
z        E
z-Q
p
ora....db2.srv application    ONLINE    ONLINE   rac2        

x't1jzt/`oITPUB个人空间
$dEZ'xO$J6U[1]`&mspace.itpub.net与之前不同service名后,则数据库会自己变为新的service名字,如下:!~@2i.j_
L,cI7|%_X6d-Z
NAME                               TYPE        VALUE[1]N.z0K$RAwP       |C
------------------------------------ ----------- ------------------------------DG`g$M
service_names                       string     racdb_sITPUB个人空间.@,@
c
B‑g
K*S,}5_
[1]Y)K
{{/u2v0\
-[�_-M[1]Y6t3k
7、crs_stat -t

VnfC]sm
q'kt"E2^:E'}0X[1]P
[oracle@rac2 bin]$ crs_stat -t            ;y/E+V*y~k$f
Name           Type          Target    State    Host        6B#@4V‑S6r%~
------------------------------------------------------------
#dDA1J
L
Mmspace.itpub.netora.rac1.gsd   application   ONLINE    ONLINE    rac1       oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net$P0U[,H&wW
ora.rac1.ons   application    ONLINE   ONLINE    rac1        O/t
h%yQ
ora.rac1.vip   application    ONLINE   ONLINE    rac1        
*t�S
Us(N-^/})zora.rac2.gsd   application   ONLINE    ONLINE    rac2       space.itpub.netX)[$M(Qh-D�aM
ora.rac2.ons   application    ONLINE   ONLINE    rac2        
H#Z|Q'Vbhora.rac2.vip  application    ONLINE    ONLINE   rac2        
G;X[1]z}EW-K+LI.Y/i
woracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
l'YU"R&y#S(ZI
ITPUB个人空间(Nk3B"g|z
ALTER DISKGROUP RACDISK DROP DISK RACDISK_0001 REBALANCE POWER 11;3ZH+?*eJ
M,y

Ab
Kd:AX        \2YN7_ITPUB个人空间y4q4Op*pH
8、rac statusspace.itpub.net%E$T0N�y&[_0A
?V

O8w&YR9c&Z
jBn[oracle@rac2 bin]$ crs_stat -t
nI2teZ)w&NName          Type          Target    State    Host        !n
~9L:~}4ye,y
------------------------------------------------------------G4p.g(d
y0q"qXf
ora....SM1.asm application    ONLINE    ONLINE   rac1        
I
Bq:Y}3^"am*q
ora....C1.lsnr application    ONLINE    ONLINE   rac1        
J1SgK4^;qF7Dora.rac1.gsd  application    ONLINE    ONLINE   rac1        oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netb&d.PQHK�C/]
c
ora.rac1.ons   application    ONLINE   ONLINE    rac1        
{N,J4e/d:PGora.rac1.vip  application    ONLINE    ONLINE   rac1        

`!eL m'rn.on+aoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora....SM2.asmapplication    ONLINE    ONLINE    rac2       space.itpub.net[1]\f^`
^rmO
ora....C2.lsnr application    ONLINE    ONLINE   rac2        t8`5B,n�C3Mi-k2X
ora.rac2.gsd   application    ONLINE   ONLINE    rac2        

F!R
a‑u1c
PITPUB个人空间ora.rac2.ons   application    ONLINE   ONLINE    rac2        

HRP
D%m
PYoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora.rac2.vip  application    ONLINE    ONLINE   rac2        
Ax7u!`-o!S;q(h3zora.racdb.db  application    ONLINE    ONLINE   rac2        ‑D"u5q+y/US
kq/B
^
ora....acdb.cs application    ONLINE    ONLINE   rac1        space.itpub.netM
[6M1Ro6`
ora....db1.srv application    ONLINE    ONLINE   rac1        
0K
j\jO+eLora....db2.srv application    ONLINE   ONLINE    rac2        !f7Wg%Mo
{
ora....b1.inst application    ONLINE    ONLINE   rac1        oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
q1Z.C'Q[1]~9Lyo
ora....b2.inst application    ONLINE    ONLINE   rac2      ET!~$D5G

V-s.pu­N#z############################################
)A+j#HH
_‑t9、listener.ora与tnsnames.oraspace.itpub.net#NJ5m       X&?5Gl
oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net1c­h
f*K
y:t4V
md
listener.ora:,I.U6yi$|`m;Q"T

m1C+h&X
`
a�F)W        {space.itpub.netLISTENER_RAC1 =
JM!]n­}:Zx(k5}#[  (DESCRIPTION_LIST=
|Ix
Hzspace.itpub.net    (DESCRIPTION =+F"D~VT8g.]
B
      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.10.21)(PORT = 1521)(IP = FIRST))-d$F‑`­`D${X
      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.10.11)(PORT = 1521)(IP = FIRST))
;fWw6_(L
OR]
@space.itpub.net    )
X'@r0Xd\  )I,y­yG‑c$[#E
LP(}!cN9O;_,J
SID_LIST_LISTENER_RAC1 =ITPUB个人空间l2M
Q&s+Wg.x
  (SID_LIST =oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net%j6e9f{_
TH
s"k)w?
    (SID_DESC =
5U]7k/`
c[1]M8U
L
Joracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net     (SID_NAME = PLSExtProc)!r%l~        OUY#z%E/w/g
      (ORACLE_HOME = /oracle/app/product/10.2.0/db_1)
KZc ~"q     (PROGRAM = extproc)

G.N&Oc#W`7\,^%IUITPUB个人空间    )
g0n!c,Qz(_7?o3S  )

 

 

Name          Type          Target    State     Host       [1]{P]s%k~7OC       e,H
ora.CRS.dg     ora....up.type ONLINE   ONLINE    rac1        $xnH#n;^~T‑d


I
ora.DGDATA.dg  ora....up.type ONLINE    ONLINE   rac1        
c
I0W2JG&k
R6@w/V hspace.itpub.netora....VERY.dgora....up.type ONLINE    ONLINE    rac1       
        ue3RB2n#G[1]g"kora....ER.lsnrora....er.type ONLINE    ONLINE    rac1       
-iY‑J        cu4r9]g,PITPUB个人空间ora....N1.lsnrora....er.type ONLINE    ONLINE    rac2       
dr/m
l+nora.asm        ora.asm.type  ONLINE    ONLINE    rac1       oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net$X|#D]hxF
ora.eons       ora.eons.type  ONLINE   ONLINE    rac1        
:fO
S+BD j­?+y6O0Dspace.itpub.netora.gsd       ora.gsd.type   ONLINE    ONLINE   rac1        

u\       Y$E|5n*D!Toracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora....networkora....rk.type ONLINE    ONLINE    rac1       
C*n
{[+r:SlD
bB*YPoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora.oc4j      ora.oc4j.type  ONLINE    ONLINE   rac2        
n6S)K3]­Mk,uora.ons       ora.ons.type   ONLINE   ONLINE    rac1        "G|aB
D
P'C
ora....SM1.asm application    ONLINE    ONLINE   rac1        
0P|­Vk
[;{EITPUB个人空间ora....C1.lsnr application   ONLINE    ONLINE    rac1       space.itpub.netT4I;D.u9UA
Y
ora.rac1.gsd   application    ONLINE   ONLINE    rac1        #y�C
O}        v­[OadO
ora.rac1.ons   application    ONLINE    ONLINE   rac1        (`!Zu
j0D!Jl2O
G
ora.rac1.vip   ora....t1.type ONLINE    ONLINE   rac1        
%I3k0_T)eora....SM2.asmapplication    ONLINE    ONLINE    rac2       
M/O
a)N
F/zKnIora....C2.lsnr application    ONLINE   ONLINE    rac2        
K)f!{.J[1]eora.rac2.gsd  application    ONLINE    ONLINE   rac2        
'I%AOW3h}ora.rac2.ons  application    ONLINE    ONLINE   rac2        
+z
D*{7qZ[8H+J$A%m&Zora.rac2.vip   ora....t1.typeONLINE    ONLINE    rac2       ITPUB个人空间5LH_%?Qs
ora....ry.acfs ora....fs.type ONLINE    ONLINE   rac1        ITPUB个人空间b        l!W,@
OE*S
ora.scan1.vip  ora....ip.type ONLINE    ONLINE   rac2
+ATul*X}3v6rspace.itpub.net
M‑n*?&]6Nbspace.itpub.netoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net_
Y/Db5@
0G4Y\
z
H*pR

YC}'g[S/[8sspace.itpub.netsu- oracleh6F[1]j~:Z
./dbca
K"HgqN]
R

y1m        ~@
W‑M
^7MITPUB个人空间
7B.Q3]S
M0Tj
VForacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net手工配置servicescK)Ah0~9l

6s1?YCpITPUB个人空间e.KT
RS$A7lQI
D
(命令注册不能用与DB相同的service名)oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netH*`
ZE        jc
oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netrX!XH
N‑E
u'f1A7X8SmQ
srvctl add service -d &lt;name&gt; -s &lt;service_name&gt; -r"&lt;preferred_list&gt;" [-a"&lt;available_list&gt;"] [-P &lt;TAF_policy&gt;]
"j7x'T­eK:]9\
7s5v|#E[1]UVspace.itpub.net[root@rac1backup]# srvctl add service -h   
o‑v)h:K3qCUsage: srvctl addservice -d &lt;name&gt; -s &lt;service_name&gt; -r "&lt;preferred_list&gt;"[-a "&lt;available_list&gt;"] [-P &lt;TAF_policy&gt;]ITPUB个人空间0~(U`7?0c
w
    -d &lt;name&gt;          Unique name for the database(P�?^(W2Udl
    -s &lt;service&gt;       Service nameITPUB个人空间
ty        c%l/F;tp4p9lc
    -r "&lt;pref_list&gt;"    List ofpreferred instancesoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net3M,V&g"Y3~8p
M
    -a "&lt;avail_list&gt;"   List ofavailable instances
D:[9E#K
wXV
    -P &lt;TAF_policy&gt;     TAF policy(NONE, BASIC, or PRECONNECT)

`4Y4l
~5{�XW[
Soracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netUsage: srvctl add service -d &lt;name&gt; -s&lt;service_name&gt; -u {-r "&lt;new_pref_inst&gt;" |-a "&lt;new_avail_inst&gt;"}space.itpub.net
H/`:ax#a5t
    -d &lt;name&gt;          Unique name for the database*]Yrj;Z7p*?
    -s &lt;service&gt;       Service name
Z
@,~A6mFS    -u                 Add a new instance to serviceconfiguration
[tx&D'z%K6?/f&B   -r &lt;new_pref_inst&gt;  Name of new preferredinstance
3ze%y5Q       ~x8r g‑Q    -a &lt;new_avail_inst&gt; Name of newavailable instance
(q(d+hF!bQ4w
Fspace.itpub.net    -h                 Print usage
;m        b!l\2T[-l­Jk;Yspace.itpub.netoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
n\
s#|i.H/W)^a        T"r
/oracle/app/crs/bin/srvctl add service -d racdb -s racdb_s racdb1 -a racdb2 -PBASIC
3a;z"p4}Gspace.itpub.net
s
Njz:`\4}
/oracle/app/crs/bin/srvctl add service -d racdb -s racdb_s -r racdb1,racdb2 -PBASIC
3z.R&R#`/g1x1s(建议)

 

 

su - oracleoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netF�`1d/RB:x�j
./runInstaller
;h‑R
a‑l5\


s`T
1B|%`8E‑K9`#`'f1Rw[1]k       W[root@rac2 ~]# /oracle/app/oracle/product/11.2.0/root.sh
.oI4}%A,]
Gspace.itpub.netRunning Oracle 11groot.sh script...
       F}kf?&z%kspace.itpub.net/P(y!d3Fe
The following environment variables are set as:
j$P
f#T7z;|ITPUB个人空间   ORACLE_OWNER= oracleITPUB个人空间*gVB1l:Gho
    ORACLE_HOME=  /oracle/app/oracle/product/11.2.0.`4X#ea1qL4Q d‑V

;I(G:K'c5v�qIEnter the full pathname of the local bin directory:[/usr/local/bin]: oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net:a
@[1]Uz)u?JD
i!|
The file "dbhome" already exists in/usr/local/bin.  Overwrite it? (y/n)
P}*Q5Q
O8M4espace.itpub.net[n]: y‑Y^'z%omF2G
   Copying dbhome to /usr/local/bin ...
WA8Nc5u.B@!|pspace.itpub.netThefile "oraenv" already exists in /usr/local/bin.  Overwriteit? (y/n) Yh
o[1]g4{
L8s
[n]: yoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net7p
\v"Y!Y2L:BH
   Copying oraenv to /usr/local/bin ...[1]G#U'\AO+|l
The file "coraenv" already exists in/usr/local/bin.  Overwrite it? (y/n) }­S(qn&}'p'O
[n]: y
q,Tnw
S!~0`;Uspace.itpub.net   Copying coraenv to /usr/local/bin ...
GM#tdB)[;Q

QhiQo|4Ioracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netEntrieswill be added to the /etc/oratab file as needed byoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netP+[6TN9P3u2Y/Z9k
Database Configuration Assistant when a database is created
j"m0O
Q&Gzv9bP
Finished running generic part of root.sh script.
p4g7Qn{Now product-specificroot actions will be performed.3a3`1k&z[1]O3C:L7S       |#p
Finished product-specific root actions.
"?M-R D?/g9s&EITPUB个人空间9e(? q.D4e
t
b7s],}
[root@rac2 ~]# crs_stat –t

 

检查集群节点:jOX f


U
olsnodes -l
c
~~
D0`d
NYu[1]S'M
J({klf8U
^O K检查 Oracle 集群注册表 (OCR):oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net%xz:P
k ~~)b]

r‑Q/i5U
ki:mE9K        \space.itpub.netocrcheck
9da�g6f­uzGoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.nets@rL
hk+v"Jz1g
[grid@rac1 ~]$  ocrcheck3E,@S2^­}'Ak?_
@
h#l
Status of Oracle Cluster Registry is as follows :
0G'\'\UY
s?@9I
r         Version                 :         3
4i2m4f2I:Yoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net        Total space (kbytes)    :     262120#b
\
J[1]S-VP
         Used space (kbytes)     :       2404
4_;S
BYu)p9oITPUB个人空间        Available space (kbytes) :     259716
#I%M V�r3Prworacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net         ID                     : 1095774749/H
~
d!v­a[1]|0o5M/u"ig3B
         Device/File Name        :       +CRS
m4CC8_N6c
j-k
w4E�x                                  Device/File integrity checksucceededITPUB个人空间)FUOW0J'o;R
/B:A)f9y?wF1A‑BM
                                  Device/File not configured

e[1]H1a/[h(M_@!wITPUB个人空间}fM
I
~3Y
O(I        y
                                  Device/File not configured
8d!S,f
t­C6X,T,G-e)B9ZN
l
p[*o%[h9|s7ispace.itpub.net                                  Device/File not configuredoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net)O2zGGc'y
Fs%k/]
P
                                  Device/File not configured

]s&N.@'{
c:?5@/vTAITPUB个人空间F/\;Y/D%M)s5w
         Cluster registry integrity checksucceeded
7\`!a,@d1hCAoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netO/G
O:aI
         Logical corruption check bypassed due tonon-privileged userzy;~,v)o0Ps_
ITPUB个人空间7a A*i
Q6P"v'oX9]­N
                 #L!@8gy(I        T
                 d8laI­h4h B
[grid@rac2 ~]$ ocrcheck
2F$O
G4n
]DStatus of Oracle Cluster Registry is as follows:Y"a-|­D
C,]
         Version                 :         3
LE8E4K�Z
w-G%~
         Total space (kbytes)    :     262120space.itpub.net)V[S
v8L
         Used space (kbytes)     :       2404
.e3j3jk0`*dD        Available space (kbytes) :    259716oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net6kM8y6BE9k
         ID                      :1095774749oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net5Ycq
zeM2[6i
         Device/File Name        :       +CRS
a+m
q/n/L:?3}
Y9o\
                                  Device/File integrity check failedoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.nett5^,Z?­B:`

/x        u;^zM t                                 Device/File not configured+L8zw
YF
ITPUB个人空间w
`5G
W
cdZM}
                                  Device/File not configured
W*i}-\7r,WXLE9@]&Ns
f(lQ
|
                                  Device/File not configured9A'dE}-z

­M6~ w6v;KK
[-F1EITPUB个人空间                                  Device/File notconfigured
Suv:B;m        _%UW,R/z*oI
O}[1]vy^w6Vt!y­J2r
         Cluster registry integrity check failed
p/|D[1]u?6{9GITPUB个人空间
9n
Y U1}}-Ooracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net        Logical corruption check bypassed due toinsufficient quorum
9^
Quk,x;j!cspace.itpub.net
*k#a­O0Ws1H)B"bITPUB个人空间检查表决磁盘:
}+W,w(v
Q7bC

g2k#^uScrsctl query cssvotediskoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net[1]Jth(p­q
i&m

i:V#R
D'L.h6][1]uporacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net[grid@rac1~]$ crsctl query css votedisk
­X)I])g
N#?}ITPUB个人空间##  STATE    FileUniversal Id               File Name Disk groupspace.itpub.net+]9^(}[1]_)xJ
_R
--  -----    -----------------               --------- ---------oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net%Y!}4We_/m'V
p+^'g
1. ONLINE   589c0071c9304fecbff651e64eeb281a (ORCL:CRS1) [CRS]
        S�\"@g5v$l­rAoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netLocated 1 voting disk(s).
0uK-w)C!z       I9f3[­o
E7j.|W%Axx

{/c-N$M3@GT3MITPUB个人空间Oc4j,gsd服务默认是disable的,如果要启动,启用即可
7nVj8Fn‑`
yITPUB个人空间[node1:grid]srvctl status oc4j

oW-a3Nz�I(rOC4J is disabledoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net:?6[[1]o
ldm^
O.U
j4n'l
'x[1]Y
U(@/]
[node1: grid]srvctl status nodeapps
1a
L oC^,w.e3Y!hS%b6w-OVIP node1-vip is enabled
5e*MQ
[
\VIP node1-vip is running on node: node1
)t1D3?N
L1G,aX!XVIP node2-vip is enabledoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net1S5R7Y?4y#K
VIP node2-vip is running on node: node2

O+r1P4d
R9`[1]]oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netNetworkis enabled
3K!jz%n8i‑noracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netNetworkis running on node: node1oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netk
X]
D6Q!d
j
Network is running on node: node2oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net_@
T
v xd3e7fp
GSD is disabledITPUB个人空间‑cmx_5Q
GSD is not running on node: node1
(w1};?1A
s8\4Y.z
Foracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netGSDis not running on node: node2space.itpub.net
Q*@/e4^1fn%f‑o‑P;L
ONS is enabled
FBntm&{v#j!v&pGONSdaemon is running on node: node1
QI0NP Ga:qk
Ospace.itpub.netONS daemon is running on node: node2I|1Km
q&C0SZ3Y0G:y:`
eONS is enabledITPUB个人空间
p{p3[D`f
L­T
eONS daemon is running on node: node1ITPUB个人空间:~#ZK­Y!HFi,}
eONS daemon is running on node: node2
H
X'B}Z fC2{[1]?
J[1]Y7P&L
}­i9E[node1:grid]$srvctl enable oc4jspace.itpub.netr;D?"B
v:lI
[node1:grid]$srvctl start oc4j.P(n
eTW3zZ
r
[node1:grid]$srvctl enable nodeapps@@4f.Z?       p
[node1:grid]$srvctl start nodeappsoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net5r
t9[!D!l‑i[
L;N/rs Pva
S
重启grid clusteroracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net5@8gO8kk%j$S
space.itpub.net
A|o‑S        mwD`CT"^
5M+C.s6j-Uk-gD
为数据和快速恢复区创建ASM 磁盘组:
+Q^y:I/TsL!P z
Vasmca

 

 

 

资源组状态:-T5j0_]y4e
[4C
crsctl status resource -t
9q-\
Y


P3n$R8C*]8S
‑ys e3|;ZQx'?[grid@rac2~]$ crsctl status resource -t%t(Z
b­K!c
]7[
dM
--------------------------------------------------------------------------------
J
cSzQp{0kNAME          TARGET  STATE       SERVER                  STATE_DETAILS       M
d
I~"~%\
--------------------------------------------------------------------------------oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netx�WRh/J
Local Resources

t-G�O:@y9O5`%Y7MITPUB个人空间--------------------------------------------------------------------------------"?#C*K&D+]UA5h
S
ora.CRS.dgoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net`iE
J0h H
Q
B‑U
              ONLINE  ONLINE       rac1                                      space.itpub.net
?‑x/u)w(I
              ONLINE  ONLINE       rac2                                      oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net;[}8zcQU
s'jM4G!Q
ora.LISTENER.lsnrspace.itpub.neto-a       O @
\
q
              ONLINE  ONLINE       rac1                                      
u7v!Wh
hMtN'Yspace.itpub.net              ONLINE  ONLINE      rac2                                       
o+w3i
V Z
O+tora.asm
oC2r­z|       xs              ONLINE  ONLINE       rac1                   Started             'Gw*QLk
              ONLINE  ONLINE       rac2                   Started            
8s#yS�{
F5tspace.itpub.netora.eons
:b1X,?.J4YF+A.X�^;b              ONLINE  ONLINE       rac1                                      oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net*IpE8K2J/X3O,x%v
              ONLINE  ONLINE       rac2                                      space.itpub.net
S5[
i8p
u ]
ora.gsd
~#b­v­~e
]0kU              ONLINE  ONLINE       rac1                                      
4Kf
by0sG
S
[ITPUB个人空间              ONLINE  ONLINE       rac2                                      
*X)x4Yi:x\4M:Uora.net1.network
'X
iE[1]IF:tIk-wx             ONLINE  ONLINE       rac1                                      
,t
r,iJ‑E5EBoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net              ONLINE  ONLINE      rac2                                       

J8vMkdD6doracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netora.ons
w-P-?
~/BZb‑L}              ONLINE  ONLINE       rac1                                      -Q3M
o        u0K
s5c
h
{
              ONLINE  ONLINE       rac2                                      i#dQ`"~M­E7W
ora.registry.acfs
4V#o‑u4W2P­Uo
L1ZR              ONLINE  ONLINE       rac1                                      oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net9X:Yn%u!h
mj
              ONLINE  ONLINE       rac2                                      ITPUB个人空间&t
LWp+KS0c
--------------------------------------------------------------------------------
)?
w4g3f        Y6T
D
aspace.itpub.netCluster Resourcesspace.itpub.netV
x+t
kC
--------------------------------------------------------------------------------
%Y7H
a P5EZ­y+Lspace.itpub.netora.LISTENER_SCAN1.lsnrspace.itpub.net+]_0|.c4q*g"iJ
      1       ONLINE  ONLINE       rac1                                      T\#Py1o,GQQe
ora.oc4j
*]!b0r/r6pou
y      1       ONLINE  ONLINE       rac2                                      

R�x
W[1]QU's$iITPUB个人空间ora.rac1.vip
0\~"x|f     1       ONLINE  ONLINE       rac1                                      ]
z$f:F
?6{k%N(q8G�f
ora.rac2.vip
JV}]0]'I:O       w      1       ONLINE  ONLINE       rac2                                      
%Z{;lLRora.scan1.vip
/m        }c�?8|­Q5rg      1       ONLINE  ONLINE       rac1
.i
fm
gp+p8sITPUB个人空间D
Z6X*X‑U1fm#Iy$a4[
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值