Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle RAC failover does not happen

Praveen Bezawada
Respected Contributor

Oracle RAC failover does not happen

Hi
We have an application in Java which also has a C component. Both the components (Java based and C based) connect to a 2 node DBU cluster. Our tnsnames.ora consists of two services configured for one node each and the second node configured as backup. See the attachement.
With this configuration we see that when one of the oracle node is stopped the failover happens correctly for Java component but it does not happen for the C component.
We contaced Oracle who came back that it looks like a driver problem and oracle does not provide the drivers for Unix platform which we have to get from the platform vendor.
We suspect that we might be using some wrong version of the ODBC drivers which do not support TAF(Transparent application failover). Can you guys provide some information on how to check what prevents C code to failover. Any ideas and suggestions are most welcome.
BPK Hi
We have an application in Java which also has a C component. Both the components (Java based and C based) connect to a 2 node Oracle cluster. Our tnsnames.ora consists of two services configured for one node each and the second node configured as backup. See the attachement.
With this configuration we see that when one of the oracle node is stopped the failover happens correctly for Java component but it does not happen for the C component.
We are using DL 380 running Redhat Advanced server2.1 as oracle cluster nodes and Hp rp5470 with HPUX11i running the application.
We contaced Oracle who came back that it looks like a driver problem and oracle does not provide the drivers for Unix platform which we have to get from the platform vendor.
We suspect that we might be using some wrong version of the ODBC drivers which do not support TAF(Transparent application failover). Can you guys provide some information on how to check what prevents C code to failover. Any ideas and suggestions are most welcome.
BPK
1 REPLY
Brian Crabtree
Honored Contributor

Re: Oracle RAC failover does not happen

Try this:
NODE.TEST =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE=ON)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Y.Y.Y.Y)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = shared)
(SERVICE_NAME = ssp)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic)
)
)
)

The rest of it looks good, just the FAILOVER=ON is needed, and I think the LOAD_BALANCE was in the wrong place. Thanks. Brian