2.4 Deploying True Cache for an Oracle RAC Primary Database

This section summarizes the configuration requirements for deploying True Cache for a primary database in an Oracle Real Application Clusters (Oracle RAC) environment. These requirements are also included in context within the detailed configuration steps.

Note:

All of this information also appears in the context of the configuration steps for Configuring True Cache with Oracle DBCA and Configuring True Cache Manually.

• True Cache needs to be able to access each instance in the Oracle RAC environment. To do this, use the single client access name (SCAN) listener when configuring True Cache.

  • If you're configuring True Cache with DBCA, set the -sourceDBConnectionString parameter to SCAN:port/service_name.

  • If you're manually configuring True Cache, use the following settings when preparing the PFILE for True Cache:

    • Set the REMOTE_LISTENER parameter to SCAN:port.
    • Set the FAL_SERVER parameter to SCAN:port/service_name.

  • Add the True Cache node to the invited node list for the SCAN listener by using the srvctl command line utility. (Don't manually edit the listener.ora file as the grid owner user.)

    For example:

    srvctl modify scan_listener -invitednodes true_cache_host -endpoints TCP:port

• When creating the database application services on the primary database, use the srvctl command line utility with the -true_cache_service option. Start the service on the primary instance.

  srvctl add service -db primary_db_unique_name -service primary_db_service_name -preferred primary_db_instance_list -pdb primary_pdb_name -true_cache_service true_cache_service_name

  For example:

  srvctl add service -db primdb1i -service sales -preferred primdb1i1,primdb1i2 -pdb sales_pdb -true_cache_service sales_tc