Chinaunix首页 | 论坛 | 博客
  • 博客访问: 239113
  • 博文数量: 59
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 592
  • 用 户 组: 普通用户
  • 注册时间: 2014-04-01 12:51
个人简介

你们都是我的客户,所以,我对你们是透明的

文章分类

全部博文(59)

文章存档

2016年(29)

2015年(30)

分类: Oracle

2015-12-01 21:28:02

修改vip
1、停库
[oracle@hca1 ~]$ srvctl stop database -d orcl
2、停止监听和vip
[grid@hca1 ~]$ srvctl stop listener -n hca1
[grid@hca1 ~]$ srvctl stop listener -n hca2
[grid@hca1 ~]$ srvctl stop vip -n hca1
[grid@hca1 ~]$ srvctl stop vip -n hca2
3、修改双节点/etc/hosts
4、root用户修改(hca1上可以下面command修改两个节点)
确认
[root@hca1 bin]# ./srvctl config vip -n hca1
VIP exists: /hca1-vip/172.16.80.25/172.16.0.0/255.255.0.0/em1, hosting node hca1
修改
/u01/app/11.2.0/grid/bin/srvctl modify nodeapps -n hca1 -A 172.16.80.15/255.255.0.0/em1
/u01/app/11.2.0/grid/bin/srvctl modify nodeapps -n hca2 -A 172.16.80.16/255.255.0.0/em1
5、
srvctl modify scan_listener -u
srvctl start scan_listener

修改scan
[grid@hca1 ~]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    hca1       
ora...._OLD.dg ora....up.type OFFLINE   OFFLINE              
ora...._SDD.dg ora....up.type ONLINE    ONLINE    hca1       
ora...._SDD.dg ora....up.type ONLINE    ONLINE    hca1       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    hca1       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    hca1       
ora.OCR.dg     ora....up.type ONLINE    ONLINE    hca1       
ora.asm        ora.asm.type   ONLINE    ONLINE    hca1       
ora.cvu        ora.cvu.type   ONLINE    ONLINE    hca1       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
ora....SM1.asm application    ONLINE    ONLINE    hca1       
ora....A1.lsnr application    ONLINE    ONLINE    hca1       
ora.hca1.gsd   application    OFFLINE   OFFLINE              
ora.hca1.ons   application    ONLINE    ONLINE    hca1       
ora.hca1.vip   ora....t1.type ONLINE    ONLINE    hca1       
ora....SM2.asm application    ONLINE    ONLINE    hca2       
ora....A2.lsnr application    ONLINE    ONLINE    hca2       
ora.hca2.gsd   application    OFFLINE   OFFLINE              
ora.hca2.ons   application    ONLINE    ONLINE    hca2       
ora.hca2.vip   ora....t1.type ONLINE    ONLINE    hca2       
ora....network ora....rk.type ONLINE    ONLINE    hca1       
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    hca1       
ora.ons        ora.ons.type   ONLINE    ONLINE    hca1       
ora.orcl.db    ora....se.type ONLINE    ONLINE    hca1       
ora....ry.acfs ora....fs.type ONLINE    ONLINE    hca1       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    hca1      ##scan在一节点,所以一节点上操作      
[grid@hca1 ~]$

停监听
[grid@hca1 ~]$ srvctl stop scan_listener
[grid@hca1 ~]$ srvctl stop scan
修改

[root@hca1 ~]# /u01/app/11.2.0/grid/bin/srvctl modify scan -n rac-scan
[root@hca1 ~]#
[grid@hca1 ~]$ srvctl modify scan_listener -u
开启scan监听
[grid@hca1 ~]$ srvctl start scan_listener
[grid@hca1 ~]$ srvctl start scan



最后,再把库起来
[oracle@hca1 ~]$ srvctl start database -d orcl

看一下scan监听状态
[grid@hca1 ~]$ lsnrctl status LISTENER_SCAN1
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-NOV-2015 07:05:11
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                30-NOV-2015 06:48:13
Uptime                    0 days 0 hr. 16 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0/grid/log/diag/tnslsnr/hca1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.80.51)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@hca1 ~]$
阅读(1727) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~