Supporting Failover in Oracle RAC

To support failover in Oracle RAC, you must change the database connection string in the credential store from a physical database node to a service representing multiple physical database nodes.

See Also:

"Introduction to Automatic Workload Management" in the Oracle Real Application Clusters Administration and Deployment Guide

To change the database connection string in the Credential Storage Framework: 

1. Open a connection to the computer where Oracle Fusion Middleware is installed.

2. Go to MW_HOME/oracle_common/common/bin.

3. Start the WebLogic Server Administration Scripting Shell.

   • For Linux and UNIX platforms, enter wlst.sh.

   • For Windows, enter wlst.cmd.

4. Enter this command at the wls/offline> prompt:

   connect ()
   

5. Enter your WebLogic user name in response to the user-name prompt.

6. Enter your WebLogic password in response to the password prompt.

7. Enter the WebLogic server URL in response to the server URL prompt. For example, t3://localhost:7234.

8. Enter this command in response to the wls:domain_name/serverConfig> prompt:

   updateCred("oracle.search","search_database",connect_string,"search")
   

   Where connect_string is the new database connection string, which uses the easy connect naming method in this format:

   jdbc:oracle:thin@hostname:port:sid
   

   For example:

   updateCred("oracle.search","search_database","jdbc:oracle:thin:@example.us.oracle.com:7890:fusion", "search")
   

See Also:

Oracle Fusion Middleware WebLogic Scripting Tool Command Reference