oracle11g rac服务切换测试

创建服务srvctl add service -d rac -s service1_manual -r rac1 -a rac2启用服务srvctl start service -d rac -s service1_manual查看服务配置[oracle@rac1 bin]$ srvctl config service -d rac -s service1_manualService name: service1_manualService is enabledServer pool: rac_service1_manualCardinality: 1Disconnect: 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: rac1Available instances: rac2关闭实例rac1srvctl stop instance -d rac -i rac1检查服务状态--此时的状态没有运行，没有使用备选的rac2srvctl status service -d rac -s service1_manualService service1_manual is not running.使用sqlplus关闭实例，在查看服务状态SQL> shutdown immeidateSP2-0717: illegal SHUTDOWN optionSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.[oracle@rac1 ~]$ srvctl status service -d rac -s service1_manualService service1_manual is running on instance(s) rac2看到服务已经使用了可用节点，对于srvctl命令关闭实例，服务没有切换到可用节点上。sqlplus关闭实例的，是切换上去了。在使用sqlplus命令启动实例后，服务没有切换回来SQL> startupORACLE instance started.Total System Global Area  839282688 bytesFixed Size          2257880 bytesVariable Size         608177192 bytesDatabase Buffers      226492416 bytesRedo Buffers            2355200 bytesDatabase mounted.Database opened.SQL> show parameter serviceNAME                     TYPE------------------------------------ ---------------------------------VALUE------------------------------service_names                stringrac使用命令重新分配，将服务切换到rac1srvctl relocate service -d rac -s service1_manual -i rac2 -t rac1[oracle@rac1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-AUG-2017 12:35:39Copyright (c) 1991, 2013, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionStart Date                06-AUG-2017 10:05:19Uptime                    0 days 2 hr. 30 min. 20 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/grid/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/rac1/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.71)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.81)(PORT=1521)))Services Summary...Service "+ASM" has 1 instance(s).  Instance "+ASM1", status READY, has 1 handler(s) for this service...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...Service "service1_manual" has 1 instance(s).  Instance "rac1", status READY, has 1 handler(s) for this service...The command completed successfully看到已经切换回来了