We are particular about the OCI ( can be plugged with D2k Application) that checks whether the given password already exists in the database within this reuse time period before the ALTER USER statement is executed. 'password verification for the specified password failed' 'the password will expire within %s days' If we pass the old/new password and username, it should return errors as follows.

The '' because sqlplus itself sees that as the terminator. Certainly the '' and '' characters fall into this category. There are several special characters that become problematic when used in a password, because the OS (or other intervening software) uses those characters as an indicator. Is there any OCI that helps us resolve this. The best way to fix is change the password. we come to know this error after executing the Batch job. The user does not know while enter the password on the screen. We have password policy like the password should be repeated after 400 days(PASSWORD_REUSE_TIME). When we enter the new password in the front-end, the new password information are stored and executed - later (during night) - by Batch Job. In our Environment, the ORACLE users password can be change using FRONT-END application( Oracle D2K). I'd have to find a password that hashed to foobar - but I won't since foobar is too short alter user ops$tkyte identified by foobar Someone wanted to lock my account (typically from before there was a lock account) so they put a string in place of my hashed password. I don't have a password, they just plop external in there for alter user ops$tkyte identified by values 'foobar' User select password from dba_users where username = user Someone set it that way to effectively 'lock' the account OR the words you saw were 'consistently' represented and identified some other authentication scheme.įor alter user ops$tkyte identified externally

Oracle dba reset password quote