Changing SYS password in oracle 19c and expiry date does not update?
Hello,
We are running Oracle 19c RAC as a 2 node cluster with a 2 node physical standby all on RedHat 8.2.
The SYS password shows the expiry date as 03-JAN-2022 and I understood now with physical standbys, we did not have to worry about password file needing to be copied, but when I reset the password for SYS, the expiry date stays the same.
I am changing the password using "alter user" but wondering whether I should be changing it using orapwd? and by using orapwd it will update the expiry date?
Anyone else experienced this with the expiry_date and what is the correct method to update the SYS password.