Hello Sujatha,

You just need to change the password on ar.conf file on th  “ Db-password:

“ in this case this password exists but is encrypted so you need to remove

the value and put the new value for the new password…

Regards

Joel Rosete

De: Sujatha forums@developer.bmc.com

Enviado el: lunes, 23 de enero de 2012 13:26

Para: Joel

Asunto: DB Password Change New message on BMC

Communities

BMC Communities <https://communities.bmc.com/communities/index.jspa>Thread:

"DB Password Change"

created by Sujatha <https://communities.bmc.com/communities/people/Sujatha>in

BMC Remedy AR System - View the full

discussion<https://communities.bmc.com/communities/message/222660#222660

Hello Sujatha,

If this line does not exists you can set on it, just be careful to write

like this ,for example:

Db-password: AR#Admin#

You write this below the line that is like this:

Db-user:

Regards

Joel Rosete

De: Sujatha forums@developer.bmc.com

Enviado el: lunes, 23 de enero de 2012 13:39

Para: Joel

Asunto: Re: DB Password Change New message on BMC

Communities

BMC Communities <https://communities.bmc.com/communities/index.jspa>Thread:

"Re: DB Password Change"

created by Sujatha <https://communities.bmc.com/communities/people/Sujatha>in

BMC Remedy AR System - View the full

discussion<https://communities.bmc.com/communities/message/222663#222663

Hi Sujatha,

As Joel Suggested, You just need to add "Db-password:New-Password" in ar.cfg/ar.conf.

You can also take help of BMC Remedy Action Request System: Database Reference.

Regards,

Jay

You dont have to directly modify the configuration file.

You can set the DB password in the Database tab of the Server Information form.

Yes like Ivarela says is right too, the thing in here is that like Jay

says, they would need to reconnect it, so in this case I would think that

the server is down and the password has changed… but if the server is up

you can you can use the way like Ivarela says.

Regards

Joel Rosete

De: lvarela forums@developer.bmc.com

Enviado el: miércoles, 25 de enero de 2012 9:05

Para: Joel

Asunto: Re: DB Password Change New message on BMC

Communities

BMC Communities <https://communities.bmc.com/communities/index.jspa>Thread:

"Re: DB Password Change"

created by lvarela <https://communities.bmc.com/communities/people/lvarela>in

BMC Remedy AR System - View the full

discussion<https://communities.bmc.com/communities/message/223143#223143

Hello Sujatha,

Exactly is not recommend it to change this password from Database side, but the tips that you have received is in case your dba had been perform the change from database side.. if he still does not apply this change you can suggest to change this password from de Configuration Server from ARS Server side.

Regards

Joel Rosete

Also think that other products connect directly to the database, and that the password is not propagated from ARS.

For instance, Analytics (BOXI) or Dashboards.

Regards,

Jose Huerta

http://theremedyforit.com/

Hi Sujatha,

I hope your issue is resolved by now. Still, let me share this potential solution for the community's benefit.

'ARERR [552] Failure during SQL operation to the database : ORA-28221: REPLACE not specified' error may be because the aradmin (DB account) does not have the ALTER USER privilages on the database

Modify the permissions of this account from the DB (ask your DBA) and re-attempt to set the new password from the Server Information.(It worked in our environment). If your organisation has a security requirement not to have the ALTER privileges to the application accounts, revert to the original permissions after successfully resetting the password.

Cheers.

Arun

Thanks Arun,

It will be helpful for the Remedy Admin who are willing to change their DB Password from AR System.

Regards,

Jay

if DBA already change the password, how to encrypt it and then update it into ar.conf? Is there any Utility or tool to encrypt password?

According to ar.cfg or ar.conf options C-D - BMC Remedy Action Request System 8.1 - BMC Documentation

Specify the password in the ar.cfg file in clear text, which will allow the Remedy server to startup, then go into the Server information console and set it to the same value again through the interface and that'll replace it with the encrypted value.