cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Incorrect Oracle user password in Service Agent (SA) 2.0

1004
Views
0
Helpful
0
Comments

Core Issue

Clients are receiving the 407 error response. Compare the given hash password in the message by the client to what is actually located in your Oracle database.

Resolution

Complete these steps to find a user password in the database:

1.  Login to the machine where Oracle is located as oracle user.

2.  Login to your schema via SQLplus as dsowner.

3.  Execute these SQL commands:

     SQL> select sub_id from subscriber where sub_uri like 'sub_uri';

     SQL>
select password from authenticationinfo where sub_id like 'sub_id';

For example:

     SQL>select sub_id from subscriber where sub_uri like 6135585793;

     SUB_ID

     ----------

     173790.001

     SQL>select password from authenticationinfo where sub_id like 173790.001;

     PASSWORD

------------------------------------------------------------

a1582d9891e887a75acbd79bd4be9cc5

Create
Recognize Your Peers
Content for Community-Ad