Versions Compared

Old Version 7

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version 8

changes.mady.by.user Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • On the primary server, sftpc.exe (Tunnelier) is called as the client which connects to WinSSHD on the standby server. WinSSHD on the standby server will be running as a Windows service.

...

  • On the standby server, sftpc.exe (Tunnelier) is called as the client which connects to WinSSHD on the primary server. WinSSHD on the primary server will be running as a Windows service.
To setup the connection between Tunnelier and WinSSHD a combination of public and private keys are used. The keys need to match with the key (X_WinSSHDKeypair) that is loaded into WinSSHD. The Windows account username and password also needs to be loaded into WinSSHD so that when sftpc.exe connects it can execute the actual copy command on the target server.

The copy command that Dbvisit Standby uses from the primary to the standby server (ServerB) has the following format:

...

Rerun the Dbvisit Standby installer and only choose the "Configure SSH2" component.

1. On the primary server.

2. . This sets up and loads the public and private key combination.

There are two option to configure and setup SSH2 again:

  1. Through the Dbvisit Standby Installer.
  2. Manually running a Dbvisit Standby command.

Both options produce the same end result. They configure the ssh connection between the primary and standby database by reloading the SSH keys and loading the password into the WinSSHD cache. 

Setup SSH using the Dbvisit Standby Installer:

1. On the Primary Server, Double click on the Dbvisit Standby Installer and choose component "Configure SSH2" and "System Readiness Check". The "System Readiness Check" will test if the ssh has been correctly configured and will make a connection to the standby server.

...

6. Run Dbvisit Standby again on the primary server to test if the issue has been resolved.

Setup SSH using a Dbvisit Standby command:

The SSH setup can also be done manually by running a Dbvisit Standby command.

1. On the primary server, start the Dbvisit Standby command console and type:

        dbv_functions -Y primary setupssh

Follow the instructions.

2. On the standby server, start the Dbvisit Standby command console and type: 

        dbv_functions -Y standby setupssh

Follow the instructions.

Resolution 4 – Ensure Windows accounts are similar.

...