澳门新葡亰平台官网Oracle Faq(Oracle TAF的配置)

如需转发,请注脚出处!Oracle TAF的布置TAF为Transparent Application
FailOver的缩写,常常采取TAF都以在OPS/RAC蒙受中。从8i初叶部分这一功能,指标和冥思苦想都以很好的,但当下选用还很简单,本文将本着TAF相关主题材料作个详细搜求。本文的测量试验情状是Tru64
V5.1+ Oracle9.2.0.1
RAC。一、相关参数的验证说真话oracle关于网络的多少个布局参数真的是太乱了,很五个人都弄不清到底是怎么回事,见惯不惊的大谬不然为:”ORA-12514
:TNS:listener could not resolve SE中华VVICE_NAME given in connect
descriptor” 和”ORA-12154 :TNS: Could not resolve service name”
实质都以同等的,要解决那样的难点亟待大家弄情多少个参数:initsid.ora中的多少个参数:DB_NAME
— database name,即建数据库时所提供的称谓。GLOBAL_NAMES —
True/false,设定是或不是选用数据库域名。DB_DOMAIN —
数据库域名,假诺GLOBAL_NAMES=True则要求提供那一个参数。SE瑞虎VICE_NAMES —
service names list,服务名称,可以有多个。INSTANCE_NAME — instance

name,和SERVICE_NAMES相符从817起来援助,即从817起先能够将数据库、实例和服务名称分开。私下认可instance_name的值为instance的SID,即处境变量ORACLE_SID所对应的值。在817原先并未有instance_name参数时,差别的instance是以SID来分化的。根据oracle817今后的文书档案解释:SID是为了分歧同一主机上各instance的共享内部存款和储蓄器,并非instance的独一差距标示,而instance_name则是分别各类instance的。情状变量:ORACLE_SID

在817在先没有instance_name参数时,区别的instance是以SID来区分的。listener.ora中的多少个参数:GLOBAL_DBNAME

全局数据库名称,在布满式意况中独一显著分裂的数据库。它的值为initsid.ora中DB_NAME和DB_DOMAIN的组合,即GLOBAL_DBNAME=DB_NAME.DB_澳门新葡亰平台官网,DOMAIN,其中DB_DOMAIN若无设此处也就不必要了。那几个参数在遍及式境遇中国建工总集团议明确内定。SE库罗德VICE_NAME
— 服务名称,取initsid.ora中service_names list至一就能够。SID_NAME —
对应遭遇变量ORACLE_SID的值。INSTANCE_NAME
—对应初步化参数instance_name。tnsnames.ora中的多少个参数:service_name
— 服务名称,取initsid.ora中service_names list至一就能够。sid_name —

能够简写成:sid,对应ORACLE_SID,也足以是开始化参数instance_name,当等于instance_name且instance_name不等于ORACLE_SID时,oracle会自动注册一个监听进度,此用以区分不相同的instance。instance_name

从817发端有了这一个新的参数能够运用,对应初叶化参数instance_name。那样一来,参数就很复杂了,可是我们实际使用并不会用当然一月轻巧越好了。二、相关参数设置上边作者将比如表达相关参数的设置:1、意况变量:ORACLE_SID=rac1/22、initsid.ora:db_name=ora92service_names

ora92instance_name=rac1/2global_names=falsedb_domain=””3、listener.ora:SID_LIST_RAC1
=(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = ora92)(ORACLE_HOME =
/oracle/oracle9/app/oracle/product/9.2.0)(SERVICE_NAME=ora92)(SID_NAME
= rac1)))SID_LIST_RAC2 =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME =
ora92)(ORACLE_HOME =
/oracle/oracle9/app/oracle/product/9.2.0)(SERVICE_NAME=ora92)(SID_NAME
= rac2)))RAC1 =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST
=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.1)(PORT = 1522)))))RAC2
=(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL
= TCP卡塔尔(HOST = 10.1.3.2卡塔尔(PORT =
1522卡塔尔State of Qatar卡塔尔State of Qatar卡塔尔(قطر‎三、TAF的装置其实TAF设置非常不难,在tnsnames.ora中增添failover=on就可以,有三种不一致的安装方法:1、公用一个tns
name格局:==================================================myrac
=(description=(load_balance=on)(failover=on)(address=
(protocol=tcp)(host=10.1.3.1)(port=1522))(address=
(protocol=tcp)(host=10.1.3.2)(port=1522))(connect_data=
(service_name=ora92)(failover_mode=(type=select)(method=basic)(retries=20)(delay=20))))==========================================================================2、指明instance
backup方式:===============================================rac1
=(description=(load_balance=on) (failover=on) (address=
(protocol=tcp)(host=10.1.3.1)(port=1522)) (connect_data=
(service_name=ora92)(failover_mode=(type=select)(method=basic)(backup=rac2)(retries=20)(delay=20))))rac2
=(description=(load_balance=on) (failover=on) (address=
(protocol=tcp)(host=10.1.3.2)(port=1522)) (connect_data=
(service_name=ora92)(failover_mode=(type=selectState of Qatar(method=basic卡塔尔国(backup=rac1卡塔尔(retries=20State of Qatar(delay=20卡塔尔(قطر‎State of Qatar卡塔尔卡塔尔(قطر‎==========================================================================四、TAF测量检验方法日常能够将近些日子再而三的instance
down下来,client端将不会断开,并自行切换成backup节点上。相反也会活动切换回来。当然也会有人建议用post_transaction的主意来测量试验TAF,其实这样临时候是得不到预期结果的,原因在于Oracle连接到一个instance上后,从今以后它会优先尝试对该instance的连续几日,当您disconnect后,client端一有新的伸手就能自行尝试对新近一而再三翻五次的instance实行接二连三,假若不成功才会尝试对backup
instance举行连接。

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图