Grouper Users - Open Discussion List

[Gagné Sébastien <>]

Thanks a lot, we’ll give it a try !

With SCAN I think that server1 and server2 would need to be the same host.

 

 

De : Nathan Kopp [mailto:]
Envoyé : 26 avril 2012 10:25
À : Gagné Sébastien;
Objet : RE: Database high availability with Oracle RAC and SCAN

 

I’m not familiar with using SCAN with RAC, but we use Oracle RAC with Grouper and it seems to work properly.  We specify multiple servers in one database connection string, and let the Oracle JDBC client handle the load balancing and failover.

 

jdbc:oracle:thin:@(DESCRIPTION=\

    (ADDRESS_LIST=\

      (FAILOVER=on)\

      (LOAD_BALANCE=yes)\

      (ADDRESS=\

        (PROTOCOL=TCP)\

        (HOST=server1)\

        (PORT=1521)\

      )\

      (ADDRESS=\

        (PROTOCOL=TCP)\

        (HOST=server2)\

        (PORT=1521)\

      )\

    )\

    (CONNECT_DATA=\

      (FAILOVER_MODE=\

        (TYPE=select)\

        (METHOD=basic)\

        (RETRIES=20)\

        (DELAY=1)\

      )\

      (SERVER=dedicated)\

      (SERVICE_NAME=servicename)\

    )\

)

 

See this for more information:

http://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm

 

-Nathan

 

From: On Behalf Of Gagné Sébastien
Sent: Thursday, April 26, 2012 9:17 AM
To:
Subject: [grouper-users] Database high availability with Oracle RAC and SCAN

 

Hello,

We are deploying Grouper in an high availability environment using an Oracle database and we would like to confirm Grouper’s behaviour regarding databases.

 

We have 2 database servers using RAC mode (real application cluster) behind a SCAN address. Basically applications configures their DB URL using the single URL (see grouper config example below) and the SCAN+driver takes cares of getting the IP address of an available server (usually based on load or other configuration). I successfully used Grouper with the RAC+SCAN database architecture, but we were wondering if it will react properly if/when one of the servers becomes unresponsive.

 

We would like to know how Grouper reacts regarding database failures.

Will Grouper automatically retry failed commands ? If I does, the SCAN will give the IP of the other available server.

Will grouper report an error and stop working ? Then high availability of the database is non-existent.

 

Grouper connect string example :

jdbc:oracle:thin:@//db-alias.umontreal.ca:1521/SERVICENAME.UMONTREAL.CA

 

In comparison, when installing Oracle products we are using a connect URL like :

db-alias.umontreal.ca:1521^db-alias.umontreal.ca:

 

This format enables RAC mode, meaning the product will try the second URL if the first one fails. Since SCAN is a single URL we have it 2 times to force the application to retry the same connection, but this time the SCAN will give another IP for the database server.

 

Thank you

 

 

Sébastien Gagné,     | Analyste en informatique

514-343-6111 x33844  | Université de Montréal,

                     | Pavillon Roger-Gaudry, local X-100-11