disable password verify function in oracle

1–2 minutes

ISSUE:
You may fail to run some oracle provided sql scripts because of user creation failure. the creation failure is because provided password didnt’ pass verify function.

CAUSE:
default password provided in oracle script doesn’t satisfy your password verify function in default profile

SOLUTION:
alter profile default limit password_verify_function null;
run the script
alter profile default limit password_verify_function your-password-verify-function-name ;