[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

Password expiry notification in Oracle doesnt get cleared of the application

Hi,

I hav a java web application that runs on websphere application server . We recently migrated to Oracle 11 . By default oracle 11 id expires at a period of time and we changed this setting . It works fine when we login using Toad or write small piece of code and test connectivity but the web application throws the error . We bounced the webspehere instance also but still throwing the same error . We did redeploy the ear and bounce the server but still the issue exists . Please advice
0
FranklinRaj22
Asked:
FranklinRaj22
  • 6
  • 5
1 Solution
 
slightwv (䄆 Netminder) Commented:
How did you disable it?

Check the login profile of the user used by websphere.  Make sure it is disabled in that profile.
0
 
FranklinRaj22Author Commented:
she altered the id to have a non expiring password .
And the application running on webspehere is using the same id that we use to connect to the DB via Toad/SQL plus directly .
I also wrote  a small connectivity program using that id and connected to the database and it was successful . The application on websphere is the only one that causing the error , its all running on a unix box .
0
 
slightwv (䄆 Netminder) Commented:
Can you post the exact error from websphere?

>>she altered the id to have a non expiring password .

How?

Do you have DBA level access to the database?

If so can you post the results of:
select * from dba_profiles where resource_name like 'PASSWORD_LIFE_TIME';
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
FranklinRaj22Author Commented:
This is the error i receive - RequestController is my servlet
[WebContainer : 1] - [ RequestController::service ] - INVOCATION_ERROR:An Error
occurred while trying to process the request (ORA-28002: the password will expir
e within 3 days
)

I do not hav DBA access , ill look it up for you soon though
0
 
slightwv (䄆 Netminder) Commented:
>>the password will expire within 3 days

I believe this is controlled by the profile parameter: PASSWORD_GRACE_TIME
0
 
Geert GruwezOracle dbaCommented:
options to permanently resolve this:
alter the defautlt profile and set the password_grace_time to unlimited

or create a new profile with the password_grace_time unlimited
and assign the new profile to that user

to resolve your problem now (but it will return after 6 months)
reset the user password (you can use the values if you don't know it anymore :) )

select name, password from user$ where name = 'youruser';

enter the value of the password in below alter to reset the password and grace_time
alter user youruser identified by values 'passwordvalue';
0
 
FranklinRaj22Author Commented:
Guys,

I hav mentioned this issue is resolved , I mean we are able to login via any client or any code written in any language and are able to connect successfully. Only my web app which runs on a websphere application server hosted on a Unix box causes this issue .
0
 
slightwv (䄆 Netminder) Commented:
>>Only my web app which runs on a websphere application server hosted on a Unix box causes this issue .

It's possible the web app is using some different connection layer that might still be receiving the warning that you are in your grace period.  Maybe a different driver version?

Verify the value of PASSWORD_GRACE_TIME in the database.

Either that or the websphere app is not connectiong to the database you think it is.
0
 
FranklinRaj22Author Commented:
SQL>  select * from dba_profiles where resource_name like 'PASSWORD_LIFE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD
UNLIMITED
0
 
slightwv (䄆 Netminder) Commented:
Now what about PASSWORD_GRACE_TIME?
0
 
FranklinRaj22Author Commented:
Thank u for ur time. I go this resovled . I pulled out the drivers and added thgem in the libraries,bounce the unix box and the websphere instance and it worked .
0
 
FranklinRaj22Author Commented:
None of the suggestion given by the experts help and something I tried helkped
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now