Oracle RAC Support

Oracle RAC is a way to enhance Oracle database availability and scalability, allowing it to interact with more than one database instance.

OpenText Application Quality Management RAC support includes:

  • Load balancing between Oracle instances.
  • Failover between all specified Oracle RAC nodes at initial connection.

OpenText Application Quality Management RAC support does not include:

  • TAF (Transparent Application Failover) support. A user failing to complete a request upon an Oracle instance crash is required to perform the activity again with a working Oracle instance.

To enable Oracle RAC support:

  1. Verify that a file containing information of Oracle database addresses is saved on your ALM machine. The file is named tnsnames.ora. The file should contain information similar to the following examples:

    1. This first example shows an RAC TNS Alias using all cluster nodes in the ADDRESS sub-section and a sample of utilizing the Load balance and Failover features:

      Example: 
OrgRAC =
(DESCRIPTION =
	(ADDRESS_LIST=
		(FAILOVER = on)
		(LOAD_BALANCE = on)
		(ADDRESS= (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
		(ADDRESS= (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
		(ADDRESS= (PROTOCOL = TCP)(HOST = server3)(PORT = 1521))
	)
	(CONNECT_DATA=
	(SERVICE_NAME = myrac.yourcompany.com)
	)
)

    2. This second example shows an RAC TNS Alias using Single Client Access Name (SCAN). This enables Oracle 11gR2 clients to connect to the database with the ability to resolve multiple IP addresses, reflect multiple listeners in the cluster and handle public client connections. For details on working with RAC SCAN, refer to the Oracle documentation.

      Example: 
OrgRAC_Scan =
(DESCRIPTION =
	(ADDRESS_LIST=
		(FAILOVER = on)
		(LOAD_BALANCE = on)
		(ADDRESS= (PROTOCOL = TCP)(HOST = myrac-cluster-scan)(PORT = 1521))
	(CONNECT_DATA=
	(SERVICE_NAME = myrac.yourcompany.com)
	)
)

  2. Verify that you have the address of the TNS server to which OpenText Application Quality Management should refer, for example, OrgRAC.