10g RAC 使用service實現taf，ractaf

10g RAC 使用service實現taf，ractaf

service作為oracle資料庫中的關鍵概念之一，利用得當，可以方便資料庫的管理，提高資料庫的執行效率。

通過service，oracle可以實現server side  taf，簡化對用戶端的維護量，下面我們看一下在10g rac 怎樣實驗service實現 serve side  taf

使用dbca來配置taf

通過dbca可以非常方便的配置server  side taf

至此，service配置完成，下面我們驗證一下

[root@node1 ~]# su - oracle[oracle@node1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.5.0 - Production on 05-AUG-2014 21:46:10Copyright (c) 1991, 2010, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias                     LISTENER_NODE1Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - ProductionStart Date                05-AUG-2014 21:26:40Uptime                    0 days 0 hr. 19 min. 30 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/db/network/admin/listener.oraListener Log File         /u01/app/oracle/product/11.2.0/db/network/log/listener_node1.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.131)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.31)(PORT=1521)))Services Summary...Service "+ASM" has 1 instance(s).  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...Service "+ASM_XPT" has 1 instance(s).  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...Service "PLSExtProc" has 1 instance(s).  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "racdb" has 3 instance(s).  Instance "racdb", status UNKNOWN, has 1 handler(s) for this service...  Instance "racdb1", status READY, has 2 handler(s) for this service...  Instance "racdb2", status READY, has 1 handler(s) for this service...Service "racdbXDB" has 2 instance(s).  Instance "racdb1", status READY, has 1 handler(s) for this service...  Instance "racdb2", status READY, has 1 handler(s) for this service...Service "racdb_XPT" has 2 instance(s).  Instance "racdb1", status READY, has 2 handler(s) for this service...  Instance "racdb2", status READY, has 1 handler(s) for this service...Service "service1" has 1 instance(s).  Instance "racdb1", status READY, has 2 handler(s) for this service...The command completed successfully[oracle@node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Tue Aug 5 21:46:23 2014Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter serviceNAME     TYPE VALUE------------------------------------ ----------- ------------------------------service_names     string service1SQL> col name for a20SQL> col failover_method for a20SQL> col failover_type for a20SQL>  select name,failover_method,failover_type from dba_services;NAME     FAILOVER_METHOD  FAILOVER_TYPE-------------------- -------------------- --------------------SYS$BACKGROUNDSYS$USERSseeddataXDBseeddata.regress.rdbms.dev.us.oracle.comracdbXDBracdbservice17 rows selected.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options[oracle@node1 ~]$ srvctl config service -d racdb -s service1 -aservice1 PREF: racdb1 AVAIL: racdb2 TAF: basic[oracle@node1 ~]$ srvctl config service -d racdbservice1 PREF: racdb1 AVAIL: racdb2

從上面的結果可以看出，通過dbca配置service 的taf，會在ocr中儲存taf配置資訊（僅僅是taf method），在資料庫參數檔案中會添加service條目，並且在資料字典中添加相應記錄，但是資料字典中的taf資訊是空的，需要另外添加，如

SQL> begin  2  dbms_service.modify_service(  3  service_name=>'service1',  4  failover_method=>dbms_service.failover_method_basic,  5  failover_type => dbms_service.failover_type_select,  6  failover_retries => 180,  7  failover_delay => 5   8  );  9  end; 10  /PL/SQL procedure successfully completed.SQL> col name for a20SQL> col failover_method for a20SQL> col failover_type for a20SQL> select name,failover_method,failover_type from dba_services;NAME     FAILOVER_METHOD  FAILOVER_TYPE-------------------- -------------------- --------------------SYS$BACKGROUNDSYS$USERSseeddataXDBseeddata.regress.rdbms.dev.us.oracle.comracdbXDBracdbservice1     BASIC  SELECT7 rows selected.

另外，也可以使用srvctl來添加service

[root@node1 ~]# srvctl add service -hUsage: srvctl add service -d <name> -s <service_name> -r "<preferred_list>" [-a "<available_list>"] [-P <TAF_policy>]    -d <name>           Unique name for the database    -s <service>        Service name    -r "<pref_list>"    List of preferred instances    -a "<avail_list>"   List of available instances    -P <TAF_policy>     TAF policy (NONE, BASIC, or PRECONNECT)Usage: srvctl add service -d <name> -s <service_name> -u {-r "<new_pref_inst>" | -a "<new_avail_inst>"}    -d <name>           Unique name for the database    -s <service>        Service name    -u                  Add a new instance to service configuration    -r <new_pref_inst>  Name of new preferred instance    -a <new_avail_inst> Name of new available instance    -h                  Print usage[root@node1 ~]# srvctl add service -d racdb -s service2 -r racdb1 -a racdb2 -P BASICPRKH-1014 : Current user root is not the same as oracle owner oracle of oracle home /u01/app/oracle/product/11.2.0/db.[root@node1 ~]# su - oracle[oracle@node1 ~]$ srvctl add service -d racdb -s service2 -r racdb1 -a racdb2 -P BASIC[oracle@node1 ~]$ srvctl config service -d racdb -aservice1 PREF: racdb1 AVAIL: racdb2 TAF: basicservice2 PREF: racdb1 AVAIL: racdb2 TAF: BASIC[oracle@node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Tue Aug 5 22:16:43 2014Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter serviceNAME     TYPE VALUE------------------------------------ ----------- ------------------------------service_names     string service1, racdbSQL> select name from dba_services;NAME----------------------------------------------------------------SYS$BACKGROUNDSYS$USERSseeddataXDBseeddata.regress.rdbms.dev.us.oracle.comracdbXDBracdbservice17 rows selected.

從這裡，可以看出通過srvct添加的service不會在資料庫參數和資料字典中添加相應的資訊

oracle 11g 還需要配置 Service-Side TAF ？

TAF可以在安裝完rac後配置，也可以在安裝中配置，其實就是實現一個服務的負載平衡和failover，應該用srvctl配置的，注意用grid使用者下的crs目錄中的srvctl
 
oracle 10g rac 怎安裝與配置，我要做雙機熱備，講解

Oracle RAC和雙機熱備的概念還不太一樣，RAC是負載平衡及容錯移轉叢集，雙機熱備一般指HA，這兩種群集的授與類型不一樣，從法律許可和部署、維護難度上講都有很大差別。
雙機熱備建議考慮Windows企業版的容錯移轉叢集功能或Rose HA軟體。
但不論是以上哪種方式的群集，都需要共用儲存的支援，必須確認硬體上有足夠的資源部署。