ORA-28011: the account will expire soon; change your password now
i am facing this error at the the time of form compilation as per forum solution i tried but same error lands.
In my form Dblink is used when i comment that query in which the dblink is used the form run successfully.
But i want dblink query also when i have been fired this query or includind dblink query and compiling the form the errors came
What is the solution for that error[ORA-28011]?
In my form, code is as follow-
set emp_pan_no = (select pan_num
where pan_num is not null
and to_number(emp_num) = pf_num)
where emp_pan_no is null
and pf_num in (select to_number(emp_num) from sapsr3.zhrupdate@vhp_link);
Thanks & Regards,
its not error its consider as warning and inform your account will be expire if you don't change your password .
This warning related to your profile that set for user , you will find PASSWORD_LIFE_TIME that control with this warning .
Select Username , profile from dba_users
select RESOURCE_NAME,LIMIT from dba_profiles where PROFILE='<USER_PROFILE>' and RESOURCE_NAME='PASSWORD_LIFE_TIME';
i have been already set in the query as given by you
WHERE PROFILE='DEFAULT' AND RESOURCE_NAME='PASSWORD_LIFE_TIME';
my PROFILE = 'DEFAULT' & RESOURCE_NAME='PASSWORD_LIFE_TIME' & LIMIT Set as 'UNLIMITED'
same error lands.in my query dblink present is this issue came because of dblink as shown in previous msg.If i aomment that dblink query the form11g execute successfully.
What is the actually problem?.Please Suggest the wau out.
Thanks & Regards,
It's connect to the database with new password.My old database password was 'pf' i changed its to 'vlpf'
i.e. User name = 'pf'
Password = 'vlpf' .........(New Password)
Database = hrall
but still my error not getting solve.
the change password of sapsr3 user and try to run the query.
before changing check whether this password is not used by any script otherwise it get locked wth incorrect password attempts.
Edited by: Niket Kumar on Nov 29, 2012 3:18 PM
Hi i am using oracle 9i database for sapsr3 user
I cheked this query i got here output as - LIMIT = 180
how i will change LIMIT to 'UNLIMITED' IN Oracle 9i database for user sapsr3
Because when i executed below ALTER query for sapsr3 user for oracle 9i database
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
It's gives error as "ORA-01031: insufficient privileges"
Hi,I am executed the alter statement for 'system/manager@hrall_tcp' .The statment executed Successfully.but when i am compiling the form it's gives same error at the time of form compilation for user 'sapsr3' .the error comes at 'sapsr3.zhrupdate@vhp_link'.I am using in my form.
at the time of '.fmx' file generation it's gives error as- "ORA-28011: the account will expire soon; change your password now"