SQL> conn / as sysdba
Connected.
SQL> @?\rdbms\admin\utlpwdmg.sql

Function created.


Profile altered.

SQL> select profile, resource_name, limit from dba_profiles
  2  where resource_type = 'PASSWORD';

PROFILE    RESOURCE_NAME                    LIMIT
---------- -------------------------------- ------------------------------
DEFAULT    FAILED_LOGIN_ATTEMPTS            3
DEFAULT    PASSWORD_LIFE_TIME               60
DEFAULT    PASSWORD_REUSE_TIME              1800
DEFAULT    PASSWORD_REUSE_MAX               UNLIMITED
DEFAULT    PASSWORD_VERIFY_FUNCTION         VERIFY_FUNCTION
DEFAULT    PASSWORD_LOCK_TIME               .0006
DEFAULT    PASSWORD_GRACE_TIME              10

7 rows selected.

SQL> create user test_user identified by test_user;
create user test_user identified by test_user
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password same as or similar to user


SQL> alter profile default limit PASSWORD_VERIFY_FUNCTION null;

Profile altered.

SQL> create user test_user identified by test_user;

User created.

SQL> @c:\oracle\product\10.1.0\db_1\rdbms\admin\utlpwdmg.sql

Function created.


Profile altered.

SQL> alter profile default limit password_verify_function verify_function;

Profile altered.



SQL> create user scott1 identified by scott1;
create user scott1 identified by scott1
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password same as or similar to user


SQL> create user scott1 identified by scott;


SQL> alter profile default limit password_verify_function null;

Profile altered.


---after edit password_verify_function to NULL i was able to reset scott password.

SQL> alter user scott identified by tiger1;

User altered.

SQL> alter user scott identified by tiger;

User altered.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> conn test_user/test_user
Connected.
SQL> -- As you can see TEST_USER already exists in the database.
SQL> conn / as sysdba
Connected.
SQL> @?\rdbms\admin\utlpwdmg.sql

Function created.


Profile altered.

SQL>  select profile, resource_name, limit from dba_profiles
  2   where resource_type = 'PASSWORD'
  3   and profile = 'DEFAULT';

PROFILE                        RESOURCE_NAME                    LIMIT
------------------------------ -------------------------------- -------------------------
DEFAULT                        FAILED_LOGIN_ATTEMPTS            3
DEFAULT                        PASSWORD_LIFE_TIME               60
DEFAULT                        PASSWORD_REUSE_TIME              1800
DEFAULT                        PASSWORD_REUSE_MAX               UNLIMITED
DEFAULT                        PASSWORD_VERIFY_FUNCTION         VERIFY_FUNCTION
DEFAULT                        PASSWORD_LOCK_TIME               .0006
DEFAULT                        PASSWORD_GRACE_TIME              10

7 rows selected.

SQL> alter user test_user identified by testpass;
alter user test_user identified by testpass
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20003: Password should contain at least one digit, one character and one punctuation


SQL> alter profile default limit PASSWORD_VERIFY_FUNCTION null;

Profile altered.

SQL> alter user test_user identified by testpass;

User altered.

SQL> conn test_user/testpass
Connected.
SQL> -- Existing user can change password that would normally fail verify_function
SQL> alter user test_user identified by test;

User altered.

SQL>