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.
Find the problem in the SharePlex Knowledge Base
Solve configuration file problems
Solve Oracle DDL replication problems
Solve synchronization problems
How to resynchronize source and target objects
How to restore Oracle archive logs
How to release semaphores after process failure
If the issue you are experiencing is not listed in this documentation, search the SharePlex Knowledge Base at:
The Knowledge Base provides filtering options and links to other resources that can help you use and troubleshoot SharePlex.
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:
The Knowledge Base provides filtering options and links to other resources that can help you use and troubleshoot SharePlex.
| 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. |
|
| Insufficient database privileges | If the Database Setup utility fails, the person who runs it may not have the correct 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. |
| 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:
|
| 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. |
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:
The Knowledge Base provides filtering options and links to other resources that can help you use and troubleshoot SharePlex.
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.
| 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. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
