Oracle under ORA-28002 error handling

A recent Oracle alert on Nagios was received suddenly:

Critical-ora-28002:the password'll expire within 7 days

In the multi-data query that is the default account security policy under Oracle (default 180 days account password expires), 7 days before the expiry of the use of the account to connect Oracle with ORA-28002 error prompts, all you need to do is to reset the password to Oracle users. The operation is also simple:

[Email protected] ~]$ sqlplus/as sysdba #使用DBA账户系统身份验证SQL > SELECT username,profile from Dba_users; #查看用户的profile设置, the profile setting for the general user is defaultsql> SELECT * from dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name = ' Password_life_time '; #查看系统profiles中PASSWORD_LIFE_TIME设置, the user account created by default limit field is generally ' 180days ' sql> ALTER profile default limit Password_life _time UNLIMITED; #把Oracle默认的过期时间设置为永不过期SQL > ALTER USER username identified by Youpassword; #此时再重置一次快要过期的用户密码, User password can be consistent with the original, usually user password forgotten is also through the DBA account system authentication into Oracle to reset the user password

At this time with the user password of the ordinary user login to Oracle can be normal login, no ORA-28002 error prompt

Oracle under ORA-28002 error handling