Skip to main content

Search

Welcome to Tibero GTS!

ProSync User Password Change Guide When Using ProSync

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.


 

 

 

 

Related to