Chat now with support
Chat with Support

SharePlex 11.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 Assign SharePlex users to security groups 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

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

Find the Solution 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

Solve database setup problems for Oracle

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 Installation and Setup 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.
Oracle library location not correct

On Unix and Linux systems, SharePlex expects the Oracle library to be in the $ORACLE_HOME/lib or $ORACLE_HOME/lib32 directory. In some environments, the Oracle library has a different name than what SharePlex expects it to be, or it is installed in a different location than expected (or both). In that case, you will see an error message when you attempt to run the Database Setup utility.

Install the appropriate library from Oracle and then re-start SharePlex (if it is stopped). SharePlex will link to the correct library from that point forward.

ld.so.1: sqlplus: fatal: libsunmath.so.1: can't open file: errno=2” error On Unix and Linux systems, this error indicates that SharePlex cannot find the libsunmath and libshareplex libraries, even though the link exists in the proper place.

You can use either of these solutions:

  • Create a softlink for $ORACLE_HOME/lib/libsunmath.so.1 in the /usr/lib directory. or...
  • In the ECXpert/config/bdg.ini file in the [DB_ENV] section add the following line:

    LD_LIBRARYPATH=full oracle home path/lib

Wrong user-id

To run Database Setup on Unix and Linux systems, the set-user-id for the Oracle software need to be -rwsr-s--x. Those permissions allow non-Oracle users to log into SQL*Plus.

Set the correct values for set-user-id.

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 vi on Unix and Linux . 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