Documentation 4.3

Release Information

Introduction

Getting Started

Delphix Engine System Administration

Virtual Database Management with the Delphix Engine

Delphix Modernization Engine

Delphix Compliance Engine

Virtualizing Unstructured Files in the Delphix Engine

Virtualizing Oracle E-Business Suite in the Delphix Engine

JetStream

Mission Control

Delphix Express User Guide

Reference

Documentation for Previous Versions of the Delphix Engine

Delphix Server 3.0 Documentation
Delphix Server 3.1 Documentation
Delphix Engine 3.2 Documentation
Delphix Engine 4.0 Documentation
Delphix Engine 4.1 Documentation
Delphix Engine 4.2 Documentation

Skip to end of metadata
Go to start of metadata

What is HostChecker?

The HostChecker is a standalone program which validates that host machines are configured correctly before the Delphix Engine uses them as data sources and provision targets.

Please note that HostChecker does not communicate changes made to hosts back to the Delphix Engine. If you reconfigure a host, you must refresh the host in the Delphix Engine in order for it to detect your changes.

You can run the tests contained in the HostChecker individually, or all at once. You must run these tests on both the source and target hosts to verify their configurations. As the tests run, you will either see validation messages that the test has completed successfully, or error messages directing you to make changes to the host configuration.

Prerequisites

Procedure to Validate Target Environments

  1. Download and install the Delphix Connector as described in Adding a SQL Server Standalone Target Environment.
  2. Login to the Windows target host using the Windows user account that will later be used to add the target.
  3. Open Windows Powershell using the Run as Administrator option.

  4. Execute the host checker script by running:

    <Delphix Connector installation folder>\etc\dlpx-host-checker.ps1
  5. Select a path where a report file will be saved, such as C:\temp\delphix-host-checker-report.txt.
  6. Select the default option of Target Host.
  7. Read the output of the checks. 
  8. The error or warning messages will explain any possible problems and how to address them. Resolve the issues that the HostChecker describes. Do not be surprised or undo your work if more errors appear the next time you run HostChecker; the error you just fixed may have been masking other problems.
  9. Repeat steps 4–7 until all the checks return no errors or warnings.

Procedure to Validate Source Environments

  1. Select the Windows target host which will be used as a proxy for discovering the source environment as described in Setting Up SQL Server Environments: An Overview.
  2. Login to the Windows target host using the Windows user account that will later be used to add the source environment.
  3. Open Windows Powershell using the Run as Administrator option.

  4. Execute the host checker script by running:

    <Delphix Connector installation folder>\etc\dlpx-host-checker.ps1
  5. Select a path where a report file will be saved, such as C:\temp\delphix-host-checker-report.txt.
  6. Select the Source Host option.
  7. Specify the host name or IP address of the source environment to verify.
  8. Select ALL to discover all databases, or specify a single database to verify.
  9. Specify the SQL Server database login and password that will later be used to add the source environment.
  10. Read the output of the checks. 
  11. The error or warning messages will explain any possible problems and how to address them. Resolve the issues that the HostChecker describes. Do not be surprised or undo your work if more errors appear the next time you run HostChecker; the error you just fixed may have been masking other problems.
  12. Repeat steps 4–9 until all the checks return no errors or warnings.

Tests Run

Test
MS SQL Server Source
MS SQL Server Target
Description
Check Powershell VersionXX

Verifies that Powershell 2.0 or greater is installed

Check OS User PrivilegesXXFor target hosts, verifies that the the operating system (OS) user has administrative rights. For source hosts, verifies that the OS user can successfully perform remote registry access from the target host to the source host.
Check host settingsXXVerifies that the Delphix Engine can discover host environment details from the Windows registry
Check SQL Server instance discoveryXXVerifies that the Delphix Engine can discover SQL Server instances
Check SQL Server instance login permissionXX

For target hosts, verifies that the Windows OS user can be used to log in to the SQL Server instances. For source hosts, verifies that the supplied SQL Server login credentials can be used to log in to the SQL Server instances.

Check database discoveryXXVerifies that the Delphix Engine can discover SQL Server databases

Additional options

Run the following to view additional host checker options:

dlpx-host-checker.ps1 -?