1- Verify the Oracle_SID by viewing the oratab file.
2- Shut down sp_cop on the source and target systems.
3- Run ora_chpwd from its location in the bin sub-directory of the SharePlex product directory.
$ /product_dir/bin/ora_chpwd
4- You will be prompted for the ORACLE_SID of the instance for which you want to change the SharePlex password. SharePlex reads the current SharePlex user’s environment and displays that user’s ORACLE_SID as the default. Press Enter to accept the default, or type the correct ORACLE_SID.
Please enter the SID where SharePlex is installed [np73]:
5- You will be prompted to enter the Database user that with 'alter user' privilege.
In order to change the password for the SharePlex user account,
we must connect to the database as user with 'alter user' privilege.
Enter a user with 'alter user' privilege : <DB User with 'Alter User' privilege>
Enter password for entered account, which will not echo :
6- You will be prompted for the name of the existing SharePlex user. There is no default for this step. You must enter the name of the existing SharePlex user. SharePlex reads the connections.yaml / paramdb file from <vardir>/data, depending on the SharePlex version to ensure that the name is valid.
Enter the current username for SharePlex user:
7- You will be prompted for the new password for which must have a valid Oracle password format. The password is not echoed.
Enter new password for SharePlex user:
8- You will prompted to enter the new password again to confirm it. Re-type it exactly as you typed it before.
Re-enter password for SharePlex user:
The utility displays the status of the change and then notifies you when the password has been successfully changed in Oracle and in the SharePlex connections.yaml / paramdb file. You are returned to the UNIX prompt.
Changing SharePlex parameter database...
SharePlex password change completed successfully