Document Type | Technical Information
Category | Administration
Applicable Product Version | 7FS02
Document Number | PADTI001
Overview
This guide explains how to reflect a password change by modifying the Wallet file when you need to change the ProSync user password in Tibero due to security vulnerability measures or other reasons.
Method
Password Change Procedure
1. Stop ProSync
Although it is possible to change the password while ProSync is running, upon reconnecting the session later, a password error may violate restrictions such as user profiles.
2. Change ProSync User Password in Tibero
SQL > alter user [username] identified by '[password]';
3. Change Permissions on the .wallet File for the OS ProSync User
- Path: $PRS_HOME/var/$TOP_ID/.wallet
- Permissions: Set to at least 600 (e.g., rw-------)
$ chmod 600 $PRS_HOME/var/$TOP_ID/.wallet
4. Run prs_cred
- Command: prs_cred [NEW_PASSWORD] [WALLET FILE path]
$ prs_cred tibero123! /prosync/prosync4/var/prosync_test/.wallet
5. Start ProSync
Note
If you use a ProSync monitoring shell such as PMON, you must also reflect the changed password inside the shell.
If the same ProSync user account is used on both the Source and Target servers, the same change is required on both.