The first step in recovering from an external database failure is to perform a Modify settings upgrade on one of the nodes in your cluster. This upgrade effectively integrates the node with the mirror of your external system database. In addition, the settings you specify for this upgrade provide the default settings for the Express upgrades that must be performed on any additional nodes in the cluster.

Take the following steps to perform the Modify settings upgrade.

  1. From a command-line prompt, navigate to the directory where you saved the product file. Alternatively, place the product file directory on your path before proceeding to the next step.

    The product file has the format PROGRESS_DATADIRECT_HDP_SERVER_nn_LINUX_64_INSTALL.bin, where nn is the version of the product.

  2. Make the file an executable using the chmod +x command. For example:

    chmod +x ./PROGRESS_DATADIRECT_HDP_SERVER_nn_LINUX_64_INSTALL.bin

  3. Run the executable.
    • GUI mode

      ./PROGRESS_DATADIRECT_HDP_SERVER_nn_LINUX_64_INSTALL.bin

      Note: If the installer cannot continue with a GUI installation, a message is displayed and the installation continues in console mode
    • Console mode

      ./PROGRESS_DATADIRECT_HDP_SERVER_nn_LINUX_64_INSTALL.bin -i console

  4. When prompted, enter the directory of the installation you want to upgrade.
  5. When prompted, choose an upgrade installation on the existing installation.
  6. When prompted, choose a Modify settings upgrade.
    Important: A number of settings can be changed during a Modify settings upgrade. However, for system database recovery, only the settings related to the system database should be modified. All other settings must remain the same.
  7. Choose the type of external database you are using in your Hybrid Data Pipeline deployment.
    • Select Oracle, and continue at Step 8.
    • Select MySQLCommunity, and continue at Step 9.
    • Select MSSQLServer, and continue at Step 10.
    • Select PostgreSQL, and continue at Step 11.
  8. Provide the connection information for the mirror of your Oracle database.
    1. Type the name of the host.
    2. Type the port number.
    3. Select the connection type. Do one of the following:
      • If you connect using the Oracle System Identifier (SID), select Connect using SID and enter the SID.
      • Select Connect using Service Name, then type the database service name that specifies the database that is used for the connection. The service name is a string that is the global database name. The global database name typically comprises the database name and domain name.
    4. Optionally, when prompted for Advanced Options, specify additional connection parameters and their values to be included the connection url. Values should be entered as a semicolon-separated list of parameter=value. For example, you may enter to following options to configure SSL: 
      encryptionLevel=Required;encryptionTypes=(AES256);
dataIntegrityLevel=Required;dataIntegrityTypes=(SHA1);
encryptionMethod=SSL;keyStore=/common/Oracle/trustStore.jks;
keyStorePassword=secret;serverType=dedicated;authenticationMethod=ntlm;
hostNameInCertificate=oracle;editionName=hybrid
    5. Continue at Step 12.
  9. Provide connection information for the mirror of your MySQL Community Edition database.
    1. Type the name of the host.
    2. Type the port number.
    3. Type the database name.
    4. Optionally, when prompted for Advanced Options, specify additional connection parameters and their values to be included the connection url. Values should be entered as a ampersand-separated list of parameter=value.
    5. Continue at Step 12.
  10. Provide the connection information for the mirror of your SQL Server database.
    1. Type the name of the host.
    2. Type the port number.
    3. Type the database name.
    4. Type the name of the schema.
    5. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included in the connection URL. Values should be entered as a semicolon-separated list of parameter=value.
    6. Continue at Step 12.
  11. Provide the connection information for the mirror of your PostgreSQL database.
    1. Type the name of the host.
    2. Type the port number.
    3. Type the database name.
    4. Type the name of the schema.
    5. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included in the connection URL. Values should be entered as a semicolon-separated list of parameter=value.
    6. Continue at Step 12.
  12. Provide the external database credential information.
    Note: The credentials of the mirror database should be the same as those of the original database.
    • Provide the administrator user name. The administrator user must have certain privileges that are specific to the database vendor. For details, refer to External system databases in the Deployment Guide.
    • Provide the password for the external database administrator account.
    • Provide the standard user name. The standard user must have certain privileges that are specific to the database vendor. For details, refer to External system databases in the Deployment Guide.
    • Provide the password for the external database standard user account.
  13. Review port numbers and accept the previously specified values. Port numbers should be the same as those specified in the previous installation or upgrade.
  14. Review the upgrade summary, and proceed with the upgrade.

What to do next:

You must now perform an Express upgrade on each of the remaining nodes in the Hybrid Data Pipeline cluster. See Express upgrade system database recovery for step-by-step instructions.