Oracle user password Problems

Oracle user password Problems

Oracle users seldom pay attention to their passwords. Generally, the password expiration time is set to never expire after the database is installed, but an error occurs when autotrace is enabled, it attracted my attention on user passwords. The environment we encounter at work is very different. You cannot know what the next customer's environment looks like, and you cannot know the database installed by the DBA of the database you are using, this is a difficult and fun part of your work. The diversity of production environments is also one of the driving force for us to learn. The following introduces three considerations for Oracle user passwords:

1. the user password is about to expire, so autotrace cannot be enabled

If your password is about to expire, you will receive the following prompt when logging on to the database:

ERROR:

ORA-28002: the password will expire within 7 days

Of course, the password has not expired yet, and the user can still log on to the database after receiving the error message. However, if you receive a prompt that the password is about to expire, it will be a problem if you want to enable autotrace.

SQL> conn darren/darren

• ERROR:
• ORA-28002: the password will expire within 7 days
• Connected.
• SQL> set autotrace on;
• ERROR:
• ORA-28002: the password will expire within 7 days

SP2-0619: Error while connecting
SP2-0611: Error enabling STATISTICS report

The prompt that the password is about to expire indicates that the PASSWORD_LIFE_TIME parameter in profile is definitely not set to unlimited. You can view dba_profiles for verification:

1. SQL>