Chat now with support
Chat with Support

SharePlex 10.2 - Administration Guide

About this Guide Conventions used in this guide Revision History Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl Set SharePlex parameters Configure data replication Configure replication to and from a container database Configure named queues Configure partitioned replication Configure replication to a change history target Configure a replication strategy Configure DDL replication Configure error handling Configure data transformation Configure security features Start replication on your production systems Monitor SharePlex Prevent and solve replication problems Repair out-of-sync data Tune the Capture process Tune the Post process Recover replication after Oracle failover Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Troubleshooting Tips Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

Execute commands in sp_ctrl

This chapter contains instructions for using the sp_ctrl command interface to execute commands that configure, control, and monitor SharePlex. The sp_ctrl program resides in the bin sub-directory of the SharePlex product directory.

Note: See the SharePlex Reference Guide for more information about the commands shown in this topic.


How to run sp_ctrl

You can run sp_ctrl on any machine where SharePlex is installed. The sp_cop program must be running in order to run sp_ctrl; otherwise it displays an error message similar to this:

Your tcp port is not set properly or “sp_cop” is not running.

Start sp_ctrl

There are two ways to run sp_ctrl:

  • from the command shell of the operating system to issue one command, for example:

    $ /productdir/bin/sp_ctrl command [on host]

  • by running the sp_ctrl command interface to issue one or more commands, for example:

    $ /productdir/bin/sp_ctrl

    sp_ctrl>command [on host]


  • productdir is the SharePlex product (installation) directory.
  • command is the SharePlex command.
  • on host represents one of the command options that allow you to issue a command on the local machine to control SharePlex on a remote machine (if supported by the command), as shown in the following example.

$ /productdir/bin/sp_ctrlstatus on host:port

On Windows systems, you can run sp_ctrl from the Sp_Ctrl desktop shortcut or Windows Programs menu.

The sp_ctrl command line allows a total of 256 characters, including spaces.

sp_ctrl prompt

The sp_ctrl prompt appears in one of two ways, depending on whether or not you set a default host and port number.

Prompt Description
sp_ctrl> Basic sp_ctrl prompt
sp_ctrl(this_host:3304) > Prompt when a default system and port are set by issuing the host and port commands

Exit sp_ctrl

To exit the sp_ctrl command-line interface, issue the exit or quit command.

On Windows systems, you can simply close the sp_ctrl command prompt window.

The exit or quit command only closes the sp_ctrl session. It does not stop the SharePlex replication processes.

Define a default port for sp_ctrl

If there is only one instance of SharePlex on a system, sp_ctrl detects the port number. However, if you configured more than one SharePlex instance on a system (where each one runs on a different port number) you must use the port command to set the session of sp_ctrl to the instance for which you want to issue commands.

sp_ctrl > port number

For more information, see Run multiple instances of SharePlex.

For more information about the port command, see the SharePlexReference Guide.

Define a default host for sp_ctrl

To define a default machine for all interactive sp_ctrl sessions, use the host command. This command enables you to enter a series of commands without using the onhost option for each one.

sp_ctr >host hostname

The command changes the sp_ctrl prompt to include the host name:

sp_ctrl (sysA) >

The host setting applies only to the sp_ctrl session in which it is set.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating