Chat now with support
Chat with Support

SharePlex 8.6.6 - Installation Guide

About this Guide Conventions used in this guide Introduction to SharePlex SharePlex pre-installation checklist Set up SharePlex in an Oracle cluster Set up SharePlex on Amazon Cloud Download SharePlex UNIX Installation and Setup Windows Installation and Setup Assign SharePlex users to security groups Basic SharePlex demonstrations Advanced SharePlex Demonstrations Solve Installation Problems Uninstall SharePlex SharePlex Utilities Appendix A: Advanced installer options Appendix B: Install SharePlex as root Appendix C: SharePlex installed items

If the license utility returns errors

Solve Installation Problems > If the license utility returns errors

Are all machines connected to the network?

The inability of SharePlex components to perform initial TCP operations can sometimes appear to be license key or license utility errors. If you know you entered the correct key and machine IDs, verify that all systems on which you are loading SharePlex are connected to the network. The network node name and IP address of each system must be established sufficiently to allow SharePlex to perform TCP operations, even though the machines themselves are not yet configured. Also check to make sure that nobody has renamed the /etc/resolv.conf file (if using a DNS nameserver).

Did you enter the correct key and/or machine ID number?

If you received this error message: “Cannot add license: License key is illegal,” it could be that you entered an invalid license key. Assuming that you retyped the key correctly and still received an error, it probably means that the license key, though valid, is not the correct key for this system. Except for trial keys, which are generic, license keys are assigned to a specific machine according to the machine’s identification number (such as “host ID” on Sun systems, ‘machine ID” on HP systems, etc.).

You probably received at least two license keys from Quest — one for a source system and one for a target system — or if you are installing on multiple machines in a cluster, you should have a key for each one. Verify that the key you entered is the one that was issued for this system by comparing it to the machine identification number for which it was issued.

To view the machine ID and add a key on a Windows system

  1. Run the SpUtils utility from the SharePlex product directory, then click the License tab.
  2. Enter the license key and the SiteMessage code from the email that your company received from the Quest licensing team.

 

To view the machine ID and add a key on a Unix or Linux system

Run the splex_uname application from the install sub-directory of the SharePlex product directory on the machine whose ID number you want to confirm. It displays the ID number for the local machine, as shown in the example below.

$ /splex/proddir/install/splex_uname
 
Host ID = 2198894273 (831076C1 HEX)

Run the splex_add_key utility from the SharePlex product directory and add the license key and SiteMessage code from the email that your company received from the Quest licensing team.

If the installation program returns errors

Solve Installation Problems > If the installation program returns errors
Is sp_cop shut down?

If you installed SharePlex on this system before, and you are re-installing it, the installation will return errors if SharePlex is running on this system. Shut down SharePlex using the shutdown command in sp_ctrl, or you can shut down the SharePlex service if this is a Windows system. If you are unable to run sp_ctrl, or if any SharePlex processes will not die, locate the process (using ps -ef | grep sp_ on Unix and Linux systems or the Taskmgr tab available from the SpUtils application provided for Windows systems) and kill it. When all SharePlex processes have been killed, run the installation program again.

Are all systems connected to the network?

Check to see that all systems on which you are loading SharePlex are connected to the network. The network node name and IP address of each system must be established sufficiently to allow SharePlex to perform TCP operations, even though the target machines themselves are not yet configured.

Note: These failures may appear to be license utility errors, but it is usually the inability of the license utilities and other components of SharePlex to perform initial TCP operations. Also check to make sure that nobody has renamed the /etc/resolv.conf file (if using a DNS nameserver).

Did you enter the SharePlex groups in the name service?

If your environment uses a name service such as NIS or NISPLUS, you need to add the SharePlex groups and services to the nameserver before you run the SharePlex installation program, and the SharePlex Administrator must be named in the SharePlex Admin group on the nameserver before you install SharePlex. Instructions are on page 31. If these procedures are not performed, the installation will generate an error at the point in which it attempts to verify that the groups exist.

Is the database open?

The Oracle database for the ORACLE_SID that you will be replicating must be open while you are installing SharePlex.

Did you specify a valid ORACLE_SID and ORACLE_HOME?

If you specify an invalid ORACLE_SID or ORACLE_HOME value for the Oracle instance, the installation script is unable to locate the correct Oracle libraries to link to, and it will fail with an error such as this:

“Cannot find shared library usr1/oracle/ 8.1.6/lib/libclntsh.so; Exiting.”

Re-run the installation script again to provide the correct values for ORACLE_SID and ORACLE_HOME.

If database setup failed

Solve Installation Problems > If database setup failed

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.

If SharePlex does not interact with Oracle

Solve Installation Problems > If SharePlex does not interact with Oracle
Did you run database setup for all instances involved in replication?

The ora_setup database setup utility establishes SharePlex as an Oracle user. The SharePlex processes log into Oracle as this user on the source database to activate configurations and maintain the SharePlex internal replication tables, and they log in as this user on the target database to maintain tables there and apply replicated changes to the database through SQL*Plus.

To verify that the setup was performed on all Oracle instances, view the SP_ORD_OWNER_ and SP_ORD_LOGIN_ parameters. There should be an entry for the SharePlex Oracle user and password (encrypted). Use the following command in sp_ctrl:

 

sp_ctrl(sysA)> list param all read

Read parameters:

Parameter Name

--------------------------------

Actual Value

-----------------------

Units

----------

Set At

----------------------

SP_ORD_CDA_LIMIT 5 cdas Restart Process
SP_ORD_DATE_MSG 0   Live
SP_ORD_DEBUG 0x00000000 bitflag Live
SP_ORD_DEBUG_FLAG 0x00000000 bitflag Live
SP_ORD_DEBUG_OBJECT 0 objecti Live
SP_ORD_DELAY_RECORDS 200 records Live
SP_ORD_FIRST_FIND 1   Restart Process
SP_ORD_FULL_ROLLBACK 0   Live
SP_ORD_HP_HASH 16 slots Restart Process
SP_ORD_HP_IN_SYNC 0   Restart Process
SP_ORD_LDA_ARRAY_SIZE 5 logins Restart Process
SP_ORD_LOG_FILESIZE 50000000 bytes Restart Process
SP_ORD_LOG_NUMFILES 3 number Restart Process
SP_ORD_LOGIN_O 558ec793ac0c14ef8a06   Set Up
       
Default Value:      
SP_ORD_MSGS_CK_FREQ 10000 number Restart Process
SP_ORD_OWNER_O qarun   Set Up
       
Default Value:      
SP_ORD_RCM_SKIP_RATIO 2 ratio Restart Process
SP_ORD_RESTART_THRESHOLD 0 retries Live
SP_ORD_RMSG_LIMIT 1000 readrel Live
SP_ORD_UTILIZATION_TIMERS 0   Live

 

You also can verify that the setup was performed by querying the database for tables beginning with “SHAREPLEX_,” and you can check to see if an Oracle account was established for SharePlex. If these items do not exist, shut down sp_cop and run the setup utility. See Oracle Setup (ora_setup).

Did you assign a DBA role to the SharePlex Oracle user?

The SharePlex Oracle user requires a DBA role with unlimited privileges. The SharePlex user is created with the default Oracle profile under the assumption that the profile has the unlimited resource privileges assigned by Oracle as the default. If SharePlex is unable to interact with Oracle, check to see if the default was changed. If so, assign SharePlex a DBA role with unlimited privileges for all definitions.

Related Documents