Changing SYS and SYSTEM
When SYS or SYSTEM passwords are changed it does not effect ongoing replication because the SYS and SYSTEM passwords are used only when the *-pre-all.sh and *-all.sh scripts are run. Once these scripts is executed and the replication is up and running, SYS and SYSTEM users are not used by Dbvisit Replicate at all.
Neither of MINE, APPLY nor FETCHER stores SYS and SYSTEM passwords therefore nothing has to be done when their passwords are changed.
Changing Dbvisit Replicate schema password
Dbvisit Replicate communicates with the source and target database through the Dbvisit Replicate user created during execution of *-all.sh script. By default this is "dbvrep".
To change the password for the Dbvisit Replicate schema:
1. Stop MINE/APPLY/FETCHER process.
2. In Dbvisit Replicate command console, execute
ENGINE ENCRYPT newpasswd
This will return an encrypted value of newpassword.
3. Edit the DDC files for MINE/APPLY/FETCHER and set the new password in line
memory_set DDC_PASSWORD xxxxxx
4. Start the console without connecting to the database
5. Set new encrypted password for MINE/APPLY/FETCHER process.
set MINE.MINE_PASSWORD xxxxxx set APPLY.APPLY_PASSWORD xxxxxx set MINE.DDC_PASSWORD xxxxxx set APPLY.DDC_PASSWORD xxxxxx
If there are more processes, then do this for all processes.
When dbvrep password is changed on source then set MINE.MINE_PASSWORD to encrypted password value or FETCHER.FETCHER_PASSWORD if FETCHER is used. If password of dbvrep user is changed on target database then set APPLY.APPLY_PASSWORD to encrypted password value.