Welcome, we are now Quest! Learn more about Support at Quest

SharePlex 7.6.3 - Administrator Guide

SharePlex® For Oracle About this manual What's New in 7.6 How SharePlex Works Running the SharePlex Programs Planning SharePlex Replication Preparing for SharePlex Replication SharePlex Optional Setup Starting SharePlex Replication Using SharePlex in a High-Availability Environment Unattended SharePlex Monitoring Changing Oracle Characteristics Of Replicated Objects Performing Administrative Operations SharePlex Utilities Glossary

Using the SpUtils utility

On Windows systems, SharePlex provides the SpUtils utility, which enables you to start SharePlex and run select management utilities from one interface.
To run SpUtils, double-click the SpUtils shortcut on the Windows desktop.
Click the Start button on the Windows taskbar, then select Programs and navigate to SpUtils in the SharePlex programs group. The SharePlex Utilities dialog box appears.
Click the Information tab to view information about the system where SharePlex is installed and about the SharePlex version and environment.
Click the SharePlex Services tab to install, start, stop, or remove a SharePlex service (instance of SharePlex). For more information about running SharePlex, see Chapter 3. For more information about installing and removing the SharePlex service, see the SharePlex Installation and Demonstration Guide.
Click the OraSetup tab to run the OraSetup utility, which establishes an Oracle account for SharePlex and installs database objects necessary for replication. For more information about running OraSetup, see page 392.
Click the OraCleanSp tab to run the OraCleanSp utility, which removes the current replication environment. For more information about running OraCleanSp, see page 421.
Click the License Key tab to view, add, or change the SharePlex license key for an instance of SharePlex, and to view the machine ID number associated with the license key. For more information about managing license keys, see page 426.
Click the TaskMgr tab to run the Windows Task Manager with special privileges so that you can terminate SharePlex processes or set their priority. You cannot terminate SharePlex processes or set process priority through the regular Windows Task Manager because the NuTCRACKER environment controls the SharePlex processes.
The dialog box displays only the SharePlex processes, filtering out other processes on the system. To terminate a process or set its priority, right-click the process name in the dialog box, then select either End Process or Set Priority (shown below).

Was this topic helpful?

[Select Rating]



Using the SpClient remote-access utility

On Windows systems, you can use the SpClient utility instead of other remote-access programs (such as Terminal Server) to log onto any replication system from one central machine and perform the following SharePlex functions:
Run OraCleanSp
Run OraSetup
Run SplexAddKey
Activate and configure the Sp_Nt_Mon monitoring utility
SpClient is installed automatically when you install SharePlex, or you can install it as a stand-alone program on a machine that is not used for replication. SpClient runs on any Windows machine.
The sp_remote agent runs in the background as a service on machines where you are running SharePlex. It starts when the system starts.
The sp_client process is the user interface, which you can run from any machine whether or not SharePlex is installed there.
Figure 23 illustrates the SharePlex tool bar buttons. These buttons are inactive until you log onto a system. The other buttons are standard Windows buttons.
Remote logon — to connect to a remote replication machine
Local logon — to connect to the local machine
Logoff — to end the current session of SpClient
SpServices — to install, remove, start, or stop the SharePlex service. For more information about controlling the SharePlex service, see Chapter 3.
OraCleanSp — to run OraCleanSp to restore replication to an initial state. For more information about running OraCleanSp, see page 421.
SpOraSetup — to create or change the SharePlex Oracle user and set up the instance for SharePlex replication. For more information about running OraSetup, see page 392.
SpAddKey — to add a SharePlex license key to a machine and to find out the machine ID number.
SpTaskMngr — to open a SharePlex-filtered version of the Windows Task Manager to terminate SharePlex processes and set process priority. For more information, see the instructions on page 442.
SpMonitor — to configure and run the Sp_Nt_Mon monitoring script. For more information about using Sp_Nt_Mon to monitor replication, see “Monitoring SharePlex on Windows systems” on page 338.
SpClient includes standard Windows File, Edit, View and Help menus. In addition, the Access and Select menus let you perform the same tasks as the toolbar buttons. Whether to use the menu or the toolbar is a matter of personal preference.
SpClient output does not enter the Event Log. To save a session’s records, you can print the output or save it to a text file using standard Windows Print and Save commands from the File menu.
From the Start menu, navigate to the SpClient shortcut in the SharePlex Programs folder.
Use Windows Explorer to navigate to the bin sub-directory of the SharePlex product directory. Double-click the SpClient program.
When you run SpClient, it opens a blank client window containing a display area and a Windows menu bar and toolbar. To begin using SpClient, log onto either a remote system or the local system, depending on the location of the SharePlex instance you want to affect.
1
On the toolbar, click the Local Logon button.
SpClient does not request logon information for the local machine. It uses the logon that you supplied when you logged onto Windows. It verifies the logon in the output window. When logon is verified, the other SpClient buttons on the toolbar become active (displayed in color instead of gray).
1
On the toolbar, click the Remote Logon button.
The Remote Access dialog box appears.
2
In the Remote Access dialog box, enter the following:
In the User Name field, enter a valid Windows logon name. This user must be a member of the SharePlex Admin group on the remote machine. This is true for the system Administrator, as well as all other users.
In the Password field, enter the password for that user.
In the Machine Name field, enter the name of the replication system to which you want to connect. The sp_remote client must be installed on that system for the connection to succeed.
In the Port Number field, enter the port number for SpClient on that machine. Do not enter the port number for SharePlex.You can either accept the default port number for SpClient (2101) or enter a different port number where SpClient was installed on that machine.
3
To initiate the connection, click Connect. SpClient displays the connection status at the bottom of the Remote Access dialog box.
4
Click Done to close the dialog box. The other SpClient buttons on the toolbar are now active (displayed in color instead of gray).
To log off from the local system or a remote system, click the Logoff button on the toolbar. SpClient terminates the connection, but the SpClient interface remains active to enable logon to a different system.
The SpClient Task Manager provides a filtered view of the Windows Task Manager that displays only the SharePlex processes on the machine to which you connected. The display is continuously updated.
1
On the toolbar, click the SpTaskMngr button.
The SpClient Task Manager window appears, showing all SharePlex processes for the port number displayed in the list box. To display processes for other SharePlex port numbers, select the port number from the list box.
2
[Optional] To kill a SharePlex process, right-click the process name, then select End Process.
3
[Optional] To change the priority of a SharePlex process, right click the process name, then click Set Priority and select a priority setting.
4
Click Exit to close the Task Manager and return to the SpClient interface.

Was this topic helpful?

[Select Rating]



Glossary

active-active replication
A DDL command that changes a table’s structure, storage characteristics or other parameters. Some ALTER TABLE commands are replicated by SharePlex.
bi-directional replication
Replication that goes in both directions: from the source to the target, and then from the target back to the source, used in disaster recovery and peer-to-peer replication.
An acronym for Binary Large Object. This is a built-in Oracle datatype consisting of unstructured (not recognized by the database) binary data of up to 4 GB in length that is stored in the database. Some examples of BLOBs are photographs, video clips, sound files, and other files stored in proprietary format.
asynchronous replication
Replication that does not require the source and target instances and network to be accessible at all times. Instead, it allows activity to continue on the source and lets transactions queue if the network, target system or target instance is down.
One of the major SharePlex processes. Residing on the source system, it copies the source data from the Oracle redo logs and places it into the capture queue.
A constraint set on data that, when a DELETE operation is performed on a primary key column, automatically initiates a DELETE operation on the row containing the related foreign key in a dependent table.
cascading replication
A multi-tiered replication strategy that uses an intermediary target system to pass replicated data on to remote target system(s) that are not networked to the source system.
A row in a table that is stored in more than one database block and therefore has several row pieces. These have a negative impact on the performance of the system and on the replication speed of SharePlex.
checkpoint recovery system
A process used by SharePlex to facilitate safe, asynchronous transport of data by acknowledging the receipt of packets and monitoring their sequence. This enables SharePlex to identify missing elements and request re-transmission.
An acronym for Character Large Object. This is a built-in Oracle datatype consisting of fixed or variable-width character data of up to 4 GB in length that is stored in the database. An example of a CLOB is an unstructured XML document or an ASCII text file.
A file containing the specifications that tell SharePlex which objects to replicate, and to which target systems the replicated data should be sent.
User-defined instructions that tell the Post process what action should be taken when the pre-image of data from the source system does not match the local data on the target system. Conflicts often occur in peer-to-peer environments where it is possible for different users to change the same data on different systems.
consolidated replication
constraint (integrity constraint)
The SharePlex term for the Oracle instance containing the objects being replicated by SharePlex for Oracle. This is also the term for the source UNIX filesystem in SharePlex FS software from Quest.
This is the SQL language used to define data in a database, such as when creating and altering tables. SharePlex replicates some DDL.
A read-only set of tables that provides information about the database. The data dictionary is central to database operations because it contains information about schemas, storage, column defaults, integrity constraints, user information, permissions, and other information. The data dictionary is stored in the SYSTEM tablespace.
An alternative to data warehousing that stores only a subset of an organization’s data intended for use by an individual department or group of users.
Sometimes used synonymously with target data. This is the copy of the source data that SharePlex maintains in the target instance on the target system.
Sometimes used synonymously with target system. This is the system or systems containing the objects to which the replicated data is written by SharePlex.
The ability to continue computer operations after the primary computers and related hardware/software are disabled by unplanned outages such as a fire or earthquake.
Enterprise Resource Planning software. A group of business applications such as Oracle Applications that work in concert with each other to manage data consistently throughout an organization.
A single incident in the SharePlex process, such as the startup of a process, the execution of a command, or the establishment of a connection.
A log maintained by SharePlex that records all replication events, such as the activation of a process or the issuing of a command, used primarily for problem solving.
A temporary data repository created by SharePlex which holds data that is ready to be transported from a source system to the target system.
One of the major SharePlex processes. Residing on the source system, it sends replicated data from the source system to the target system over the TCP/IP network.
The primary key of one table that is stored in another referenced table. It establishes a relationship between the tables and allows users to access the information in both tables quickly and efficiently.
horizontally partitioned replication
Also known as selective row replication, this feature of SharePlex allows you to replicate selected rows of a table, based on column conditions that you define before configuration activation.
An alternate online database that, when opened, is ready to take over for the production database in the event of an emergency or planned downtime.
One of the major SharePlex processes. Residing on the target system, it receives the replicated data from the source system and places it in a post queue for subsequent writing to disk.
Created for a table to allow faster access to the table data by organizing and referencing each row’s key; without an index, the entire table must be scanned by Oracle and SharePlex. Adding an index greatly speeds replication processing.
A single manifestation of an Oracle database complete with datafiles, connectivity information, shared area memory and its own name, number, and parameters. Multiple instances can run on one computer using one installation of Oracle.
SharePlex allows you to specify one or more columns to be used as a key when a table does not have a unique or primary key. The key definition is specified in the configuration file.
The difference in time between when the source data is changed and when the target data reflects that change. SharePlex minimizes latency because it replicates changes continuously, instead of waiting for a commit to be issued.
Oracle acronym for Large Object. A LOB can be large graphics files, formatted text files, audio, video and other unstructured data of up to four GB in size that is stored in a database. SharePlex replicates BLOB and CLOB large objects. (See BLOB and CLOB.)
log-based replication
The overwriting of the first Oracle redo log after the last one allocated to the instance has filled up. This has important implications for SharePlex replication.
A column in a table reserved for large chunks of data. LONG columns are replicated by SharePlex, but tables containing LONG columns should have a primary key for faster processing.
A database that contains a complete copy of the objects and is independent of any other database in the replication hierarchy. This also is known as a “production” or “source” database.
A message is a packet of information that is sent from Capture to the other replication processes in sequence. A message can reflect a SQL operation or an internal SharePlex operation, but most of the time it is an INSERT, UPDATE, DELETE, COMMIT, TRUNCATE or a supported DDL operation. Large operations like those on LONG or LOB columns can be spread among more than one message because a message has a size limitation. Other operations, such as array inserts of small records, have the inverse effect: There could be one record for numerous operations. In general, unless you are replicating numerous changes to LONGs and BLOBs, you can assume that the number of messages that you see in a process or queue status display approximately corresponds to the same number of SQL operations.
A SharePlex queue other than the default queue created by SharePlex; a named queue is created when a user defines it within the configuration file.
An internal table maintained by SharePlex that maps an object ID to the object name, creating a snapshot of all the objects that contains the name, size and type of columns in each one, along with any constraints.
partitioned replication
peer-to-peer replication
Replication strategy where users on the source and one or more target systems all make changes concurrently to the same data while SharePlex replicates it, using conflict resolution routines to determine how to handle duplicity. This strategy is also known as “active-active,” “master-to-master” or “multi-master” replication.
A temporary data repository that receives replicated data from the Import process on a target system and holds it until the Post process writes it to disk.
One of the major SharePlex processes. Residing on the target system, it is responsible for making sure source and target data match and writing changes to the target instance.
A snapshot of the most recent source data values before the current block of changes was made. Before applying those changes to the target instance, the Post process compares the pre-image with the target data to ensure that the values are the same. If the values are different, the data is out of sync.
primary key/unique key
A column or set of columns containing unique identifying values for each row in a table, such as a customer ID number. Using a primary key on tables increases the speed of SharePlex replication.
An interim data repository created by SharePlex to store replicated data as it is passed along its route from the source to the target system. There are three queues: the capture and export queues on the source system, and the post queue on the target system.
A storage unit on a system that is devoid of operating system or application software or formatting, used only for storing raw data.
One of the major SharePlex processes. Residing on the source system, it takes replicated raw data from the capture queue and prepares it for export to the target system.
Temporary log files maintained by Oracle that record every user transaction for recovery purposes and, if specified, are periodically written to permanent archive logs. SharePlex reads the redo logs in order to replicate the data specified in a configuration.
referential integrity
The process of copying data from a source machine to a target machine for backup, reporting or other purposes. SharePlex is a type of replication software.
Internal Oracle safety devices that are used to reconstruct lost information in the data recovery process. SharePlex uses the rollback segment to maintain a snapshot of all current transactions.
The information in a configuration that tells SharePlex where to send the replicated data. The basic components of a routing map are the target machine’s name and the ORACLE_SID of the target instance.
Software from Quest that replicates UNIX filesystems, allowing replication of files outside of the Oracle instance for use in disaster recovery strategies.
The SharePlex master control program. It runs in the background on both source and target machines to establish and coordinate replication processes.
Structured Query Language, the standard for data access in most database environments, and the language used by SharePlex in the replication process.
Established rules and application logic for manipulating data which are maintained as a group of SQL and PS/SQL code that resides within the database instead of within the application on the client machine. This speeds up Oracle processing and also allows repeat use of the code by other users and applications.
The process of making target data identical to source data. SharePlex replication maintains synchronization between the source and all target systems to provide an alternate instance for backup, recovery, reporting and other purposes.
This SharePlex feature allows you to manipulate replicated data instead of posting it, using custom PL/SQL procedures. The procedure manipulates the data and controls where the resultant data is posted.
uni-directional replication
vertically partitioned replication
Also known as selective column replication, this feature of SharePlex allows you to replicate selected columns of a table, as specified in the configuration file.
A representation of an existing table that can be used in the same manner as a table but does not actually exist as an object with physical storage space. It is a way for controlling the way a table can be seen by different users.

Was this topic helpful?

[Select Rating]



Related Documents