Resetting 11g paswords as part of upgrade to 12.2.0.1c — oracle-mosc

Database Administration (MOSC)

MOSC Banner

Resetting 11g paswords as part of upgrade to 12.2.0.1c

edited Nov 29, 2017 10:39AM in Database Administration (MOSC) 9 commentsAnswered ✓

I am in the process of upgrading some 11.2.0.4g  databases to 12.2.0.1c and as part of the upgrade using dbua the 12.2.0.1 databases test for complex passwords.  Some of the schemas being upgraded have 10g 11g passwords flagged as needing revising.

I can set a password policy for new users/schemas and then force a password expiry  to make users reset their old passwords to the 12c format to resolve existing 'simple' passwords.  However when I tried this on a test schema the dba_users table still showed the password as being a 10g version so although the password had been reset (and met the complexity requirements) the dba_users table had not picked this up and still showed it as 10g.

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