Service使用referred和avileable固定会话到一个节点，宕机后会切换到另一个节点

最新推荐文章于 2021-12-22 14:05:26 发布
最新推荐文章于 2021-12-22 14:05:26 发布
阅读量161 收藏
点赞数
Service使用referred和avileable固定session连接到一台数据库服务器上，这台数据库服务器宕机后会切换到另一台数据库服务器上

管理员管理的DB里，service分为：
- preferred instance：服务启动的时候，在哪个实例上启动，该实例就是preferred instance。
- available instance：服务所在的实例崩溃，集群件会在另外一个available instance里启动该服务。

必须在oracle用户下执行
[root@node1 ~]# srvctl add service -d orcl  -s srv1 -r orcl1 -a orcl2
PRCD-1026 : Failed to create service srv1 for database orcl
PRKH-1014 : Current user "root" is not the oracle owner user "oracle" of oracle home "/u01/app/oracle/product/11.2.0/dbhome_1"



[oracle@node1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 24-AUG-2017 19:56:25
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                24-AUG-2017 19:19:59
Uptime                    0 days 0 hr. 36 min. 49 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/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.20)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.22)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@node2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 24-AUG-2017 19:55:48
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                24-AUG-2017 19:24:29
Uptime                    0 days 0 hr. 31 min. 29 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/grid/diag/tnslsnr/node2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.24)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.23)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully


添加一个service：srv1，orcl1是prefer，orcl2是available：
srvctl add service -d orcl -s srv1 -r orcl1 -a orcl2
srvctl start service -d orcl -s srv1 


[oracle@node1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 24-AUG-2017 20:09:06
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                24-AUG-2017 19:19:59
Uptime                    0 days 0 hr. 49 min. 12 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/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.20)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.22)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "srv1" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@node2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 24-AUG-2017 20:09:10
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                24-AUG-2017 19:24:29
Uptime                    0 days 0 hr. 44 min. 44 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/grid/diag/tnslsnr/node2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.24)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.23)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully






异常关闭orcl1，再过一会，会看到srv1在orcl2上启动了。

[root@node1 ~]# crsctl stop crs
[oracle@node2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 24-AUG-2017 21:11:40
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                24-AUG-2017 19:24:29
Uptime                    0 days 1 hr. 47 min. 28 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/grid/diag/tnslsnr/node2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.24)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.92.23)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "srv1" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully



可以为服务添加多个preferred实例，这样可以不需要available实例：
srvctl add service -d orcl -s srv2 -r orcl1,orcl2
srvctl start service -d orcl -s srv2
[oracle@node1 ~]$ srvctl status service -d orcl -s srv2
Service srv2 is running on instance(s) orcl1,orcl2


service可以只定义preferred实例，而不定义available实例。但是这样就没有HA了。
这样当service所在的实例崩溃以后，该service不会failover到另外一个实例上去。


把srv1从orcl1上运行，转移到orcl2上运行：
srvctl relocate service -d orcl -s srv1 -i orcl1 -t orcl2

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

转载于:http://blog.itpub.net/30126024/viewspace-2144123/

cjh81378066
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle srvctl命令,用srvctl命令配置service
weixin_42105570的博客
04-14 2261
.用srvctl命令配置service 除了用DBCA图形方式，还可以使用命令方式配置service，这种方法对于维护远程尤其有用。无论是创建还是维护都是用一个命令srvctl，先看一下srvctl命令和service相关的语法，如下： 创建service [oracle@felix1 ~]$ srvctl add servi.用srvctl命令配置service除了用DBCA图形方式，还可以使用...
service的创建与使用
ciliting2867的博客
09-03 167
1.DBCA创建service2. srvctl创建service--创建service[oracle@rac01 admin]$ srvctl add service -d mbs -s batch -r mbs2 -a mb...
基于preferred和available参数的service故障转移测试
cty48663的博客
07-12 448
ORACLE官方文档中有这样一段描述: When you define a service for an administrator-managed database, you define which instances ...
RAC11g创建Service实现Failover
sqlora的专栏
12-22 395
Oracle版本:Oracle11g R2 x86企业版(RAC) 操作系统:OEL5.4 一般我们实现RAC节点上的故障转移，可以在客户端的tnsnames.ora文件当中，或者在服务器中配置Service实现故障转移功能； 我们可以通过srvctl命令创建Service，例子如下： 1.首先我们确保crs服务全部online [grid@rac1 admin]$ crs_stat -t Name Type Target State Host ...
从RAC One Node到RAC
在路上
11-11 1008
1.执行命令将RAC One Node转换为RAC [root@rac1 bin]# ./srvctl convert database -d ron -c RAC -n rac1 PRCD-1148 : Failed to convert the configuration of RAC One Node database ron into its equivalent configurati
STM32新手常见的一个错误解决
08-04
本文介绍了新入手STM32时常遇到的一个错误...\OutProj\test.axf: Error: L6218E: Undefined symbol SystemInit (referred from startup_stm32f10x_md.o).的解决方法。
2020 IEEE Thesaurus.pdf 同义词典是一个控制词汇-关键词-同义词词典
07-23
2020年最新-IEEE电气和电子工程师协会_工程科学类的全部 关键词索引The IEEE Thesaurus is a controlled vocabulary of almost 10,644 descriptive engineering, technical and scientific terms, as well as ...
提供学校心理服务的另一种方法
06-29
students referred to them. This article describes one model-process which the author, while functioning as a school psychologist, successfully implemented to eliminate this criticism. Adoption of ...
转诊到阅读诊所的受试者的 slosson 智力测验和 wisc 分数的比较
06-29
Comparison of the slosson intelligence test and wisc scores of subjects referred to a reading clinic COMPARISON OF THE SLOSSON INTELLIGENCE TEST AND WISC SCORES O F SUBJECTS REFERRED TO A READING ...
WISC-R 和 WRAT 的关系：一项基于选定人群的研究
06-29
The relationship of the WISC-R and WRAT: A study based upon a selected population ...administered by the same school psychologist to 282 urban students referred for sychological evaluation. The corr
关系型数据库服务出现宕机宕机原因记录
mpren的专栏
11-23 3296
关系型数据库服务出现宕机现象，数据库异常重启，并且重启后数据库持续处于只读状态，直到DBA手动打开数据库读写状态，才恢复正常访问。经分析，主要原因如下： 1、 当时故障前进行压力测试，QPS 28000，TPS 12800;审计插件(第三方开源插件MariaDB Audit Plugin)，导致数据库异常重启。MariaDB Audit Plugin采用sql审计的方式，将来的数据库审计可以采用旁...
service_name的一点理解
xionglang7的专栏
02-21 4341
1,一般认为是只要tnsping能通，那么数据库就应该可以连接上，但是下面的这种情况就连接不上。 D:\Users\xionglang619>tnsping orcl TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 21-2月 - 2013 13:00:18 Copyright (c) 1997
11g RAC负载均衡和故障转移配置
Breath_wang的博客
06-04 1938
Oracle RAC层面提供两种不同的方式进行负载均衡： 1.客户端负载均衡 (Client-Side LB) 2.服务器端均衡（Server-Side LB) Oracle RAC 的failover 按实现方式分为两种： 一：Client-Side TAF （客户端处理） 二：.Service-Side TAF （服务端处理） Oracle RAC层面提供两种不同的方式进行...
用srvctl命令配置service
Mr.pan felix的专栏
06-03 1万+
.用srvctl命令配置service   除了用DBCA图形方式，还可以使用命令方式配置service，这种方法对于维护远程尤其有用。无论是创建还是维护都是用一个命令srvctl，先看一下srvctl命令和service相关的语法，如下： 创建service [oracle@felix1 ~]$ srvctl add service -h Usage: srvctl add servi...
11.2 RAC实例关闭的时候服务不漂移到另一个节点
逝鸿的博客
11-25 1552
11.2 RAC实例关闭的时候服务不漂移到另一个节点 范围 11.2.0.2及以后的版本，所有平台 症状 ‘srvctl stop instance’关闭了实例但是服务没有故障转移到可用节点。 在11.2之前的版本，通过srvctl或sqlplus关闭实例会触发服务转移到可用节点。 1）在GRB数据库上创建优先节点一的服务grb_stest01 srvctl
完美解决：You are using pip version 20.0.2, however version 20.1 is available.......问题
热门推荐
梓源的博客
05-15 6万+
windows 64,anaconda python3 今天在使用pip安装库时报错。 这个意思也就是说我们pip版本有最新的需要我们进行更新。 解决方法： 1.pip直接更新 pip install --upgrade pip pip3 install --user --upgrade pip 2.直接使用后面的提示命令 也就是you should consider upgrading via the 后面的命令 3.使用命令 python3 -m pip install pip==版本号 更新完成
Oracle 11g R2 RAC：使用 srvctl 工具管理 service 资源
DBA never sleep-DBA，永不眠
08-14 6325
1、使用 srvctl 工具创建 service 资源 srvctl add service -d db_unique_name -s service_name {-r "preferred_list" [-a "available_list"] [-P {BASIC | NONE | PRECONNECT}] | -g server_pool [-c {UNIFORM | SI
nginx 负载均衡时，一台tomcat宕机时的问题 自动切换
papima的博客
07-10 5767
 用了nginx负载均衡后，在两台tomcat正常运行的情况下，访问http://localhost 速度非常迅速，通过测试程序也可以看出是得到的负载均衡的效果，但是我们试验性的把其中一台tomcat（server localhost:8080）关闭后，再查看http://localhost，发现反应呈现了一半反映时间快，一半反映时间非常非常慢的情况，但是最后都能得到正确结果. 解决办法：问题解决...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值