How to deal with oracle user password expiration

Oracle user password expired? It doesn't matter. The following describes how to deal with oracle user password expiration for your reference. If you are interested in this, take a look.

When learning oracle in the test environment, the oracle user password has expired. If you change the password, the system prompts that the verification fails. Because it is a test environment, you do not need to change the oracle user password frequently during the convenience period, the usage of profile is recorded as follows.

SQL> SELECT * FROM dba_profiles;

View the user's profile, which is generally DEFAULT

SQL> select * from dba_profiles where resource_type = 'Password ';

SQL> alter user lh identified by lh;

Alter user lh identified by lh

ORA-28003: password verification for the specified password failed
ORA-20001: Password same as or similar to user

Cancel password management:

SQL> alter profile DEFAULT limit Unlimited;
For example:
SQL> alter profile DEFAULT limit password_reuse_time unlimited;

Stop password verification function:

SQL> alter profile DEFAULT limit password_verify_function null;

Create a user-specific profile:

Create profile test LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU _ per_call 3000
CONNECT_TIME 45
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL 1000
PRIVATE_SGA 15 K
COMPOSITE_LIMIT 5000000;

To change:

SQL> alter profile test limit PASSWORD_LIFE_TIME 60;

Change User profile

How to query Oracle user session information

Permission management for Oracle Super Users

Provides you with an in-depth understanding of Oracle system services.

Default ORACLE user and password

Implementation of oracle multi-column subquery