cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1060
Views
0
Helpful
0
Comments
TCC_2
Level 10
Level 10

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: