Problem in SAP Console connection - yellow only

[Former Member]

Hi Guys

i change the password of SAPC11 at SQL> prompt, alter user sapc11 identified by 123xyz, when i come back and connect the SAP Console, its not work its become yellow. i think i got some authentication problem due to change of password in Oracle, is there any body help me out, how to set the password at the console again

thanx in advance

[Former Member · Accepted solution]

Hello,

It is not always safe to change sap schema id password via sql.As this password has to be stored in SAPUSER table where from the work process makes a SELECT against the SAPUSER table and reads the password of SAP<SCHEMA-ID>. Then the work process connects with username SAP<SCHEMA-ID> and the password retrieved from the table SAPUSER. In case of any deviation connection cannot be established and the work process stops with an error.This causes u the prob.

Try resetting the password again via brtools.

In the sap server run BRTOLS from cmd prompt then proceed as follows

Brtools----->Choose Additional Functions--->Choose Change Password of DB user

Enter choice 2(Database User/Password)

In user prompt give sapc11 and in password prompt put the password u had changed earlier ie abc123.

Then enter c (for continue) u will be prompted for the new password

When u put the new password it wont be displayed in the prompt just type

Complete the entire guided process.

Hope this resolves your prob.

Dont forget to award points if resolved.

Regards

[Former Member]

New installation