Home » Server Options » RAC & Failsafe » behavior in RAC failover
behavior in RAC failover [message #137585] Thu, 15 September 2005 10:51
ashishsinghal77
Messages: 9
Registered: August 2005
Junior Member
hi i am using the RAC failover, i have 2 nodes emp1 and emp2

the connect time failover behaviour is working fine when i give this entry in tnsnames.ora file..

emp =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=Off)
(FAILOVER=ON)
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp1) (PORT = 1512))
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp2) (PORT = 1511))
)
(CONNECT_DATA =
(SERVICE_NAME = emp)
(failover_mode = (backup = emp.world) (type = session) (method = preconnect))

)
(RETRIES=20)(DELAY=15)

)

emp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=Off)
(FAILOVER=ON)
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp1) (PORT = 1512))
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp2) (PORT = 1511))
)
(CONNECT_DATA =
(SERVICE_NAME = emp)
(failover_mode = (backup = emp) (type = session) (method = preconnect))

)
(RETRIES=20)(DELAY=15)

)

but if i add the instance_name entry in this tnsnames .ora then the connect time failover don't work.. can somebody please explain me why oracle is perform this behaviour..

the new file is looks like this

emp =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=Off)
(FAILOVER=ON)
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp1) (PORT = 1512))
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp2) (PORT = 1511))
)
(CONNECT_DATA =
(SERVICE_NAME = emp)
(instance_name = emp1)
(failover_mode = (backup = emp.world) (type = session) (method = preconnect))

)
(RETRIES=20)(DELAY=15)

)

emp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=Off)
(FAILOVER=ON)
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp1) (PORT = 1512))
(ADDRESS = (COMMUNITY = SPEC_NET) (PROTOCOL = TCP) (HOST = emp2) (PORT = 1511))
)
(CONNECT_DATA =
(SERVICE_NAME = emp)
(instance_name = emp2)
(failover_mode = (backup = emp) (type = session) (method = preconnect))

)
(RETRIES=20)(DELAY=15)

)


Ashish
Previous Topic: parameter max_commit_propogation_delay in RAC env.
Next Topic: is it possible to implement connection failover and TAF both in RAC
Goto Forum:
  


Current Time: Thu Mar 28 03:46:40 CDT 2024