Database Administration (MOSC)

MOSC Banner

Forcibly using same password

edited Sep 27, 2013 9:16AM in Database Administration (MOSC) 3 commentsAnswered
hi all, we have a requirement to use the same old password (test1234) after refreshing the datatabase but due to user profile in place I cannot reuse that password. But we have to reuse it. Is there a way I can reuse that same old password and not altering the user profile?

SERVICE_PROFILE                PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
SERVICE_PROFILE                PASSWORD_REUSE_TIME              PASSWORD UNLIMITED
SERVICE_PROFILE                PASSWORD_REUSE_MAX               PASSWORD 6
SERVICE_PROFILE                PASSWORD_VERIFY_FUNCTION         PASSWORD VERIFY_PASSWORD_FUNCTION
SERVICE_PROFILE                PASSWORD_LOCK_TIME               PASSWORD UNLIMITED
SERVICE_PROFILE                PASSWORD_GRACE_TIME              PASSWORD 10

I've changed the password over 10 times in 10 minutes but when I try going back to test1234 I get ORA-28007 error. Could you please tell how can I revert back to old password of test1234? We are on 11.2.0.3.0.

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