| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: wierd profile problem
Hi Ryan,
Considering you'll have approximately 1,174,687.5 centuries until you have to change it, look on the bright side, at least it'll give you plenty of time to think of a really really good password.
I'm led to believe this default figure was picked on purpose by some financial folk at Oracle Corp as the suggested date when Oracle shares will again break the $20 mark, although I could be mistaken ;)
Cheers
Richard
----- Original Message -----
From: <ryan.gaffuri_at_cox.net>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, April 07, 2004 10:46 PM
Subject: wierd profile problem
I have a DBA account that has operating system authentication. I originally set it to have a profile other than default, but have since set it back to the default profile, when I log in I get this and I shouldn't get anything:
ERROR:
ORA-28002: the password will expire within 4290546226 days
I can still log in though. any idea? Odd thing is that when I try to enable autotrace from this account I get:
SQL> set autotrace on
ERROR:
ORA-28002: the password will expire within 4290546226 days
SP2-0619: Error while connecting
SP2-0611: Error enabling STATISTICS report
I get the explain plan but no stats. I have everything installed properly. Before messing with profiles, I didn't have any problems. I created a new user and was able to get autotrace to work. The odd thing is that the second time I type set autotrace on I get:
SQL> set autotrace on
ERROR:
ORA-24315: illegal attribute type
SP2-0619: Error while connecting
SP2-0611: Error enabling STATISTICS report
I know the correct plustrace and correct plan table are installed, because it worked before I messed around with profiles and I can set it up with a brand new user.
any ideas? Might be some form of bug.
 |
 |