This content has been marked as final. Show 23 replies
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,
sir...change the password of user first....
I have been changed my user password.And recompiling the form with nes password.The same error lands.
try to simple login of user username/password@database_name.
post the output.
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.
try to select something from above table....and check if you are getting same error....
yes i's giving same error when i am exceuting the following query
WHERE pan_num IS NOT NULL
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
what error you are talking about ?
ORA-28011: the account will expire soon; change your password now-Post more information , COPY & PASTE what you do ?
-you don't even Post Query output that i post it before .
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"
you need sys or system account user or sysdba privileged user to run the alter profile query.
SQL> SQL> SQL> conn system/oracle@xe Connected. SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. SQL>
ORA-01031: insufficient privilegesdon't change it on the same user, as i see guys here answered you
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"