Step 1 Dbvisit Standby Installation

RAC environment

In an Oracle RAC environment, Dbvisit Standby must be installed and configured as below on each primary node in the RAC cluster.

Primary Server (or primary node)

1. On the primary server (or primary RAC node), double click on the Dbvisit Standby installation executable. Click on Run.

2. Click on Next.

image2012-1-23 15:30:24.png

3. Accept the license terms.

worddavee08f44281df977714d15826bed04131.png [imported from a Word document]

4. Please ensure that the windows account that is used to install Dbvisit Standby is the same account that installed the Oracle software.

worddavec95764a9a0ccd3cfef9160ca12cad0c.png [imported from a Word document]

5. The components to install can be chosen. By default all components should be chosen. Dbvisit Standby is bundled with Bitvise WinSSHD and Bitvise Tunnelier software to securely transfer the database updates to the standby server. If an alternative SSH (secure shell) method is already installed, then this can be used.

image2012-1-23 15:31:42.png

6. Choose the install location for Dbvisit Standby.

worddav363cfbce64fe74ddbbf3e916612d66a5.png [imported from a Word document]

7. Choose the install location for Bitvise WinSSHD (www.bitvise.com). This is the SSH service that accepts secure transfers.

worddav87ee76ccf3b5ed803597a93ec329e547.png [imported from a Word document]

8. Choose the install location for Bitvise Tunnelier (www.bitvise.com). This is the secure SSH client that transfers the updates.

worddav9d5806460f0b94bcb698f084f970bc45.png [imported from a Word document]

9. Please specify if this is the primary server. Answer Yes.

image2012-1-23 15:32:34.png

10. The Dbvisit software will be installed.

worddav6962e382a3fbc095a69c11c5ebc7b13b.png [imported from a Word document]

11. The Dbvserver Windows service will be created. The current Windows account password is needed to start the service. Please enter the password when requested.

worddavb883e921ae45c1ccffe33bcf6dde9fa5.png [imported from a Word document]

12. The Dbvserver service has been created.

worddav5bd5f9acb98ae15c6f7f9c50ad86962b.png [imported from a Word document]

Setting up SSH connection between primary and standby servers

Dbvisit Standby uses an ssh connection between the primary and standby servers to manage the standby database. Bitvise software is used to configure and setup the ssh connection.

Bitvise WinSSHD Setup

13. Bitvise WinSSHD will now be installed in the background.

worddav33aa51cd85afa638057661c1749f9904.png [imported from a Word document]

14. On completion a message will be displayed.

worddavb1e665cc624c940622b5bae758e5d967.png [imported from a Word document]

15. The WinSSHD service will be started.

worddav9148bd30277704c29a98dc123814a751.png [imported from a Word document]

Bitvise Tunnelier Setup

16. Bitvise Tunnelier will now be installed in the background.

worddavea9f26171a44b64de83fdfb3d7d9149f.png [imported from a Word document]

17. On completion a message will be displayed.

worddav7b016c66592d928fa89564454df43d5f.png [imported from a Word document]

SSH2 Setup

18. SSH2 (secure shell) will now be configured. Several background processes will start. The processes will generate unique SSH private and public encryption keys. These keys will be loaded into WinSSHD.

worddavcead08fc75b35526086bc80e204e925d.png [imported from a Word document]

19. WinSSHD will need to cache the windows password of the current user. Note this is the password of the current user on the current server (not the password of the standby server).

worddavddfd2135afb0adfa356fa5c42f470ec0.png [imported from a Word document]

20. To complete the SSH configuration, three of the generated encryption keys have to be copied over to the standby server. A readme file will be displayed that describes what needs to be done next.

worddavea1e96b6b73e23efb99196ab43b9c9ef.png [imported from a Word document]

21. Initiate the Dbvisit Standby install on the standby server (see below):

Standby Server

22. Go to the standby server and double click on the Dbvisit Standby installation executable.

image2012-1-23 15:35:30.png

23. Accept the license terms.

worddav3a73ae9eadc5bdfdf7101f78459b6077.png [imported from a Word document]

24. Please ensure that the windows account that is used to install Dbvisit Standby is the same account that installed the Oracle software (it also must be the same account as used on the primary server).

worddavec95764a9a0ccd3cfef9160ca12cad0c.png [imported from a Word document]

25. The components to install can be chosen. By default all components should be chosen. Dbvisit Standby is bundled with Bitvise WinSSHD and Bitvise Tunnelier software to securely transfer the database updates to the standby server. If an alternative SSH (secure shell) method is already installed, then this can be used.

worddav8b755435209b13b0756b30be251201bc.png [imported from a Word document]

26. Choose the install location for Dbvisit Standby.

worddav363cfbce64fe74ddbbf3e916612d66a5.png [imported from a Word document]

27. Choose the install location for Bitvise WinSSHD (www.bitvise.com). This is the SSH service that accepts secure transfers.

worddavba76ee09b4197c1984ec9431b9da0bf8.png [imported from a Word document]

28. Choose the install location for Bitvise Tunnelier (www.bitvise.com). This is the secure SSH client that transfers the updates.

worddav9d5806460f0b94bcb698f084f970bc45.png [imported from a Word document]

29. Please specify if this is the primary server. Answer No.

image2012-1-23 15:37:13.png

30. The Dbvisit software will be installed.

worddav6962e382a3fbc095a69c11c5ebc7b13b.png [imported from a Word document]

31. The Dbvserver Windows service will be created. The current Windows account password is needed to start the service. Please enter the password when requested.

worddavb883e921ae45c1ccffe33bcf6dde9fa5.png [imported from a Word document]

32. The Dbvserver service has been created.

worddav5bd5f9acb98ae15c6f7f9c50ad86962b.png [imported from a Word document]

Setting up SSH connection between standby and primary servers

Dbvisit Standby uses an ssh connection between the standby and primary servers to manage the standby database. Bitvise software is used to configure and setup the ssh connection.

Bitvise WinSSHD Setup

33. Bitvise WinSSHD will now be installed in the background.

worddav33aa51cd85afa638057661c1749f9904.png [imported from a Word document]

34. On completion a message will be displayed.

worddavb1e665cc624c940622b5bae758e5d967.png [imported from a Word document]

35. The WinSSHD service will be started.

worddav9148bd30277704c29a98dc123814a751.png [imported from a Word document]

Bitvise Tunnelier Setup

36. Bitvise Tunnelier will now be installed in the background.

worddavea9f26171a44b64de83fdfb3d7d9149f.png [imported from a Word document]

37. On completion a message will be displayed.

worddav7b016c66592d928fa89564454df43d5f.png [imported from a Word document]

SSH2 Setup

38. SSH2 (secure shell) will now be configured. Several background processes will start. The processes will generate unique SSH private and public encryption keys. These keys will be loaded into WinSSHD.

worddavcead08fc75b35526086bc80e204e925d.png [imported from a Word document]

39. Now please copy over the SSH encryption keys specified in the README file displayed during the primary setup. Once the files are copied, click OK.

worddav4229499aac3a60f5fc15adbbed25b572.png [imported from a Word document]

40. The configuration of SSH will continue. Click OK.

worddavd2d1fa540bbec533495eb7e03ee24f26.png [imported from a Word document]

41. WinSSHD will need to cache the windows password of the current user. Note this is the password of the current user on the current server (not the password of the primary server).

worddavddfd2135afb0adfa356fa5c42f470ec0.png [imported from a Word document]

42. WinSSHD configuration is completed. If a firewall is used, please ensure port 22 is open on the firewall. Please also ensure that the SSH2 directory under the Dbvisit Standby directory is secured by only allowing administrators access to this directory.

worddav60e21edf61da1f8007029a40b86c69ea.png [imported from a Word document]

43. The System Readiness check will be performed which test the connection between the standby and the primary server.

worddav74b2876ed2923eece9818650bee8756e.png [imported from a Word document]

44. Enter the details to connect to the primary server to complete the test.

worddav71edeb4f488ea7469ce548202dcc00d4.png [imported from a Word document]

45. Ensure the network connection is correct.

worddav146c237452f5735b7f3f3b5969944ec3.png [imported from a Word document]

46. Dbvisit Standby installation on the standby server is completed.

worddav50e58f7f429dd3d00c5ebcfe8d93ef74.png [imported from a Word document]

47. Continue the installation on the primary server (see below):

Continued installation on the primary server

48. Once the installation on the standby server is complete, the installation on the primary server can be completed.

worddav60e21edf61da1f8007029a40b86c69ea.png [imported from a Word document]

49. The System Readiness check will be performed which test the connection between the primary and the standby server.

worddav4103f9d19c4ad6ed3fa40effb1b609a3.png [imported from a Word document]

50. Enter the details to connect to the standy server to complete the test.

worddav8ee260b5fbd6ad3ec7e45bb18e8fec6c.png [imported from a Word document]

51. Ensure the network connection is correct.

worddav146c237452f5735b7f3f3b5969944ec3.png [imported from a Word document]

52.Dbvisit Standby is now installed and must be configured for a specific database.

53. Dbvisit Standby can be configured and run through a command line interface (CLI) or a web-based interface (GUI). Throughout this user manual the CLI commands will be indicated with a and the web based or GUI commands will be indicated with a

worddav5fb32de1a06697f6aaf2c76a8c8ceb1d.png [imported from a Word document]

54. Click Yes to configure this now through a browser. Click No, to configure Dbvisit Standby through the command line interface (CLI).

worddav0ee6d3f67943b3f08f7b46ee7a976ca0.png [imported from a Word document]

55. Please see the Configure Dbvisit Standby (step 2) - Windows section on how to configure Dbvisit Standby for a specific database.

56. To setup Dbvisit Standby through the command line (CLI) interface click Yes

worddavd366239d97de8deddb21d2587ad09c5e.png [imported from a Word document]
The Dbvisit Standby setup utility will be started. This is to configure Dbvisit Standby for a specific database. Choose option 1 (or 1a for RAC) from the main menu for a new Dbvisit Standby setup. Please see the Configure Dbvisit Standby (step 2) - Windows section on how to configure Dbvisit Standby for a specific database.
worddav6943d40d060392d12d879017bcbfe652.png [imported from a Word document]

57. Dbvisit Standby has been installed on the primary server. Please click OK to exit.

worddav46eb7e54827fa6c0934b0213ff0c1b88.png [imported from a Word document]
The Dbvisit Standby software and secure shell have been installed. The standby database can now be created and then Dbvisit Standby can be setup and configured for the primary and standby database.

Windows Shortcuts for command line interface (CLI)

Shortcuts will have been created for Dbvisit Standby under Programs > Dbvisit > Standby.
The shortcuts are:
worddav81e1f06b25f441368238fa0f185b0aeb.png [imported from a Word document]
The Dbvisit Standby command console is the main utility to execute Dbvisit Standby commands for CLI.
Shortcuts have also been created for Bitvise Tunnelier and Bitvise WinSSHD. For more information about Bitvise WinSSHD and Tunnelier please visit http://www.bitvise.com