Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

Incorrect Oracle user password in Service Agent (SA) 2.0

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

Version history
Revision #:
1 of 1
Last update:
‎06-22-2009 03:33 PM
Updated by: