国产xxxx99真实实拍_久久不雅视频_高清韩国a级特黄毛片_嗯老师别我我受不了了小说

資訊專欄INFORMATION COLUMN

oracle 11g rac更換public ip、vip

IT那活兒 / 1429人閱讀
oracle 11g rac更換public ip、vip
一. 修改公網IP

公網 IP 的網段一旦發(fā)生改變，VIP 和 SCAN IP 也要隨之發(fā)生改變

將公網 IP 的網段由 192.168.56.0 改為 192.168.60.0 子網掩碼 255.255.255.0

1. 刪除OCR網卡信息

從 OCR 中刪除已有的的網卡信息，然后添加正確的信息

[grid@zrac1 ~]$ oifcfg delif -global bond0/192.168.56.0[grid@zrac1 ~]$ oifcfg setif -global bond0/192.168.60.0:public[grid@zrac1 ~]$ oifcfg getifbond1 10.10.10.0 global cluster_interconnectbond0 192.168.60.0 global public

注意：運行上面的命令時，需要集群在所有的節(jié)點 running，不然會報錯

PRIF-32: Error in checking for profile availability for host racnode2CRS-02306: GPnP service on host "zrac2" not found.

PRIF-33: Failed to set or delete interface because hosts could not be discovCRS-02307: No GPnP services on requested remote hosts.

2. 修改網卡文件、/etc/hosts 文件

[root@zrac1 ~]# vim /etc/sysconfig/network-scripts/ifcfg-bond0DEVICE=bond0TYPE=EthernetONBOOT=yesBOOTPROTO=noneIPADDR=192.168.60.31NETMASK=255.255.255.0GATEWAY=192.168.60.1USERCTL=no

重啟網卡 ifdown bond0;ifup bond0
#Public IP192.168.60.31 zrac1192.168.56.41 zrac2#Private IP10.10.10.31 zrac1-priv10.10.10.41 zrac2-priv# VIP192.168.56.35 zrac1-vip192.168.56.45 zrac2-vip# SCAN192.168.56.90 scan


二. 修改VIP

公網 IP 的網段發(fā)生改變，VIP 需要隨之發(fā)生改變，從 10.2.0.3 開始，ASM/database 實例對 VIP 資源的依賴關系被 remove，所以修改VIP 時，不再需要關閉 ASM/database 實例，只有客戶端連接在 VIP down 掉時會受影響，如果只在一個節(jié)點修改 VIP，VIP 修改期間只會影響該節(jié)點的連接OS 網絡發(fā)生改變后，如果有節(jié)點重啟或集群重啟，VIP 不會啟動，跳過 " Modifying VIP and its Associated Attributes"


1. 查看當前 VIP 的配置

[grid@zrac1 ~]$ srvctl config nodeapps -aNetwork exists: 1/192.168.56.0/255.255.255.0/bond0, type staticVIP exists: /zrac1-vip/192.168.56.35/192.168.56.0/255.255.255.0/bond0, hostiVIP exists: /zrac2-vip/192.168.56.45/192.168.56.0/255.255.255.0/bond0, hosti

VIP 漂移到其他的可用節(jié)點上

[grid@zrac1 ~]$ crsctl stat res -t

ora.zrac1.vip1  ONLINE INTERMEDIATE zrac2          FAILED OVER

2. 停止實例與 VIP 資源

[grid@zrac1 ~]$ srvctl stop instance -d rac -n zrac1    // 可選項[grid@zrac1 ~]$ srvctl stop vip -n zrac1 -f

3. 修改 VIP 以及屬性

注意：（先修改 /etc/hosts 文件中的 VIP）

[grid@zrac1 ~]$ srvctl modify nodeapps -n zrac1 -A zrac1-vip/255.255.255.0/b

  • 驗證改變

[root@zrac1 grid]# srvctl config nodeapps -aNetwork exists: 1/192.168.60.0/255.255.255.0/bond0, type staticVIP exists: /zrac1-vip/192.168.60.35/192.168.60.0/255.255.255.0/bond0, hostiVIP exists: /zrac2-vip/192.168.56.45/192.168.60.0/255.255.255.0/bond0, hosti

  • 啟動資源

[root@zrac1 grid]# srvctl start vip -n zrac1  [root@zrac1 grid]# srvctl start listener -n zrac1  [root@zrac1 grid]# srvctl start instance -d rac -n zrac1  // 可選項

  • 查看 VIP 資源狀態(tài)

[root@zrac1 grid]# crsctl stat res -t

ora.zrac1.vip 1              ONLINE  ONLINE zrac1

  • 查看網絡信息

[root@zrac1 grid]# ifconfigbond0  Link encap:Ethernet HWaddr 08:00:27:44:AF:3Cinet addr:192.168.60.31 Bcast:192.168.60.255 Mask:255.255.255.0inet6 addr: fe80::a00:27ff:fe44:af3c/64 Scope:LinkUP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1RX packets:6876 errors:0 dropped:0 overruns:0 frame:0TX packets:2884 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0RX bytes:663094 (647.5 KiB) TX bytes:359866 (351.4 KiB)
 bond0:1  Link encap:Ethernet HWaddr 08:00:27:44:AF:3Cinet addr:192.168.60.35 Bcast:192.168.60.255 Mask:255.255.255.0UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

  • 查看監(jiān)聽信息

grid@zrac1 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-MAY-2017 11:22:50

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUS of the LISTENER-------------------------Alias                      LISTENERVersion                     TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date                   14-MAY-2017 11:22:46Uptime                       0 days 0 hr. 0 min. 4 secTrace Level                  offSecurity                     ON: Local OS AuthenticationSNMP                          OFFListener Parameter File      /u01/11.2.0/grid/network/admin/listener.ora Listener Log File            /u01/app/oracle/diag/tnslsnr/zrac1/listener/alert/ Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.31)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.35)(PORT=1521)))Services Summary...Service "rac" has 1 instance(s).Instance "rac1", status READY, has 1 handler(s) for this service...Service "racXDB" has 1 instance(s).Instance "rac1", status READY, has 1 handler(s) for this service...The command completed successfully

注意：如果需要的話，修改 listener.ora 文件、tnsnames.ora 文件、LOCAL_LISTENER/REMOTE_LISTENER 參數(shù)來映射 VIP 的改變，如果不停實例的話，需要修改 LOCAL_LISTENER 參數(shù)；不修改的話 listener 監(jiān)聽不到服務

SQL> alter system set local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6

  • 在其他節(jié)點也進行上述操作


三. 修改 SCAN IP

1. 停止 SCAN listener 并查看狀態(tài)

[grid@zrac1 admin]$ srvctl stop scan_listener[grid@zrac1 admin]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is not running

2. 停止 SCAN VIP 資源并查看狀態(tài)

[grid@zrac1 admin]$ srvctl stop scan

[grid@zrac1 admin]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is not running

3. 修改所有節(jié)點的 /etc/hosts 文件

# SCAN VIP  192.168.60.90  scan

4. 更新 SCAN VIP 資源

[root@zrac1 admin]# srvctl modify scan -n scan 
[root@zrac1 admin]# srvctl config scanSCAN name: scan, Network: 1/192.168.60.0/255.255.255.0/bond0SCAN VIP name: scan1, IP: /scan/192.168.60.90

5. 啟動 SCAN VIP 和 SCAN 監(jiān)聽資源

[root@zrac1 admin]# srvctl start scan[root@zrac1 admin]# srvctl start scan_listener

6. 查看 SCAN 監(jiān)聽狀態(tài)（發(fā)現(xiàn)沒有服務）

[root@zrac1 admin]# lsnrctl status LISTENER_scan1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-MAY-2017 11:43:58

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))STATUS of the LISTENER 12Alias  LISTENER_SCAN1Version  TNSLSNR for Linux: Version 11.2.0.4.0 - Production15 Start Date  14-MAY-2017 11:40:32Uptime  0 days 0 hr. 3 min. 26 secTrace Level  offSecurity  ON: Local OS AuthenticationSNMP  OFFListener Parameter File  /u01/11.2.0/grid/network/admin/listener.oraListener Log File  /u01/11.2.0/grid/log/diag/tnslsnr/zrac1/listener_sListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.90)(PORT=1521)))The listener supports no servicesThe command completed successfully

7. 解決方式：重啟實例或者修改 remote_listener 參數(shù)

[root@zrac1 admin]# srvctl stop instance -d rac -i rac1,rac2[root@zrac1 admin]# srvctl start instance -d rac -i rac1,rac2

8. 修改完成后，/etc/hosts 文件

#Public IP192.168.60.31 zrac1192.168.60.41 zrac2

#Private IP10.10.10.31 zrac1-priv10.10.10.41 zrac2-priv


END


更多精彩干貨分享

點擊下方名片關注

IT那活兒

文章版權歸作者所有，未經允許請勿轉載,若此文章存在違規(guī)行為，您可以聯(lián)系管理員刪除。

轉載請注明本文地址：http://specialneedsforspecialkids.com/yun/129844.html

相關文章

  • DBASK問答集萃（2）

    摘要：新晉技術專家下面是墨天輪部分新晉的技術專家。大家可以點擊往期閱讀墨天輪技術專家邀請函了解詳情，申請成為我們的技術專家，加入專家團隊，與我們一起創(chuàng)建一個開放互助的數(shù)據(jù)庫技術社區(qū)。新關聯(lián)公眾號墨天輪是一個開放互助的數(shù)據(jù)庫技術社區(qū)。 引言 近期我們在DBASK小程序增加了數(shù)據(jù)庫 MongoDB、Redis、 Elasticsearch、DB2、Weblogic 等新的的專題欄目和一些新的技術...

    liuchengxu 評論0 收藏0

發(fā)表評論

0條評論

IT那活兒

男|高級講師

TA的文章

閱讀更多
最新活動
閱讀需要支付1元查看
<