oracle rac service学习
来源：互联网 发布：工程量预算软件 编辑：程序博客网 时间：2024/05/23 18:01
1.添加服务，添加完成服务之后默认服务不会启动，需要手工启动：
[oracle@suq1 ~]$srvctl add service -d suq -s srv1 -r suq1,suq2[grid@suq1 admin]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.BACKUP.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.DATADG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.LISTENER.lsnr ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.SYSTEMDG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.asm ONLINE ONLINE suq1 Started ONLINE ONLINE suq2 Started ora.gsd OFFLINE OFFLINE suq1 OFFLINE OFFLINE suq2 ora.net1.network ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.ons ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.registry.acfs ONLINE ONLINE suq1 ONLINE ONLINE suq2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE suq2 ora.cvu 1 ONLINE ONLINE suq2 ora.oc4j 1 ONLINE ONLINE suq2 ora.scan1.vip 1 ONLINE ONLINE suq2 ora.suq.db 1 ONLINE ONLINE suq1 Open 2 ONLINE ONLINE suq2 Open ora.suq.srv1.svc 1 OFFLINE OFFLINE 2 OFFLINE OFFLINE ora.suq1.vip 1 ONLINE ONLINE suq1 ora.suq2.vip 1 ONLINE ONLINE suq2
2.查看服务信息，并且手工启动服务：
[oracle@suq1 ~]$ srvctl config service -d suq -s srv1Service name: srv1Service is enabledServer pool: suq_srv1Cardinality: 2Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: falseFailover type: NONEFailover method: NONETAF failover retries: 0TAF failover delay: 0Connection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: NONEEdition: Preferred instances: suq1,suq2Available instances: [grid@suq1 admin]$ srvctl start service -d suq -s srv1[grid@suq1 admin]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.BACKUP.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.DATADG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.LISTENER.lsnr ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.SYSTEMDG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.asm ONLINE ONLINE suq1 Started ONLINE ONLINE suq2 Started ora.gsd OFFLINE OFFLINE suq1 OFFLINE OFFLINE suq2 ora.net1.network ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.ons ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.registry.acfs ONLINE ONLINE suq1 ONLINE ONLINE suq2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE suq2 ora.cvu 1 ONLINE ONLINE suq2 ora.oc4j 1 ONLINE ONLINE suq2 ora.scan1.vip 1 ONLINE ONLINE suq2 ora.suq.db 1 ONLINE ONLINE suq1 Open 2 ONLINE ONLINE suq2 Open ora.suq.srv1.svc 1 ONLINE ONLINE suq1 2 ONLINE ONLINE suq2 ora.suq1.vip 1 ONLINE ONLINE suq1 ora.suq2.vip 1 ONLINE ONLINE suq2
3.修改服务，让服务只可运行在实力1上：
[oracle@suq1 ~]$ srvctl modify service -d suq -s srv1 -i suq1 -n[grid@suq1 admin]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.BACKUP.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.DATADG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.LISTENER.lsnr ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.SYSTEMDG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.asm ONLINE ONLINE suq1 Started ONLINE ONLINE suq2 Started ora.gsd OFFLINE OFFLINE suq1 OFFLINE OFFLINE suq2 ora.net1.network ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.ons ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.registry.acfs ONLINE ONLINE suq1 ONLINE ONLINE suq2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE suq2 ora.cvu 1 ONLINE ONLINE suq2 ora.oc4j 1 ONLINE ONLINE suq2 ora.scan1.vip 1 ONLINE ONLINE suq2 ora.suq.db 1 ONLINE ONLINE suq1 Open 2 ONLINE ONLINE suq2 Open ora.suq.srv1.svc 1 ONLINE ONLINE suq1 ora.suq1.vip 1 ONLINE ONLINE suq1 ora.suq2.vip 1 ONLINE ONLINE suq2
4.先将可用实例添加上实例2，然后手工将服务从实例1 relocate到实例2上：
[oracle@suq1 ~]$ srvctl stop service -d suq -s srv1 -i suq1[grid@suq1 admin]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.BACKUP.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.DATADG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.LISTENER.lsnr ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.SYSTEMDG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.asm ONLINE ONLINE suq1 Started ONLINE ONLINE suq2 Started ora.gsd OFFLINE OFFLINE suq1 OFFLINE OFFLINE suq2 ora.net1.network ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.ons ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.registry.acfs ONLINE ONLINE suq1 ONLINE ONLINE suq2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE suq2 ora.cvu 1 ONLINE ONLINE suq2 ora.oc4j 1 ONLINE ONLINE suq2 ora.scan1.vip 1 ONLINE ONLINE suq2 ora.suq.db 1 ONLINE ONLINE suq1 Open 2 ONLINE ONLINE suq2 Open ora.suq.srv1.svc 1 OFFLINE OFFLINE ora.suq1.vip 1 ONLINE ONLINE suq1 ora.suq2.vip 1 ONLINE ONLINE suq2 [oracle@suq1 ~]$ srvctl modify service -d suq -s srv1 -i suq1,suq2 -n [grid@suq1 admin]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.BACKUP.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.DATADG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.LISTENER.lsnr ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.SYSTEMDG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.asm ONLINE ONLINE suq1 Started ONLINE ONLINE suq2 Started ora.gsd OFFLINE OFFLINE suq1 OFFLINE OFFLINE suq2 ora.net1.network ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.ons ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.registry.acfs ONLINE ONLINE suq1 ONLINE ONLINE suq2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE suq2 ora.cvu 1 ONLINE ONLINE suq2 ora.oc4j 1 ONLINE ONLINE suq2 ora.scan1.vip 1 ONLINE ONLINE suq2 ora.suq.db 1 ONLINE ONLINE suq1 Open 2 ONLINE ONLINE suq2 Open ora.suq.srv1.svc 1 ONLINE ONLINE suq1 2 OFFLINE OFFLINE ora.suq1.vip 1 ONLINE ONLINE suq1 ora.suq2.vip 1 ONLINE ONLINE suq2 [oracle@suq1 ~]$ srvctl relocate service -d suq -s srv1 -i suq1 -t suq2 #-i 源实例 -t 目标实例[grid@suq1 admin]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.BACKUP.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.DATADG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.LISTENER.lsnr ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.SYSTEMDG.dg ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.asm ONLINE ONLINE suq1 Started ONLINE ONLINE suq2 Started ora.gsd OFFLINE OFFLINE suq1 OFFLINE OFFLINE suq2 ora.net1.network ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.ons ONLINE ONLINE suq1 ONLINE ONLINE suq2 ora.registry.acfs ONLINE ONLINE suq1 ONLINE ONLINE suq2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE suq2 ora.cvu 1 ONLINE ONLINE suq2 ora.oc4j 1 ONLINE ONLINE suq2 ora.scan1.vip 1 ONLINE ONLINE suq2 ora.suq.db 1 ONLINE ONLINE suq1 Open 2 ONLINE ONLINE suq2 Open ora.suq.srv1.svc 1 ONLINE ONLINE suq2 2 OFFLINE OFFLINE ora.suq1.vip 1 ONLINE ONLINE suq1 ora.suq2.vip 1 ONLINE ONLINE suq25.查看服务状态：
[oracle@suq1 ~]$ srvctl status service -d suq -s srv1Service srv1 is running on instance(s) suq2
6.删除服务：
[oracle@suq1 ~]$ srvctl remove service -d suq -s srv1 PRCR-1025 : Resource ora.suq.srv1.svc is still running[oracle@suq1 ~]$ srvctl stop service -d suq -s srv1[oracle@suq1 ~]$ srvctl remove service -d suq -s srv1
0 0
- oracle rac service学习
- Oracle RAC Service资源
- Oracle RAC Service资源
- Oracle RAC学习笔记
- Oracle RAC 学习笔记3
- oracle rac添加service的过程（11gr2版本）
- Oracle 11gR2 RAC Service-Side TAF 配置示例
- Oracle 11gR2 RAC Service-Side TAF 配置示例
- Oracle 11gR2 RAC Service-Side TAF 配置示例
- oracle-11gR2 RAC service Side TAF的配置
- Oracle 11gR2 RAC 使用默认service实现负载均衡
- Oracle RAC学习笔记:基本概念及入门
- Oracle RAC学习笔记:基本概念及入门
- Oracle RAC学习笔记:基本概念及入门
- Oracle RAC学习笔记:基本概念及入门
- Oracle RAC学习笔记01-集群理论
- Oracle RAC学习笔记01-集群理论
- Oracle RAC学习之--OPS中的RAC Ping和RAC Cache Fusion
- lytro原始图片重聚焦
- C和C++格式化输入输出
- Linux基本命令一
- 黑马程序员--Java集合框架(2)
- hadoop2.6.0编译使用
- oracle rac service学习
- Loadrunner 服务器压力上不去，客户端出现大量timed out
- Java性能调优笔记
- 安卓实习第二十二天
- hdu 5389 Zero Escape
- POJ 1751 Highways 最小生成树 Kruskal && Prim
- Android 实现ListView的A-Z字母排序和过滤搜索功能，实现汉字转成拼音
- 关于lingo的例子
- Java学习之路0813（HttpClient中的doGet和doPost实例）
