10g RAC with service up to Taf

Service thanks to a key concept in the Oracle database, it is easy to manage the database and improve the efficiency of the database by using it properly.

by service. Oracle can implement server side TAF, simplifying client repair, let's look at how the 10g RAC tests the service implementation serve side TAF

Use DBCA to configure TAF

Server side can be conveniently configured with DBCA TAF

So far. Service configuration is complete, the following we verify

[[email protected] ~]# su-oracle[[email protected] ~]$ lsnrctl statuslsnrctl for Linux:version 10.2.0.5.0-p  Roduction on 05-aug-2014 21:46:10copyright (c) 1991, 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. min. at 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.logliste  Ning 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, have 1 handler (s) for the This service ...  Service "+ASM_XPT" has 1 instance (s). Instance "+asm1", status BLOCKED, have 1 handler (s) for the This service ...  Service "Plsextproc" has 1 instance (s). Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...  Service "RACDB" has 3 instance (s).  Instance "racdb", status UNKNOWN, have 1 handler (s) for the This service ...  Instance "RACDB1", status ready, have 2 handler (s) for the This service ... Instance "RACDB2", status ready, have 1 handler (s) for the This service ...  Service "Racdbxdb" has 2 instance (s).  Instance "RACDB1", status ready, have 1 handler (s) for the This service ... Instance "RACDB2", status ready, have 1 handler (s) for the This service ...  Service "RACDB_XPT" has 2 instance (s).  Instance "RACDB1", status ready, have 2 handler (s) for the This service ... Instance "RACDB2", status ready, have 1 handler (s) for the This service ...  Service "Service1" has 1 instance (s). Instance "RACDB1", status ready, have 2 handler (s) for the This service ...  The command completed successfully[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 10.2.0.5.0-production  On Tue 5 21:46:23 2014Copyright (c) 1982, Oracle. All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith the part Itioning, real application Clusters, OLAP, Data miningand Real application Testing optionssql> show parameter Servicena ME TYPE VALUE-----------------------------------------------------------------------------service_names string s Ervice1sql> col name for a20sql> Col failover_method for a20sql> Col failover_type for a20sql> Select Name,fa Ilover_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 appli  Cation Clusters, OLAP, Data miningand Real application testing options[[email protected] ~]$ srvctl config service-d Racdb-s Service1-aservice1 pref:racdb1 avail:racdb2 taf:basic[[email protected] ~]$ srvctl config service-d ra Cdbservice1 PREF:RACDB1 AVAIL:RACDB2

As can be seen from the above results, the configuration of the service through DBCA TAF, will be stored in OCR TAF configuration information (but Taf method), in the database parameter file will be added service entries, and in the data dictionary to add corresponding records, However, the TAF information in the data dictionary is empty and needs to be added separately. Such as

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 =  7  failover_delay 5   8  );  9  end;  /pl/sql procedure successfully completed. Sql> col name for a20sql> Col failover_method for a20sql> Col failover_type for a20sql> Select Name,failover_m Ethod,failover_type from Dba_services;name     failover_method  failover_type------------------------------ ------------------------------sys$backgroundsys$ USERSseeddataXDBseeddata.regress.rdbms.dev.us.oracle.comracdbXDBracdbservice1     BASIC  SELECT7 rows Selected.

Alternatively, you can use SRVCTL to join the service

[[email protected] ~]# srvctl add service-husage:srvctl Add service-d <name>-S <service_name>-R "&lt ;p referred_list> "[-A" <available_list> "] [-P <taf_policy>]-D <name> Unique name for th E database-s <service> Service name-r "<pref_list>" List of preferred instances-a "<a Vail_list> "List of available instances-p <TAF_policy> TAF policy (NONE, BASIC, or Preconnect) USAGE:SR    Vctl 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 Ad D 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[[email protected] ~]# 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/oracl e/product/11.2.0/db. [[email protected] ~]# su-oracle[[email protected] ~]$ srvctl add service-d racdb-s service2-r racdb1-a RA Cdb2-p basic[[email protected] ~]$ srvctl config service-d racdb-aservice1 pref:racdb1 avail:racdb2 TAF:BASICSE Rvice2 pref:racdb1 avail:racdb2 taf:basic[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 10.2.0.5.0-  Production on Tue 5 22:16:43 2014Copyright (c) 1982, Oracle. All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith the part Itioning, real application Clusters, OLAP, Data miningand Real application Testing optionssql> show parameter Servicena ME TYPE VALUE-----------------------------------------------------------------------------service_names string s Ervice1, racdbsql> select name from Dba_services; NAME----------------------------------------------------------------sys$backgroundsys$ USERSseeddataXDBseeddata.regress.rdbms.dev.us.oracle.comracdbXDBracdbservice17 rows selected.

from here. The ability to see that a service joined by SRVCT does not include the corresponding information in the database parameters and the data dictionary

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

10g RAC with service up to Taf