Learn how to a build a cloud-first strategyRegister Now

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

Password grace period no longer generates ORA-28002

I am using Oracle Forms 9i, accessing an Oracle 10g database via an Oracle 10g application server.  Since our client-server days, our logon form has checked dbms_error_code immediately after the logon statement (NOT in an on-error trigger), looking for -28002, in order to warn the user that he is in the password grace period.  Apparently, this error is no longer getting trapped (don't know when that started), so our help desk is flooded with password reset requests.  Is there some other message number that I should be looking for?  We use the default message level in our forms, so I would think that warnings should show up as well as bona-fide errors.
Thanks.
0
mhartung
Asked:
mhartung
  • 4
  • 3
1 Solution
 
jrb1Commented:
Can you look for MESSAGE_CODE of  ORA-28002?
0
 
mhartungAuthor Commented:
I will give it a try. It will probably take me a day or so to get a dba to set an expiry date for me, so don't think that I am ignoring you if I don't reply for a couple of days.  Thanks.
0
 
mhartungAuthor Commented:
I'm back.  That didn't work.  I put in some displays, and both dbms_error_code and message_code were zero.  I thought that maybe it started with our upgrade to 10g, but when I pointed the form back to our 8.1.7.4 database, I got the same non-result.  Even connecting through SQL Plus no longer generates the message.  As a last resort, I can modify the form to check user_users and decide when the expiry date is close, but I'd really like to know what happened to ORA-28002...
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
jrb1Commented:
Just wondering...what does this return?

select limit
from dba_profiles
where resource_name = 'PASSWORD_GRACE_TIME';
0
 
mhartungAuthor Commented:
The limit is 3 for the profile that is assigned to my test user.  The expiry date for that user is April 15th (in the morning), so I was hoping that ORA-28002 would be generated when I connected today.  No such luck, though.  I was wading through MetaLink, and read that being in the grace period throws a warning, rather than an error (no where did a different number get mentioned, though), but I can't seem to get anything thrown at all.
0
 
jrb1Commented:
Yes, you are correct that it only throws a warning.  That's why I recommended looking for a MESSAGE_CODE.  I don't believe the grace period works that way, though.  If it expires on April 15th, they then have 3 more days past April 15th where they will receive the warning.  Not 3 days prior....the grace period is the period where their password has already expired, but they are allowed access.
0
 
mhartungAuthor Commented:
You are right -- I was confused on the grace period.  When the dba set the expiry date to yesterday and I connected today, I got the ORA-28002 message (in BOTH the 8i and 10g databases), and then the system set the expiry date to 3 days from today.  Then, to my great surprise, I also got a value in dbms_error_code in the form in both environments.  So it looks like my Production problem is a non-issue, resulting from the profiles getting reset to the defaults (unlimited) when the database was upgraded to 10g.  What a waste of time.  Thank you for your patience and persistence.  I'm going to close this, but I wanted to give you an explanation first.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now