SharePlex 8.6.6 - Installation Guide

How to find the ORACLE_SID and ORACLE_HOME

To connect to an Oracle database, SharePlex gets the ORACLE_SID from the input provided during the database setup process that is performed during installation. By default, the database setup program (ora_setup) displays the SID that was specified when the SharePlex installer was run. The person who runs database setup has the option to enter a different ORACLE_SID from the default shown. Based on the value of the ORACLE_SID, 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.

Uninstall SharePlex from Windows

Files removed by the uninstall program

When SharePlex was installed, a file named install.log was installed in the SharePlex product directory. This file contains a record of all files created on the system by the installation program. When you run the uninstall program to remove SharePlex, it reads install.log to determine which files to remove.

If you select the Automatic uninstall option, it removes the following components for all instances of SharePlex (all SharePlex services on all ports):

• The SharePlex desktop icons.
• The SharePlex menu items (except for the top-level Program Manager Group folder).
• The SharePlex product directory. If the variable-data directory is installed under the product directory but contains no files that were added after installation, it is removed as well.

Use the Custom uninstall option to remove specific files while leaving the others intact.

Files not removed by the uninstall program

The uninstall program does not remove the following components.

• The SharePlex and MKS Toolkit entries in the Registry.
• Files that already existed in the product directory when the current version of SharePlex was installed.
• Files created by SharePlex or a user in the product or variable-data directory after the current version of SharePlex was installed. Such files can be removed manually after SharePlex is removed. This is standard procedure for most Windows applications.
• The SharePlex variable-data directory. To remove this directory, delete it through the operating system. The uninstall program does not remove this directory because there could be user-created files, such as configuration files and custom parameter settings, that you want to keep for a future installation of SharePlex.
• The MKS Components programs and files. These can be removed separately using the Remove the MKS Toolkit operating environment procedure.

Remove SharePlex from the system

Perform these tasks in the order shown.

Remove the SharePlex service

Before you remove the SharePlex software from the system, follow these steps to stop and remove each SharePlex service on the system. If you remove SharePlex first, you cannot use SpUtils to stop and remove the service and must do so from the Services utility of the Windows Control Panel.

1. Double-click the SpUtils desktop icon.
2. Click the SharePlex Services tab.
3. Select the port number for the SharePlex instance that you want to remove. The Current State field displays the status of SharePlex on that port.
4. If the service is running, click Stop. Make certain the status shows Stopped.
5. Click Remove.
6. Stop and remove other SharePlex services as needed.
7. Close the SharePlex Services dialog box.

Remove the SharePlex software

1. From Start menu, click Programs, then navigate to the SharePlex program folder and click Uninstall. Alternatively, you can use

   the Windows Control Panel as you normally would to remove software.

2. In the Select Uninstall Method dialog box, select an uninstall option.

   • Select Automatic to remove everything listed in Files removed by the uninstall program. This is the recommended procedure because it is the cleanest way to remove SharePlex from the system. Click Finish to execute the uninstallation.

   • Select Custom to selectively remove files. Use this option only if you must retain some files while deleting others. You receive a series of prompts to remove different sets of files.

   • Select Repair to re-install files or update Registry entries. Click Finish to execute the repair.

Remove the MKS Toolkit operating environment

Changing and removing Windows Registry components may be harmful to the system. Contact your System Administrator for assistance if needed.

1. Remove the MKS Platform Components software using the standard Programs uninstall option in the Windows Control Panel.
2. Remove the NuTCRACKER service from the Services utility of the Windows Control Panel.

Remove Registry entries