Monitor Replication with SNMP
SharePlex provides agent support for Simple Network Management Protocol (SNMP) on all Unix and Linux platforms supported by SharePlex replication.
Note: SharePlex provides only agent support for SNMP. It only sends SNMP traps. SharePlex does not provide an SNMP signal daemon (SNMP manager) to intercept the traps. Use the SharePlex SNMP feature only if you have a Network Management Station (NMS) to manage SNMP signals. The SharePlex SNMP agent is named snmptrap and is installed with SharePlex in the bin sub-directory of the SharePlex product directory. Do not run this program.
Enable SNMP
To enable SNMP monitoring of SharePlex replication, set the SP_SLG_SNMP_ACTIVE parameter to 1. By default, the parameter is set to 0 (disabled).
Configure the SNMP agent
The following parameters configure the SNMP agent to communicate with the NMS. Each parameter must have a value if the SP_SLG_SNMP_ACTIVE parameter is enabled.
| SP_SLG_SNMP_HOST |
The name of the system (host) to which the traps will be sent |
| SP_SLG_SNMP_COMMUNITY |
The community security string |
| SP_SLG_SNMP_MJR_ERRNUM |
The major error number to be used by the traps |
| SP_SLG_SNMP_MNR_ERRNUM |
The minor error number to be used by the traps |
Custom MIB parameters
The following parameters specify required information for a custom MIB.
| SP_SLG_SNMP_ENTERPRISE_OID |
The enterprise object identifier to send with the trap. The default is 1.3.6.1.4.1.3.1.1 . |
| SP_SLG_SNMP_TRAP_OID |
A custom object identifier to bind to the trap. The default is 1.3.6.1.2.1.1.1.0. |
| SP_SLG_SNMP_TRAP_PROGRAM |
The name of the trap program. The default is iwsnmptrap. |
Configure the SNMP traps
The following parameters configure the SNMP agent to send traps for specific replication events. The message or error text for the event is included in the trap and is the same error that appears in the Event Log.
To enable an SNMP trap for an event, set the corresponding parameter to a value of 1. By default all traps are disabled (parameter value of 0).
| SP_SLG_SNMP_INT_ERROR |
SharePlex logic errors and errors that cause processes to exit |
| SP_SLG_SNMP_SYS_ERROR |
System-related errors encountered by SharePlex |
| SP_SLG_SNMP_ERROR |
Other SharePlex errors |
| SP_SLG_SNMP_OUT_OF_SYNC |
Replication is out of synchronization |
| SP_SLG_SNMP_STARTUP |
SharePlex starts up |
| SP_SLG_SNMP_SHUTDOWN |
SharePlex shuts down |
| SP_SLG_SNMP_LAUNCH |
A SharePlex process starts |
| SP_SLG_SNMP_EXIT |
A SharePlex process stops |
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 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.
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
| 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. |
-
See How to Find the ORACLE_SID and ORACLE_HOME to determine the Oracle values.
- 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. |
| 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. |
