Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center