Oracle 11g rac taf server configuration failover

Source: Internet
Author: User
Tags failover taf

Oracle 11g introduces scan ip. However, in the absence of DNS, the client connection to RAC is still using oracle 10 Gb. Configure failover in tnsname. ora of the client.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.3.203) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.3.204) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.3.205) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(FAILOVER = on)
(TYPE = select)
(METHOD = basic)
(RETRIES = 180)
(DELAY = 5)

)
)
In this way, the client's failover can be implemented on the server, and the client only configures the scan ip address. I did a test today and the test result is OK. Let's talk about the configuration process:

How To Configure Server Side TransparentApplication Failover [ID 460982.1]
1. Create TAFService
[Oracle @ db1 bin] $./srvctl add service-d orcl-s server_taf-r "orcl1, orcl2"-P BASIC
-- Here, orcl is the database name, And orcl1 and orcl2 are instance names.
2. Start the server_taf Service
[Oracle @ db1 bin] $./srvctl start service-d orcl-s server_taf
3. Check service running status
[Oracle @ db1 bin] $./srvctl config service-d orcl
Service name: server_taf
Service is enabled
Server pool: orcl_server_taf
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
Aq ha specifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: orcl1, orcl2
Available instances:
4. Confirm serviceID
SQL> select name, service_id from dba_services where name = 'server _ taf ';
NAME SERVICE_ID
--------------------------------------------------------------------------
Server_taf 3
5. Add parameters to the service:
SQL> execute dbms_service.modify_service (service_name => 'server _ taf '-
, Aq_ha_configurications => true-
, Failover_method => dbms_service.failover_method_basic-
, Failover_type => dbms_service.failover_type_select-
, Failover_retries = & gt; 180-
, Failover_delay => 5-
, Clb_goal => dbms_service.clb_goal_long );
6. Confirm parameter modification:
Col name format a15
Col failover_method format a11 heading 'method'
Col failover_type format a10 heading 'type'
Col failover_retries format 9999999 heading 'retries'
Col goal format a10
Col clb_goal format a8
Col aq_ha_ications ications format a5 heading 'aqnot'
SQL> select name, failover_method, failover_type, failover_retries, goal, clb_goal, aq_ha_ications ications from dba_services where service_id = 3;
Name method type retries goal CLB_GOAL AQNOT
-------------------------------------------------------------------
Server_taf basic select 180 NONE LONG YES
SQL>
7. Check service registration:
[Oracle @ db1 bin] $ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 15-JUL-2012 13:26:43
Copyright (c) 1991,201 1, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = db1) (PORT = 1521 )))
Services Summary...
Service "+ ASM" has 1 instance (s ).
Instance "+ ASM1", status READY, has 1 handler (s) for thisservice...
Handler (s ):
"DEDICATED" established: 57 refused: 0 state: ready
LOCAL SERVER
Service "orcl" has 1 instance (s ).
Instance "orcl1", status READY, has 1 handler (s) for thisservice...
Handler (s ):
"DEDICATED" established: 11 refused: 0 state: ready
LOCAL SERVER
Service "orclXDB" has 1 instance (s ).
Instance "orcl1", status READY, has 1 handler (s) for thisservice...
Handler (s ):
"D000" established: 0 refused: 0 current: 0 max: 1022 state: ready
DISPATCHER
(ADDRESS = (PROTOCOL = tcp) (HOST = db1.tianlesoftware.com) (PORT = 38731 ))
Service "server_taf" has 1 instance (s ).
Instance "orcl1", status READY, has 1 handler (s) for thisservice...
Handler (s ):
"DEDICATED" established: 11 refused: 0 state: ready
LOCAL SERVER
The command completed successfully

Recommended reading:

RedHat Linux 5 & CentOS 5

Install Oracle 10g R2 in CentOS 6.3 (x32)

Installing Oracle 12C in Linux-6-64

  • 1
  • 2
  • Next Page

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.