In the first of two tutorials on getting started with Shareplex 9.0 on Windows running on the AWS Cloud provider, "Getting Started with Shareplex on Windows on AWS, Part 1," we installed the pre-requisite software, and launched and connected with an EC2 instance running the Windows OS. In this continuation tutorial, we shall install Shareplex and start Shareplex service and test Shareplex by running some basic commands. This tutorial has the following sections:

  • Installing Shareplex
  • Starting the Shareplex Service
  • Using Shareplex Commands
  • Conclusion

Installing Shareplex

Download Shareplex 9.0 for Windows 2003, 2008, 2012, 2012R2 (Oracle 10gR2 to 12c and SQL Server 2008R2, 2012) application. A Shareplex 9.0 for Windows trial version also may be downloaded, as shown in Figure 1.

Downloading Application for Shareplex

Figure 1: Downloading Application for Shareplex

Double-click the sp_setup- application to install Shareplex 9.0 on Windows 2012, as shown in Figure 2.

Launching the Shareplex Application

Figure 2: Launching the Shareplex Application

Click Open File, Run. The Shareplex setup wizard gets launched, as shown in Figure 3. Click Next.

Shareplex Installation Wizard

Figure 3: Shareplex Installation Wizard

Select a Destination Folder to install Shareplex, as shown in Figure 4. The default directory is shown selected.

Selecting Destination Folder to install Shareplex

Figure 4: Selecting Destination Folder to install Shareplex

In Select Components, select Shareplex Full Installation Oracle 12c, as shown in Figure 5.

Selecting Components to install

Figure 5: Selecting Components to install

Next, select or specify the Shareplex port number/s. Select the default Shareplex port, 2100 (see Figure 6).

Selecting Shareplex Port

Figure 6: Selecting Shareplex Port

Shareplex makes use of a variable data directory to store its internal information. Select the default variable data directory, as shown in Figure 7, and click Next.

Selecting the Variable Data Directory

Figure 7: Selecting the Variable Data Directory

Next, select the Program Manager Group or keep the default setting and click Next, as shown in Figure 8.

Selecting the Program Manager Group

Figure 8: Selecting the Program Manager Group

Shareplex uses the PTC NuTCRACKER (MKS Toolkit) operating environment to run on Windows. Next, the PTC NuTCRACKER Platform Components 9.x get installed, as shown in Figure 9.

Installing PTC NuTCRACKER Platform Components 9.x

Figure 9: Installing PTC NuTCRACKER Platform Components 9.x

Other files and applications get copied, as shown in Figure 10.

Installation progress

Figure 10: Installation progress

After the installation completes, the Installation Complete dialog gets displayed (see Figure 11). The message dialog indicates that, before running Shareplex, the SpUtils utility should be used to install Shareplex as a service and the ora_setup application should be run to configure the Shareplex database account. Click Finish.

Installation Complete

Figure 11: Installation Complete

An Install dialog (shown in Figure 12) indicates that the Windows server would need to restart for the Shareplex installation to complete. Click OK.


Figure 12: Install

A dialog, "The disconnection was initiated by the user logging off his or her session on the server", may get displayed. Click OK. The Chrome RDP login screen gets displayed. Click Connect to log back in to Windows 2012, as shown in Figure 13.

Re-connecting to Windows 2012 Instance on EC2 with Chrome RDP

Figure 13: Re-connecting to Windows 2012 Instance on EC2 with Chrome RDP

The Shareplex gets installed on Windows 2012 and different Shareplex utilities should get added, as shown by the new icons in Figure 14. The SpUtils utility is used to start the Shareplex service, as we shall discuss subsequently. The Sp_Ctrl is the command line interface to run commands on Shareplex. And, the SpClient is a remote access utility for Shareplex.

Shareplex Installed

Figure 14: Shareplex Installed

Starting the Shareplex Service

Next, we shall start the Shareplex service so that the sp_ctrl and other Shareplex user interfaces, such as SpClient, are able to access Shareplex. Double-click the SpUtils icon, shown in Figure 14. First, we need to add the license key for Shareplex. A license key is sent to the e-mail registered when the Shareplex trail version or some other edition is downloaded. Select the License Key tab and click Add License, as shown in Figure 15.

SpUtils>License Key>Add License

Figure 15: SpUtils>License Key>Add License

In the Add Key dialog, specify the License Key and Customer Name, which are used to register to download Shareplex and also sent with the license key. Click OK (see Figure 16).

Adding License Key

Figure 16: Adding License Key

The license key information gets set, as shown in Figure 17.

License Key Information Set

Figure 17: License Key Information Set

Next, select the Shareplex Services tab and click Start to start the Shareplex service, as shown in Figure 18. The Shareplex service needs to be started only if the Current State is "Service Stopped".

Starting Shareplex Service

Figure 18: Starting Shareplex Service

The "Service Running" message, displayed in Figure, 19 indicates that the Shareplex service has been started.

Shareplex Service Running

Figure 19: Shareplex Service Running

The Information tab displays the Platform and Shareplex information, including the Shareplex Port, Version, Install Dir, and VarDir, as shown in Figure 20.

Platform and Shareplex Information

Figure 20: Platform and Shareplex Information

Using Shareplex Commands

Shareplex provides various command line interfaces in addition to the OS command prompt to run Shareplex commands. The Shareplex C:\Program Files\Quest Software\Shareplex\bin directory, in which the Shareplex applications are installed, gets added to the Windows PATH environment variable when Shareplex is installed and the Shareplex applications, such as ora_setup, may be run from any directory on the OS command prompt. The sp_ctrl Command Line Interface (CLI), also called the Shareplex for Oracle Command Utility, may be launched from the Windows icon (see Figure 21).

Launching the Sp_Ctrl Command Line Interface

Figure 21: Launching the Sp_Ctrl Command Line Interface

The sp_ctrl command line interface gets started, as shown in Figure 22.

Shareplex for Oracle Command Utility

Figure 22: Shareplex for Oracle Command Utility

The sp_ctrl commands may be run from the command line. As an example, the connection help command lists the usage for the connection command, as shown in Figure 23.

Running a Shareplex sp_ctrl Command

Figure 23: Running a Shareplex sp_ctrl Command

To run the Shareplex applications, such as ora_setup and pg_setup, search for "cmd" and launch an OS command prompt, as shown in Figure 24.

Launching an OS Command Prompt

Figure 24: Launching an OS Command Prompt

The OS command prompt gets displayed, as shown in Figure 25.

Windows 2012 OS Command Prompt

Figure 25: Windows 2012 OS Command Prompt

Run the Shareplex os_setup command as an example (see Figure 26).

Running a Shareplex OS Command

Figure 26: Running a Shareplex OS Command


In two tutorials, we discussed getting started with using Shareplex on Windows 2012 on AWS. We have only discussed getting started with Shareplex. Running a migration requires installing a source database and a target database. Shareplex is used for its near zero-downtime database replication and data integration from two of the leading databases, Oracle and SQL Server, its automation for continuous replication with no scheduling required, its data accuracy and integrity, and its support for several data sources (JMS, SQL, XML, Teradata, and Kafka) as targets from the source, such as as an Oracle database. If using databases on a Cloud platform with managed services, such as the Amazon Web Services (AWS), using Shareplex on a Cloud platform such as the AWS has the benefit of being able to integrate with the databases without requiring Shareplex connections from a local machine to databases on a Cloud platform.


Which topic are you interested in?





Data Storage



IT Management


What is your company size?

What is your job title?

What is your job function?

Searching our resource database to find your matches...