Database Administration (MOSC)

MOSC Banner

ora-01979 on password protected role after upgrade from 11g to 12c

edited Apr 5, 2018 5:01AM in Database Administration (MOSC) 1 commentAnswered

Hi,

After upgrading an Oracle 11.2.0.4 database to 12.2.0.1 we get ora-01979 (password for role is missing or invalid). On 11g this didn't happen.I did check the sys.user$ table and only the password column is populated for the role. Spare4 is empty. I did try an alter role <rolename> identified by values 'xxxxxx';  and even a drop/create role. As we don't know the unencrypted password we have to use by values. But the ora-01979. I think the role was created on a pre-11g database (probably10g).

I did search on Metalink for issues with password protected role after an upgrade from 11g to 12c but could not find antything relevant. A google hit was this one:

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