OPS$<SID>ADM password expire

[Former Member]

Hi,

We are receiving warnings in system that our User OPS$<SID>ADM password is going to expire.

USERNAME EXPIRY_DATE PASSWORD

-

---

-

---

-

---

OPS$<SIDADM>ADM 12-JAN-11 EXTERNAL

As I understand User is Externally identified so I was expecting that if I change password of User <SID>ADM at OS level,

On database level OPS$ User should be Updated but it did not get update and still its expiry date is same.

So please suggest how can we change its password.

Shivam

[Former Member]

We can not reset password of OPS$ SO we have to set password never expires.

[Former Member]

Hi Shivam,

From SQL prompt execute the below command

SQL>update OPS$<SAPSID>ADM.SAPUSER set PASSWD='<new password>' where USERID='SAPSR3';

You can do the same from BRTOOLS also

Regards,

SBK

[Syamkriz]

Depending on your OS use either 50088 or 361641 . There is a section called changing the OPS user password towards the end of the note.

[Former Member]

Hi,

The users <sid>adm and OPS$ are different users. Changing the password for <sid>adm would not effect

OPS$ user.

Check these two notes, they might help you

400241, 562863

Regards,

Vishnu