Chat now with support
Chat with Support

SharePlex 8.6.6 - 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 SharePlex parameters Prepare an Oracle environment for replication Create a configuration file Configure replication to Open Target targets Configure a replication strategy Configure partitioned replication Configure named queues Configure SharePlex to maintain a change history target Replicate Oracle DDL Set up error handling Transform data Configure SharePlex security features Activate replication in your production environment Monitor SharePlex Prevent and solve replication problems Repair out-of-sync Data Procedures to maintain Oracle high availability Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Tune the Capture process Tune the Post process Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

Prevent and solve replication problems

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

Prevent and solve replication problems > 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

Prevent and solve replication problems > 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 (ora_setup) when SharePlex was installed on the system.

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. See the SharePlex Installation Guide for more information.
Insufficient database privileges If the database setup fails, the person who runs it may not have the correct privileges

See the SharePlex Installation Guide for the required privileges.

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.
/etc/logingroups file exists (HP-UX) Look for an /etc/logingroups file on the system. This file existed on HP-UX systems prior to the adaptation of POSIX standards. To allow backward compatibility, HP-UX gives priority to /etc/logingroups, and uses the /etc/group file only if /etc/logingroups does not exist. Edit the /etc/group file to make its entries identical to those in the /etc/logingroups file, then delete the etc/logingroups file.
Oracle not running

Oracle must be running and the instance must be open while you perform database setup. The setup program 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 performing database setup. 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 perform database setup.

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 perform 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.

SQL Server setup issues

Problem Description Solution

Database setup fails with cursor or connection error

If the database setup utility cannot interact with the SQL Server database, you might have specified the wrong name for the database.

When prompted for the database name in the setup interface, you must specify the actual name of the database, not the SQL Server instance name or the Data Source Name(DSN). Find out the name of the database, then use it when you run the setup again.

Insufficient database privileges If database setup fails, the person who runs it may not have the correct privileges

See the SharePlex Installation Guide for the required privileges.

Solve configuration file problems

Prevent and solve replication problems > 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 are vi on Unix and Linux and 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.
Edit config file is not allowed for an active config file. SharePlex does not allow editing of an active configuration.
  1. Copy the configuration using the copy config command.
  2. Edit the copy using the edit config command.
  3. Activate the new configuration file.
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 see Overview of SharePlex security groups for the command to determine its minimum authorization level. The SharePlex Administrator assigns authorization levels.
     
Related Documents