Change the SharePlex database account
You can change the user name (schema or database), the password, or both in the SharePlex database account. The database account was established during the installation of SharePlex. These procedures guide you through the process in the correct order to maintain an active replication configuration.
Supported databases
All SharePlex-supported databases
Procedure
This procedure changes the user account name and/or password of the SharePlex user account in a database. This user account is the one that the SharePlex processes use to connect to the database when performing replication tasks.
Important! If using multiple variable-data directories, you must run this procedure for each one that you want to change.
- Run sp_ctrl on the system where you are changing the password.
-
Stop the SharePlex processes on the system where you are changing the account information. For example, if you are changing the SharePlex account in the source database, stop Capture and Read. If you are changing the account in the target database, stop Post.
sp_ctrl> stop service
-
Verify that all SharePlex replication processes for this instance of SharePlex are stopped.
sp_ctrl> status
- Log in to the database as a DBA user and change the SharePlex account name and/or password to the new ones. Important! Do not delete the SharePlex objects!
-
If you changed the account name, copy all of the SharePlex database objects from the old account to the new one.
Note: Keep the old account and SharePlex objects as backup until you are certain replication resumes properly.
-
In sp_crtl, issue the following command to change the account name and/or password in the SharePlex internal records.
To change the user account:
sp_ctrl> connection {o.SID | r.database} set user=username
To change the password:
sp_ctrl> connection {o.SID | r.database} set password=password
where:
-
Start the SharePlex processes.
sp_ctrl> start service
Change the name or IP address of a replication host
Description
Use the provision utility to change a host name or IP address in the SharePlex configuration.
The SharePlex processes rely on the host names or IP addresses of the source and target machines to route data properly. The provision utility enables you to change host names or IP addresses within an active SharePlex instance, without reactivating a new configuration.
Note: The provision utility does not change anything in the database. It only affects SharePlex internal objects.
Supported databases
All databases supported by SharePlex on all supported platforms
Guidelines for using provision
- provision is only valid for SharePlex version 6.1.1 and above.
- (SharePlex 7.0.2 only) If provision is being used because the host name of a machine changed, contact Quest Support to request a new license. Otherwise SharePlex will not start after the change.
-
(SharePlex 7.0.2 only) Add the following parameter to the param-defaults file before you run provision:
SP_CFP_DEBUG I live int() 0x00000000
-
If running SharePlex on an AIX machine, set EXTSHM before running provision.
export EXTSHM=ON
-
Run provision on all of the machines in the SharePlex configuration. Each machine can reference the IP addresses of all the other machines.
Run provision
- Stop sp_cop. If sp_cop is running, provision will fail. Note: provision prevents sp_cop from being started while it is running.
-
Using the command line of the operating system, run provision from the SharePlex util sub-directory of productdir with the following syntax:
provision -f old_name[:old_ipaddress] -t new_name[:new_ipaddress] [-p port] [-n]
provision -h <new hostid> [
-p <port>]
-n
| -f old_hostname[:old_ipaddress] |
- -f is required and represents "from."
- old_hostname is the old (current) host name.
- old_IPaddress is the old IP address. Use if the IP address cannot be obtained from the network.
|
| -t new_hostname[:new_ipaddress] |
- -t is required and represents "to."
- new_hostname is the new host name.
- new_IPaddress is the new IP address. Use if the IP address cannot be obtained from the network.
|
| -p port |
For Windows systems, specifies the port of the SharePlex instance for which provision is being run.
(You can run the "-p" port provision only on the Windows system.) |
| -n |
Runs provision without actually making any changes. Generates a report on the changes that provision will make.
Important! The best practice is to run provision with -n first, to make certain you agree with the potential changes, then run it without -n to make the changes. |
| -h new_hostID |
- -h is required and represents changing host ID or replacing host ID
- new_hostid is the new IP address
|
| -i |
-i is required and represents host information |
Example:
provision -f oldname -t newname -n
provision -h newid -n
provision -i
- View the event log to view every change that was made. If the provision run fails or you do not agree with the changes that were made, you can undo them by running the undo_provision script. See Undo changes made by provision .
Undo changes made by provision
The provision utility creates an undo_provision script that can be used to restore the host names and IP addresses to their previous state. Run the undo_provision script from the util subdirectory of the SharePlex product directory. There are no input arguments to this script.
Known issues
The following may occur but do not affect the integrity of the replication environment:
- The provision utility does not change the active configuration file. This means that the configuration file no longer represents the current state of replication after provision is run. If you need to run the compare config command, or if you decide to reactivate the configuration, update the host name or IP address in the configuration file first.
- If an Export or Import error occurred when SharePlex connected to a machine before the name or address was changed, the error status persists and cannot be cleared.
- If the new or changed machine is a source machine, provision generates new routing information, but the Read process may still have the old routing in its cache. When you start sp_cop, Read might generate a warning that the stored IP address does not match the one for the machine. You can ignore this error.
- After provision is run for a source host, it might not update the "hostname" column in SHAREPLEX_ACTID table with the new host name details. If that column is not correctly updated, you must update the SHAREPLEX_ACTID table manually to specify the new host name. This is only required if the name change affected a source machine.
Set the SharePlex port number
The SharePlex processes use TCP to communicate with each other between different systems and uses UDP to communicate within a system. The default TCP and UDP port numbers for SharePlex are both set to 2100 at the time of installation. For some deployments of SharePlex you may need to change the TCP or UDP port numbers.
Before selecting a port number, review the following points:
- If your replication strategy requires multiple instances of sp_cop on a system, you must set a unique port number for each one. For more information, see Run multiple instances of SharePlex.
- When an non-default port is required, the same number must be used for both the TCP and UDP ports, and it must be used for the TCP and UDP ports of all other instances of sp_cop that are involved in the same replication configuration. If the ports are different, sp_cop on one system cannot connect to the sp_cop on another system to send or receive messages and data.
- On the Windows platform, SharePlex permits a maximum of 64 port numbers (SharePlex instances) on one system.
Supported databases
All databases supported by SharePlex on all supported platforms
Set the SharePlex port on Windows systems
On Windows systems, SharePlex port numbers are stored in the Windows Registry. If it becomes necessary to change a port number, this is the SharePlex entry location:
\HKEY_LOCAL_MACHINE\Software\Wow6432node\Quest Software\SharePlex.
- Log onto Windows as a SharePlex Administrator using your system password and user name. Your user name must be assigned to the SharePlex Admin group.
- Run the SpUtils utility.
- Select the SharePlex Services tab.
- Under Port, select the port number for the instance of SharePlex whose port you want to change.
- Under SharePlex Service Status, click Stop.
- Click Close.
- From the Start menu, select Run.
- In the Run dialog box, type regedit to open the Registry Editor.
- In the Registry Editor, under \HKEY_LOCAL_MACHINE\Software\Wow6432node\Quest Software\SharePlex, right click the current port number, then select Rename.
- Replace the highlighted port number with the new number.
- Click the new port number to highlight it.
- In the Name column of the right-hand pane, right-click the SP_SYS_VARDIR entry that is associated with the new port number, then select Modify.
- In the Edit String dialog, change the port number (only the port number) in the path to the new port number, then click OK.
- Exit the Registry Editor.
- In the Windows file explorer, navigate to the variable-data directory for which you changed the port number (the one whose name still shows the old port number).
- Right click the name, and then use the Rename command to change only the port number in the name to the new port number.
- Run the SpUtils utility, then select the SharePlex Services tab.
- Under Port, select the new port number.
- Under SharePlex Service Status, click Install to establish the SharePlex service under the new port.
- After Current State shows that the service is installed, click Start to start the service.
Apply an Oracle application patch or upgrade
Apply an Oracle application patch or upgrade
This chapter contains procedures to follow when you need to apply an application patch or upgrade and there is an active replication configuration. These procedures apply to Oracle databases.
Contents
