Shulou(Shulou.com)06/01 Report--

Remember to set the password validity period after oralce11g installation, otherwise a warning will be reported to ORA-28002. The solution is as follows:

1. Check the proifle of the user, which is usually default: select username,PROFILE from dba_users;2, view the password validity setting of the specified profile (such as default): select * from dba_profiles s where s.profilevalidity default default and resource_name='PASSWORD_LIFE_TIME'; 3, change the password validity period from the default 180d to "unlimited": alert PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.