Chat now with support
Chat with Support

SharePlex 10.2.1 - Administration Guide

About this Guide Conventions used in this guide Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl Set SharePlex parameters Configure data replication 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 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

Prevent and solve replication problems

This section contains solutions to many of the common questions and problems that can arise during replication, and it also suggests preventive measures for avoiding problems.

Contents

Find the problem in the SharePlex Knowledge Base

If the issue you are experiencing is not listed in this documentation, search the SharePlex Knowledge Base at:

https://support.quest.com.

The Knowledge Base provides filtering options and links to other resources that can help you use and troubleshoot SharePlex.

Solve database setup problems

This section helps you diagnose problems that are associated with the SharePlex database account and connection information that was created with the Database Setup utility when SharePlex was installed on the system.

Note: For more information about Database Setup, see Database Setup Utilities in the SharePlex Reference Guide.

If the issue you are experiencing is not listed in this documentation, search the SharePlex Knowledge Base at:

https://support.quest.com.

The Knowledge Base provides filtering options and links to other resources that can help you use and troubleshoot SharePlex.

Oracle setup issues

Problem Description Solution
Incorrect ORACLE_SID and/or ORACLE_HOME If SharePlex cannot interact with Oracle, it might be using the wrong ORACLE_SID and/or ORACLE_HOME.
  1. See How to find the ORACLE_SID and ORACLE_HOME to determine the Oracle values.

  2. Rerun the Database Setup utility. For more information, see Database Setup Utilities in the SharePlex Reference Guide.
Insufficient database privileges If the Database Setup utility fails, the person who runs it may not have the correct privileges

For more information, see Database Setup Utilities.

Asterisk as the ORACLE_SID entry Sometimes, the oratab file has an * (asterisk) symbol instead of a value for the ORACLE_SID. Ensure that a valid ORACLE_SID is in the oratab file, and then try running the database setup again.
More than one oratab file (Sun Solaris)

On Solaris systems, the oratab file is typically located in the /var/opt/oracle directory, but because other platforms store the oratab file in the /etc directory, there could be a second oratab in the /etc directory.

Either move, rename or delete the secondary oratab file, and then try running the database setup again.
Oracle not running

Oracle must be running and the instance must be open while you run the Database Setup utility. The utility accesses Oracle to establish SharePlex as a user and install its internal tables.

Start Oracle and open the instance.
sp_cop is running The SharePlex sp_cop process cannot be running while you are running the Database Setup utility. If it is running, shut it down using the shutdown command in sp_ctrl. Run sp_ctrl from the bin sub-directory in the SharePlex product directory.

Solve configuration file problems

This section reviews problems and solutions associated with the management of configuration files. See also Solve activation problems.

If the issue you are experiencing is not listed in this documentation, search the SharePlex Knowledge Base at:

https://support.quest.com.

The Knowledge Base provides filtering options and links to other resources that can help you use and troubleshoot SharePlex.

A configuration file was accidentally deleted

You might be able to recover an accidentally deleted configuration file if that configuration was previously active and you did not run db_cleansp since it was activated.

Solution: View the Event Log to determine the activation ID for that configuration file, then look in the save sub-directory of the SharePlex variable-data directory for a .conf.actid file, where actid is the activation ID you got from the Event Log.

Solve configuration file errors

Error message Description Solution
The parameter for ‘create config’ must be a new file name. or... Destination file exists - file must not exist prior to operation. The name you gave this configuration already exists for another configuration file. Use a different name. To see a list of configurations on a system, use the list config command.
Couldn’t fork editor. or… Editor execution failed. SharePlex failed to open the default text editor. Make sure the editor still exists on the system. The default editors is WordPad on Windows. To change the default text editor, see Set a default editor for sp_ctrl.
Destination file exists - file must not exist prior to operation. The name you specified when copying the configuration file already exists in this SharePlex instance. Use a different name. To see a list of configurations on a system, use the list config command.
Problems in reading or writing file used in edit -- command aborted. The edit config command could not open the specified file. Confirm the name of the file you are trying to edit, including the case, and check to see if the file is corrupted.
Destination file exists - file must not exist prior to operation. The new name you are giving this configuration already exists for another file. Use a different name. To see a list of configurations on a system, use the list config command.
Invalid file name passed to command. or… File does not exist. You could have misspelled the configuration name or used the wrong case. Verify the name and spelling, including the case, then enter it again. To see a list of configurations on a system, use the list config command.
File access denied - check file permissions. You are not authorized to issue the command. View your authorization level with the authlevel command in sp_ctrl, then determine its minimum authorization level. The SharePlex Administrator assigns authorization levels. For more information, see About the SharePlex security groups.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating