Chat now with support
Chat with Support

SharePlex 8.6.6 - Installation Guide

About this Guide Conventions used in this guide Introduction to SharePlex SharePlex pre-installation checklist Set up SharePlex in an Oracle cluster Set up SharePlex on Amazon Cloud Download SharePlex UNIX Installation and Setup Windows Installation and Setup Assign SharePlex users to security groups Basic SharePlex demonstrations Advanced SharePlex Demonstrations Solve Installation Problems Uninstall SharePlex SharePlex Utilities Appendix A: Advanced installer options Appendix B: Install SharePlex as root Appendix C: SharePlex installed items

About this Guide

About this Guide

This manual provides instructions for installing SharePlex and performing initial setup. It also contains some demonstration tutorials that show how certain features of SharePlex work.

Other SharePlex documentation

For the complete SharePlex documentation set, go to:

http://documents.quest.com

  • See the SharePlex Administrator Guide for instructions for:

    • Operating SharePlex
    • Planning your replication strategy
    • Preparing the environment for replication
    • Configuring replication
    • Starting replication
    • Monitoring, tuning, and troubleshooting replication
    • Failover/failback in a high-availability environment
    • Performing administrative operations on replication systems
  • See the SharePlex Reference Guide for reference information that you will need from time to time. It includes detailed information about:

    • sp_ctrl commands that administer, monitor and control replication
    • SharePlex tuning parameters
    • SharePlex utilities
    • SharePlex error messages
  • See the SharePlex Preinstallation Checklist for tasks that must be finished before installing or running SharePlex.
  • See the SharePlex Upgrade Guide for instructions for upgrading a current installation of SharePlex to this version.
  • See the SharePlex Release Notes for information about new features, enhancements, bug fixes and known issues in this release.

View this document in PDF format

You can download, view and save this document in Adobe PDF format. Click Download this document in the upper right-hand corner of this page. This action downloads the entire publication.

Conventions used in this guide

Conventions used in this guide
Conventions used in this manual

The following typographic conventions are used in this guide.

  • Bold represents required components of a command or option that must be typed as shown.
  • Italics represent variables defined, named or entered by the user.
  • {Braces} enclose required arguments.
  • [Brackets] represent optional command components and may also be used in example command strings to emphasize required user defined variables in long strings.

    Example:

    reconcile queue {queuename} for {datasource-datadest} [on host]

  • A vertical bar, or “pipe” character, ( | ) within brackets or braces indicates that you can use only one of the enclosed components.

    Example:

    abort service {service | all}

Names of commands, programs, directories and files are expressed in Bold.

Other names are expressed in capital letters using the default font.

Examples:

The sp_ctrl program is located in the bin directory.

Open the oramsglst file.

Find the value for ORACLE_HOME.

Click Apply.

System displays, such as prompts and command output, are expressed in a monofaced (fixed-space) font.

Examples:

sp_ctrl(sysA)>

User is a viewer (level=3)

Windows menu items, dialog boxes, and options within dialog boxes are expressed in Bold.

Example:

From the File menu, select Print.

System names are expressed generically or fictitiously. When necessary, the source system (or primary system) is referred to as SysA. Target systems (or secondary systems) are referred to as SysB, SysC, SysD, and so forth.

Introduction to SharePlex

Welcome to SharePlex
Contents

The advantages of SharePlex

Introduction to SharePlex > The advantages of SharePlex

SharePlex provides high-speed, log-based replication with support for many different configurations to meet your unique data availability needs. Major Unix, Linux, and Windows platforms are supported.

Support a variety of targets

SharePlex provides high-speed, log-based replication between Oracle instances on Sun Solaris, IBM-AIX, HP-UX, Linux, and Windows platforms. The SharePlex product line also provides the ability to replicate data from an Oracle source to Microsoft SQL Server, SAP Adaptive Server Enterprise (ASE), SAP HANA, PostgreSQL, Teradata, Files (SQL and XML format), Hadoop, JMS, and Apache Kafka.

You can also configure SharePlex to maintain a change history database. Rather than overlaying current target data with the data that changed on the source (as in a regular replication configuration) SharePlex inserts a new row for every change to provide a step-by-step history of every change made to the source database. Optionally, you can include metadata columns in each row to include context information about the change that was made.

Maintain up-to-date, accessible target instances

A major benefit of SharePlex replication is that users can access a target database while SharePlex updates it. SharePlex targets are continuously updated, providing a reliable copy of the production database that can be used for reporting, queries, extracts, backups, and high availability. Removing that processing from the production server improves the performance of the production database while enabling the secondary database to be optimized for the needs of its users. In addition, SharePlex delivers a logical replica that helps protect against accidental DDL or DML changes and database corruption.

Compare source and target data and repair inconsistencies

To verify the consistency of source and target data, SharePlex enables you to detect and correct hidden out-of-sync conditions in target tables before they become large problems that require the tables to be resynchronized. SharePlex detects extra or missing rows and rows whose values do not match. You can customize these comparisons, for example to filter the rows that are compared.

Support high-intensity OLTP and ERP environments

SharePlex is designed for business volumes of data. It is capable of replicating millions of transactions a day for thousands of tables. It supports business varieties of data, including data types such as LONG columns and sequences, which are found in ERP applications, as well as BLOB and CLOB datatypes.

Conserve system resources

SharePlex accomplishes its replication without significantly impacting the source database, the source system, or the network. Its log-based design allows it to replicate with very low overhead. Because SharePlex replicates changes as they occur, rather than on a commit or refresh schedule, it reduces the impact of replication on the network and does not cause spikes in network performance. This design also minimizes latency between source and target systems.

Replicate with both speed and accuracy

SharePlex is fast, minimizing the latency between source and target databases by capturing modifications to selected objects from the redo logs continuously and starting replication before transactions are committed. If a transaction is canceled, SharePlex replicates the rollback so that the target is an accurate representation of the source. SharePlex strictly adheres to the Oracle Read Consistency model, maintaining operation order and session context all the way to the target, where SharePlex uses standard SQL to apply the replicated changes.

Maintain fault tolerance

Another significant advantage of SharePlex is its tolerance for outages. If the target database is unavailable, SharePlex queues data on the target system, allowing transactions to accumulate until a target connection can be re-established. If the target system is down, or if there are network problems, SharePlex stores the transactions on the source system until operations are restored.

Maintain a high level of user control

With this design, you have additional options. You can control when SharePlex sends the data over the network. By default, SharePlex replicates as quickly as it can, sending a steady stream of data to the target systems, but you can delay transmission by stopping the Export process. To control when the transactions are applied to a target system, you can stop the Post process. When you are ready for the transactions to be applied, you simply start the posting process again. As an alternative, you can force the Post process to delay transactions based on a time factor, using one of the SharePlex tuning parameters.

Benefit from a high level of flexibility

SharePlex enables you to customize replication to specific needs. For example, you can replicate an entire table, or you can replicate a subset of its data (columns) beyond a firewall while protecting other, more sensitive data. You can replicate different records to different locations. And, you can configure SharePlex to interact with PL/SQL procedures that transform data before, or instead of, posting it to a target database.

SharePlex provides several other ways to configure replication routes, as well.

Install quickly and easily

SharePlex is relatively simple to install. The average installation takes about an hour for source and target systems. Configuration of replication scenarios may require more time if they are especially complex or if there are special circumstances.

Maintain a high availability environment

SharePlex provides significant advantages for high-availability and other mission-critical operations where perpetual data access is essential and downtime means lost business opportunities. Using WAN connections, SharePlex replication can be used to maintain a duplicate database in a different location that is ready for fast, seamless failover and failback in planned or unplanned mode.

When the primary system fails, user activity moves to the secondary system and continues while the secondary instance is copied and applied to the primary system during recovery. SharePlex reconciles the copy provided by the backup with the ongoing, replicated user transactions, discarding operations already applied by the backup. With synchronization between the two databases restored, users move back to the primary system and continue to work.

Simplify routine maintenance

SharePlex simplifies the maintenance of Oracle instances involved in replication by facilitating data re-synchronization with minimal interruption to user activity. Application and Oracle patches, upgrades, and DDL changes can be performed on the source machine and applied to the target machine with a hot backup instead of manually, while SharePlex replicates online transactions. SharePlex synchronizes the replicated changes with the backup, and replication resumes in a seamless manner.

Reduce downtime and risk from migrations

Hardware migrations usually require a significant amount of downtime, whether you need to change hardware platforms, move a data center, or consolidate servers to reduce costs. By maintaining a near-realtime copy of the database, SharePlex can help you minimize migration downtime by enabling the original system to function normally until the migration is complete.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents