oracle 19c集群切换IP

100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
[oracle@rac01 ~]$ srvctl stop database -d racdb
 
[oracle@rac01 ~]$ srvctl status database -d racdb
实例 racdb1 没有在 rac01 节点上运行
实例 racdb2 没有在 rac02 节点上运行
 
 
[root@rac01 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.chad
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.net1.network
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.ons
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ARC.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac02                    STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    Started,STABLE
      2        ONLINE  ONLINE       rac02                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac02                    STABLE
ora.racdb.db
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
      2        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac02                    STABLE
ora.rac01.vip
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac02.vip
      1        ONLINE  ONLINE       rac02                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac02                    STABLE
--------------------------------------------------------------------------------
 
 
[root@rac01 bin]# ./oifcfg getif
eth0  192.168.0.0  global  public
eth1  200.200.200.0  global  cluster_interconnect,asm
 
 
[root@rac01 bin]# ./crsctl stop crs
[root@rac02 bin]# ./crsctl stop crs
 
 
[root@rac01 bin]# vim /etc/sysconfig/network-scripts/ifcfg-eth0
TYPE=Bond
DEVICE=eth0
BOOTPROTO=static
DEFROUTE=yes
ONBOOT=yes
IPADDR=192.168.162.30
NETMASK=255.255.0.0
GATEWAY=192.168.255.254
BROADCAST=192.168.255.255
USERCTL=no
IPV6INIT=no
PEERDNS=yes
NAME=麓public麓
BONDING_OPTS=麓mode=0麓
BONDING_MASTER=yes
 
[root@rac02 bin]# vim /etc/sysconfig/network-scripts/ifcfg-eth0
TYPE=Bond
DEVICE=eth0
BOOTPROTO=static
DEFROUTE=yes
ONBOOT=yes
IPADDR=192.168.162.31
NETMASK=255.255.0.0
GATEWAY=192.168.255.254
BROADCAST=192.168.255.255
USERCTL=no
IPV6INIT=no
PEERDNS=yes
NAME=麓public麓
BONDING_OPTS=麓mode=0麓
BONDING_MASTER=yes
 
 
[root@rac01 bin]# ifdown eth0 && ifup eth0
[root@rac02 bin]# ifdown eth0 && ifup eth0
 
 
[root@rac01 ~]# vim /etc/hosts
192.168.162.30  rac01
192.168.162.31  rac02
 
192.168.162.32  rac01-vip
192.168.162.33  rac02-vip
 
200.200.200.193 rac01-priv
200.200.200.194 rac02-priv
 
192.168.162.34  rac-scan
 
[root@rac02 ~]# vim /etc/hosts
192.168.162.30  rac01
192.168.162.31  rac02
 
192.168.162.32  rac01-vip
192.168.162.33  rac02-vip
 
200.200.200.193 rac01-priv
200.200.200.194 rac02-priv
 
192.168.162.34  rac-scan
 
 
 
[root@rac01 bin]# ./crsctl start crs
[root@rac02 bin]# ./crsctl start crs
 
 
[root@rac01 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.chad
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.net1.network
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.ons
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ARC.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac01                    STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    Started,STABLE
      2        ONLINE  ONLINE       rac02                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac01                    STABLE
ora.racdb.db
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
      2        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac01.vip
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac02.vip
      1        ONLINE  ONLINE       rac02                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac01                    STABLE
--------------------------------------------------------------------------------
 
 
[root@rac01 bin]# ./oifcfg delif -global eth0
[root@rac01 bin]# ./oifcfg setif -global eth0/192.168.162.0:public
[root@rac01 bin]# ./oifcfg getif
eth1  200.200.200.0  global  cluster_interconnect,asm
eth0  192.168.162.0  global  public
 
 
[root@rac01 bin]# ./srvctl config nodeapps -a
网络1存在
子网 IPv4: 192.168.0.0/255.255.0.0/eth0, static
子网 IPv6: 
试通目标: 
网络已启用
网络已在以下节点上分别启用: 
网络已在以下节点上分别禁用: 
VIP 存在: 网络编号 1, 托管节点 rac01
VIP 名称: rac01-vip
VIP IPv4 地址: 192.168.66.195
VIP IPv6 地址: 
VIP 已启用。
VIP 已在以下节点上分别启用: 
VIP 已在以下节点上分别禁用: 
VIP 存在: 网络编号 1, 托管节点 rac02
VIP 名称: rac02-vip
VIP IPv4 地址: 192.168.66.196
VIP IPv6 地址: 
VIP 已启用。
VIP 已在以下节点上分别启用: 
VIP 已在以下节点上分别禁用: 
 
[root@rac01 bin]# ./srvctl stop listener
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# ./srvctl status listener
监听程序 LISTENER 已启用
监听程序 LISTENER 未运行
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# ./srvctl stop vip -n rac01
[root@rac01 bin]# ./srvctl stop vip -n rac02
 
[root@rac01 bin]# ./srvctl modify nodeapps -A 192.168.162.32/255.255.0.0/eth0 -n rac01
[root@rac01 bin]# ./srvctl modify nodeapps -A 192.168.162.33/255.255.0.0/eth0 -n rac02
[root@rac01 bin]# ./srvctl start vip -n rac01
[root@rac01 bin]# ./srvctl start vip -n rac02
[root@rac01 bin]# ./srvctl start listener
 
[root@rac01 bin]# ./srvctl config scan
SCAN ?3? rac-scan, θ?: 1
?θ IPv4: 192.168.0.0/255.255.0.0/eth0, static
?θ IPv6: 
SCAN 1 IPv4 VIP: 192.168.162.34
SCAN VIP ????￡
[root@rac01 bin]# ./srvctl stop scan_listener
[root@rac01 bin]# ./srvctl stop scan
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# ./srvctl modify scan -n rac-scan
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# ./srvctl start scan
[root@rac01 bin]# ./srvctl start scan_listener
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.chad
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.net1.network
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.ons
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ARC.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac02                    STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    Started,STABLE
      2        ONLINE  ONLINE       rac02                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac01                    STABLE
ora.racdb.db
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
      2        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac01.vip
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac02.vip
      1        ONLINE  ONLINE       rac02                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac02                    STABLE
--------------------------------------------------------------------------------
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# 
[root@rac01 bin]# ./srvctl config scan
SCAN ?3? rac-scan, θ?: 1
?θ IPv4: 192.168.0.0/255.255.0.0/eth0, static
?θ IPv6: 
SCAN 1 IPv4 VIP: 192.168.162.34
SCAN VIP ????￡
 
[root@rac01 bin]#  ./srvctl start database -d racdb