Disable Oracle Password Security

Sometimes if you run a tool that installs a software in you Oracle database it may report errors like ORA-28003 or ORA-20003 and related. In such a case it may be necessary to disable Oracle password security.

Use this to disable password security:

ALTER PROFILE "DEFAULT" LIMIT PASSWORD_GRACE_TIME 7
PASSWORD_REUSE_MAX unlimited 
PASSWORD_REUSE_TIME unlimited
PASSWORD_VERIFY_FUNCTION null;

However you should always turn it back on as soon as you finished with the work that required it to be disables:

ALTER PROFILE "DEFAULT" LIMIT PASSWORD_GRACE_TIME 7

PASSWORD_REUSE_MAX 10

PASSWORD_VERIFY_FUNCTION verify_function;