ORACLE服务器TAF配置说明书.docx
《ORACLE服务器TAF配置说明书.docx》由会员分享,可在线阅读,更多相关《ORACLE服务器TAF配置说明书.docx(11页珍藏版)》请在三一办公上搜索。
1、KingdeeORACLE服务器TAF配置说明书目录ORACLE服务器端TAF的配置说明书1一、说明1二、服务端配置方法1三、客户端的配置方法3四、手动模拟转移测试验证.4五、故障转移验证验证5手工关闭某个实例5自身故障6六、注意事项7一、说明一TAF (TRANSPORT APPLICATION FAILOVER 简称透明应用故障转移)是在优化系统架 构的同时,提高系统的可用性。对比在客户端,在服务器端配置TAF,可以简化TAF的使用方法。本文介绍在ORACLE RAC服务器端/客户端上TAF的配置方法、及测试验证、及注意事项。二、服务端配置方法环境说明:ORACLE 11204,RAC双节
2、点,1. 查看数据库上已配置的服务(名)。oracle tlmbdb1/home/oracle$srvctl config service -d tlmborclService name: srv10Service is enabledServer pool: tlmborcl_srv10Cardinality: 1Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: falseFailover type: SELECTFailov
3、er method: NONETAF failover retries: 0TAF failover delay: 0Connection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition:Preferred instances: tlmborcllAvailable instances: tlmborcl2Service name: srv20Service is enabledServer pool: tlmborcl_srv20Cardinali
4、ty: 1Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: falseFailover type: SELECTFailover method: NONETAF failover retries: 0TAF failover delay: 0Connection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification:
5、BASICEdition:Preferred instances: tlmborcl2Available instances: tlmborcl1说明: tlmbdb1,节点1的服务器名称,节点2名称为tlmbdb2。 d tlmborcl,目标数据库服务名称,用于登录数据库。配置后,当使用该服 务名登录数据库时,不论登录到哪个实例(节点),都是登录到该数据库(一 个节点上可以存在多个数据库)。 节点1的实例名为tlmborcl1,节点2的实例名为tlmborcl2。 srv10,srv20,服务名(文章中提及的服务和服务名,本质都是一个意思。服 务是指功能,服务名是指该功能的表现名称)。2.
6、 删除原来的服务,重新配置。2.1停止原服务。oracletlmbdb1/home/oracle$srvctl stop service -d tlmborcl -s srv10 oracletlmbdb1/home/oracle$srvctl stop service -d tlmborcl -s srv202.2删除原服务。oracletlmbdb1/home/oracle$srvctl remove service -d tlmborcl -s srv10 oracletlmbdb1/home/oracle$srvctl remove service -d tlmborcl -s srv
7、202.3重新配置服务,这里用回原来的名称。oracletlmbdb1/home/oracle$srvctl add service -d tlmborcl -s srv10 -r tlmborcll -a tlmborcl2 -P basic -e selectoracletlmbdb1/home/oracle$srvctl add service -d tlmborcl -s srv20 -r tlmborcl2 -a tlmborcll -P basic -e select说明:-d指明是哪个数据库的服务-s服务名-r首选实例-a备选实例-P故障转移类型-e允许的故障转移操作2.4查看服
8、务状态。oracletlmbdb1/home/oracle$srvctl status service -d tlmborclService srv10 is not running.Service srv20 is not running.说明:创建服务后,服务的状态为关闭。必须得启动服务才能使用。2.5启动服务。oracletlmbdb1/home/oracle$srvctl start service -d tlmborclService srv10 is running on instance(s) tlmborcllService srv20 is running on instan
9、ce(s) tlmborcl2oracletlmbdb1/home/oracle$说明:服务在哪个实例上running,使用该服务名登录时,将登录到该实例。3. 连接测试当使用srv10服务名时,将连接/登录到实例1(tlmborcl1)。若被重新转移/ 重新分配到实例2时,将连接/登录到实例2( tlmborcl2)。使用srv20时同理。oracletlmbdb1/home/oracle$sqlplus cloudzs/cloudzssrv10 SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 18 16:34:03 2018 Copyr
10、ight (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing optionsCLOUDZSsrv10select instance_
11、name from v$instance;INSTANCE_NAME tlmborcl1Elapsed: 00:00:00.00CLOUDZSsrv10connect cloudzs/cloudzssrv20、 Connected.CLOUDZSsrv20select instance_name from v$instance;INSTANCE_NAME tlmborcl2Elapsed: 00:00:00.02三、客户端的配置方法修改oracle下的tnsnames.ora文件,增加实例名称配置。 rac 1 e(&tlmbdb2/oracte/app/dblLgfnetwork/adnii
12、n$nnore tnsnames. orafi- Lrisnaries ora Networ_k Configuration File: /racle/app/dbllg/network/ajdmin/tnsndnies .ora 若 Generated by Oracle ronHguration too ITLMBORCL =tImbdb-Stan)PORT 1521)Llmbdb-sc an) (PORT = 1521)Lliribdb-scan)(POFLT - 1521)(DESCRIPTION =CADDRESS (PROTOCOL = TCP)(HOST =CCONNECT.DA
13、TA -(SERVER = DEDT3TF。(SERVICE_NAML = tlfflborcl)一 RVIO =CRIPTION (ADDRESS = (PROTOCOL = TCP)(HOST =CONNECT DATA =(SERVER = DEDLCATED1(SERVICE.NAME - .rvlCi)5RV?0 -(DESCRIPTION =CADDRES5 - (PROTOCOL - KP)(HO5T -CCOMECT_DATA -(SERVER - DEDICATED)(SERVICE_NAMt = STVZO)orac1e(&tliiibdb2/arac1 e/app/dbl
14、ig/netork/adoiinS说明:椭圆标记的srv10,是上述命令srvctl add service-d tlmborcl-s srv10里指定的名称。方框标记的SRV10,是连接串的名称,可以任意命名。四、手动模拟转移测试验证把服务名srv10的首实例,从tlmborcll转到tlmborcl2。oracletlmbdb1/home/oracle$srvctl relocate service -d tlmborcl -s srv10 -i tlmborcl1 -t tlmborcl2 说明:relocate转移/重新分配-i服务原先的首实例-t服务新的首实例1. 查看转移后服务名所
15、在实例oracletlmbdb1/home/oracle$srvctl status service -d tlmborclService srv10 is running on instance(s) tlmborcl2Service srv20 is running on instance(s) tlmborcl22. 手动转移服务名的首实例,只是临时性的操作,不会改变配置中最初的首实例oracletlmbdb1/home/oracle$srvctl config service -d tlmborcl -s srv10Service name: srv10Service is enabl
16、edServer pool: tlmborcl_srv10Cardinality: 1Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: falseFailover type: SELECTFailover method: NONETAF failover retries: 0TAF failover delay: 0Connection Load Balancing Goal: LONGRuntime Load Balancin
17、g Goal: NONETAF policy specification: BASICEdition:Preferred instances: tlmborcllAvailable instances: tlmborcl2oracletlmbdb1/home/oracle$3. 测试手动转移服务首实例后的效果oracletlmbdb1/home/oracle$sqlplus cloudzs/cloudzssrv10SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 18 16:40:52 2018Copyright (c) 1982, 2013
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ORACLE 服务器 TAF 配置 说明书
链接地址:https://www.31ppt.com/p-4887080.html