SharePlex 9.0 - Installation Guide

If SharePlex cannot connect to the database

If SharePlex cannot connect to a source or target database, you can verify the login credentials that are being used for that database by using the connection command with the show option. For example:

sp_ctrl> connection r.mydb show

or...

sp_ctrl> connection o.mydb show

You can also view connection settings in the connections.yaml file, which is stored in the data sub-directory of the SharePlex variable-data directory. If there are no settings in this file, it means that the SharePlex database setup procedure was not performed on this database. For more information, see SharePlex utilities.

To update connection information

If you need to update the connection information, use the connection command with the appropriate options. For more information, see the SharePlex Reference Guide.

How to find the ORACLE_SID and ORACLE_HOME

When setting up SharePlex to work with a database, you provide the ORACLE_SID and then SharePlex gets the ORACLE_HOME from the Registry or oratab file. Both values are stored in the SharePlex environment. SharePlex uses the Oracle libraries that are in the location specified with ORACLE_HOME.

To determine the ORACLE_SID and ORACLE_HOME being used by SharePlex

Issue the orainfo command in sp_ctrl.

To determine the default ORACLE_SID and ORACLE_HOME on Windows

View the Oracle entry in the Registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.

To determine the default ORACLE_SID and ORACLE_HOME on UNIX and Linux

On most Unix and Linux systems the oratab file is under /etc/oratab. On Oracle Solaris systems, it is under /var/opt/oracle, but sometimes there is an oratab file in the /etc directory as well.

The entry in the file looks like the following example:

qa12:/qa/oracle/ora12/app/oracle/product/12.0

In the example, qa12 is the ORACLE_SID and /qa/oracle/ora12/app/oracle/product/12.0 is the ORACLE_HOME.

Uninstall SharePlex

Contents

This section contains instructions for using the SharePlex uninstallation program to remove SharePlex from a system. The uninstaller permanently removes the replication environment from the system.

To preserve the replication environment, including the queues that store the data, you can install a SharePlex upgrade or reinstall the current version, rather than uninstall SharePlex. Before you upgrade or reinstall SharePlex, see the Release Notes for the version you are installing to determine if there are any special upgrade or installation requirements.

Uninstall SharePlex from UNIX

1. Log on as a user who has privileges to remove the SharePlex directories.
2. Run sp_ctrl.

3. Issue the shutdown command to shut down SharePlex.

   sp_ctrl> shutdown

4. Exit sp_ctrl.

5. Use the following command to make certain that no SharePlex processes are running.

   # ps -ef | grep sp_

6. Kill any processes that are still running.
7. Remove the SharePlex product directory, variable-data directory, and the hidden .shareplex directory from the system.
8. Drop the SharePlex database user from the database.

Note:

If desired, remove any objects that SharePlex installs in the database. These objects begin with SHAREPLEX_. You can remove any such objects using standard SQL commands.