Error when changing password of NW J2ee's secure store and Oracle sqlplus

[Former Member]

Hi all,

I am wondering on the following:

Current setting:

I have "old_password" for J2ee configtool's secure store.

I have "old_password" for Oracle's sapsr2 user inside Sqlplus.

When I change the password for all 3 place from "old_password" to "new_password", I am not able to connect to configtool. I am also not able to start the Portal service; with logfile error "invalid user/password"

If I change the password back to "old_password", I can connect to configtool as well as start the service.

Snote and forumers (google) mention that update configtool's secure store and "alter user sapsr3" for Oracle database is all I need to change password.

Have I miss out some step in order to change the password for my Enterprise Portal?

Thank you.

Regards

[sunny_pahuja2 · Accepted solution]

Hi,

For portal your schema owner should be SAPSR2DB not SAPSR2. Try with SAPSR2DB, it should work.

Thanks

Sunny

[Former Member · Accepted solution]

Hi Sunny,

Ya, it's Sapsr2db. I didn't wrote it down in the forum.

The problem happens to SAPSr3DB (actual ID)

Regard

p/s:

Could it be that I need to click on the ADD button before saving?

My action was clicking on the J2ee line "jdbc/pool/EP6/Password".

Then change the field "Value" to 'new_password"

Follow by Menu "File" -> "Save".

Do I need to click on the "Add" button before saving?

[sunny_pahuja2 · Accepted solution]

Hi,

Click on password field. Below you will get Key and Value field.

Change your new password in value field then click on add. After that save it and then restart.

Thanks

Sunny

[Former Member · Accepted solution]

Hi all,

I finally manage to try the solutions provide, but I am still not able to change the password.

What happen is that:

1. I change the password in configtool.

2. I click "SAVE" and "exit"

3. When I try to enter configtool again, I'll get error message. When I switch the password back to the old password, I would be able to connect to configtool.

Please assist/advice.

Thank you.

[Former Member · Accepted solution]

Hi,

Login to Configtool and provide the old password.

Now login to portal user administration.

Change the password of user "administrator" to "new password".

Then login to configtool again and change the password to "new password".

Also change the SDM password to "new password". Otherwise you will not be able to deploy.

Cheers....,

Raghu

[Former Member · Accepted solution]

edit: never mind, found the meaning of SDM.

but the command below, is it usable?

For Windows OS:

Open a command prompt and navigate to the folder <Drive>:\usr\sap\DP1\JC21\SDM\program

Execute the below commands:

sdm jstartup "mode=standalone"

sdm changepassword "newpassword=<Enterthenewpassword>"

sdm jstartup "mode=integrated"

StartServer.bat

Edited by: Sek Yao Ooi on Dec 7, 2009 9:21 AM

[Former Member · Accepted solution]

Hi,

Yes..these commands should serve the purpose.

Cheers...,

Raghu

[Former Member · Accepted solution]

Hi Rahgu,

Thank you.

The checklist:

1. sqlplus /no log " alter user xxx identified by (password)"

2. configtool "secure store"

3. command prompt "SDM password"

4. Netweaver User Administration's user "adminstrator"

Do let me know if I've miss out anything. I'm planning to re-try this comming weekend.

Thank you

[Former Member · Accepted solution]

Hi,

If you are changing oracle password, then update the same in the configtool secure store (JDBC Pool Password).

Rest seems ok.

Cheers...,

Raghu

[Former Member · Accepted solution]

Hi all,

I have changed the password as per checklist (above) and as suggested. It is now changed to new_password and is working correctly.

Thank you, everyone