oracle 11g RAC环境修改scan vip

最新推荐文章于 2024-09-02 17:08:58 发布

转载最新推荐文章于 2024-09-02 17:08:58 发布 · 263 阅读

文章标签：

本文介绍如何在 Oracle 11g RAC 环境中修改 SCAN VIP 地址，包括停止监听器和服务、更新 OCR 中的 SCAN VIP、修改 /etc/hosts 文件等步骤，并验证修改后的效果。

oracle 11g RAC环境修改scan vip

环境
grid：11.2.0.4
oracle：11.2.0.4

原值：
192.168.0.58

新值：
192.168.0.158

su - root
cd /ora11g/grid/crs_home/bin

./srvctl config scan

./srvctl stop scan_listener
./srvctl stop scan

./srvctl modify scan -n 192.168.0.158

./srvctl config scan

./srvctl start scan
./srvctl start scan_listener

============================================================================================================

1、修改前查看

grid[test1]/home/grid> ps -ef|grep tns
grid 16638 1 0 08:13 ? 00:00:00 /ora11g/grid/crs_home/bin/tnslsnr LISTENER_SCAN1 -inherit
grid 22148 5060 0 09:05 pts/2 00:00:00 grep tns
grid[test1]/home/grid>
grid[test1]/home/grid> lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-MAR-2015 09:06:06

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 03-MAR-2015 08:13:34
Uptime 0 days 0 hr. 52 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora11g/grid/crs_home/network/admin/listener.ora
Listener Log File /ora11g/grid/crs_home/log/diag/tnslsnr/test1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.58)(PORT=1521)))
The listener supports no services
The command completed successfully
grid[test1]/home/grid>

2、编辑每个节点的/etc/hosts，将scan vip修改为新值。

3、修改ocr中的scan vip

[root@test1 bin]# pwd
/ora11g/grid/crs_home/bin
[root@test1 bin]#
[root@test1 bin]# ./srvctl config scan
SCAN name: racscan, Network: 1/192.168.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /racscan/192.168.0.58
[root@test1 bin]#
[root@test1 bin]# ./srvctl stop scan_listener
[root@test1 bin]#
[root@test1 bin]# ./srvctl stop scan
[root@test1 bin]#
[root@test1 bin]# ./srvctl modify scan -n 192.168.0.158
[root@test1 bin]#
[root@test1 bin]# ./srvctl config scan
SCAN name: 192.168.0.158, Network: 1/192.168.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.0.158/192.168.0.158
[root@test1 bin]#
[root@test1 bin]# ./srvctl start scan
[root@test1 bin]#
[root@test1 bin]# ./srvctl start scan_listener
[root@test1 bin]#

4、修改后查看

grid[test1]/home/grid> ps -ef|grep tns
grid 23777 1 0 09:19 ? 00:00:00 /ora11g/grid/crs_home/bin/tnslsnr LISTENER_SCAN1 -inherit
root 23794 4987 0 09:20 pts/1 00:00:00 grep tns
grid[test1]/home/grid>
grid[test1]/home/grid> lsnrctl status LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-MAR-2015 09:20:45

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 03-MAR-2015 09:19:54
Uptime 0 days 0 hr. 0 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora11g/grid/crs_home/network/admin/listener.ora
Listener Log File /ora11g/grid/crs_home/log/diag/tnslsnr/test1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.158)(PORT=1521)))
The listener supports no services
The command completed successfully
grid[test1]/home/grid>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24626891/viewspace-2083024/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24626891/viewspace-2083024/