以下の手順でパスワードを変更してください。
1. SharePlex を停止します。
2. ora_chpwd コマンドを実行して新しいパスワードを設定します。
< 実行例 >
$ ora_chpwd
This program allows you to change the password of the
SharePlex user account needed to run Oracle replication.In response to prompts, a carriage return will choose the
default given in brackets. If there is no default, a reply
must be entered.
Please enter the SID where SharePlex is installed [orcl] : orclIn order to change the password for the SharePlex user account,
we must connect to the database as DBA user.Enter a DBA user name : system
Enter password for the DBA account, which will not echo :connecting--This may take a few seconds.
Enter the current username for SharePlex user : splex2300
Enter new password for SharePlex user :
Re-enter password for SharePlex user :Changing SharePlex connection database . . .
SharePlex password change completed successfully.
$ ora_chpwd
This program allows you to change the password of the
SharePlex user account needed to run Oracle replication.
In response to prompts, a carriage return will choose the
default given in brackets. If there is no default, a reply
must be entered.
Please enter the SID where SharePlex is installed [orcl] : tnsalias
In order to change the password for the SharePlex user account,
we must connect to the database as user with 'alter user' privilege.
ALTER USER権限のあるユーザーを使用します。
Enter a user with 'alter user' privilege : system
Enter password for entered account, which will not echo : 指定したユーザーのパスワード@tnsalias (つなげて入力します。ただし入力は表示されません)
connecting--This may take a few seconds.
Enter the current username for SharePlex user : splex2400
Enter new password for SharePlex user : 新しいパスワード
Re-enter password for SharePlex user :
Changing SharePlex connection database . . .
SharePlex password change completed successfully.
3. SharePlex を起動します。
Windows 環境では以下の方法で変更してください。
1. パスワードを変更します。
< 実行例 >
sp_ctrl> connection o.orcl set user=splex2100
sp_ctrl> connection o.orcl set password=xxxxxx
2. SharePlex を停止します。
3. Oracle 側で SharePlex 用ユーザーのパスワードを変更します。
SQL> alter user splex2100 identified by xxxxxx;
4. SharePlex を起動します。
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center