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.
sp_ctrl (mysysl11:2101)> orainfo
Oracle instance #1:
Oracle SID ora12
Oracle HOME /oracle/products/12
Oracle Version 12
Oracle instance #2:
Oracle SID ora12
Oracle HOME /oracle/products/12
Oracle Version 12
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.
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.
Issue the shutdown command to shut down SharePlex.
sp_ctrl> shutdown
Use the following command to make certain that no SharePlex processes are running.
# ps -ef | grep sp_
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.
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):
Use the Custom uninstall option to remove specific files while leaving the others intact.
The uninstall program does not remove the following components.
Perform these tasks in the order shown.
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.
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.
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.
Changing and removing Windows Registry components may be harmful to the system. Contact your System Administrator for assistance if needed.
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432\Node\Datafocus
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432\Node\Mortice Kern Systems
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432\Node\Quest Software
This uninstaller does not remove the SharePlex database objects. All SharePlex objects are installed in the SharePlex schema or database that was specified when the Database Setup portion of the installation was performed.
Important! If you intend to reinstall SharePlex or MKS Toolkit, they will not reinstall unless these Registry entries are removed.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy