Today i'm facing this error while logging in one of my 11g production database system account. If you don't wish to receive this kind of error and you want set password expiry to unlimited, here is the simple steps you can fix this is error.
step1:-logging in as system account. then check the profile name of the particular account.
sql>select profile from dba_users where username='USERNAME';
the above query gives the profile name of your user account.
step2:-log in to that particular account (which account you are receiving error)
sql>password
type the above command after logging in to that particular account, it will asks the old password and new password and finally it will return (password changed).
step3:-check the resource password_life_time=value in dba_profiles
sql>select * from dba_profiles where resource_name like '%PASSWORD_LIFE_TIME%';
the above query gives the value of your password_life_time resource, if it set to any numeric value then change it to unlimited.
step4:-set the particular profile password_life_time to unlimited.
sql>alter profile default limit password_life_time unlimited;
step1:-logging in as system account. then check the profile name of the particular account.
sql>select profile from dba_users where username='USERNAME';
the above query gives the profile name of your user account.
step2:-log in to that particular account (which account you are receiving error)
sql>password
type the above command after logging in to that particular account, it will asks the old password and new password and finally it will return (password changed).
step3:-check the resource password_life_time=value in dba_profiles
sql>select * from dba_profiles where resource_name like '%PASSWORD_LIFE_TIME%';
the above query gives the value of your password_life_time resource, if it set to any numeric value then change it to unlimited.
step4:-set the particular profile password_life_time to unlimited.
sql>alter profile default limit password_life_time unlimited;
hope it will works.
No comments:
Post a Comment