Re: wierd profile problem
- From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Apr 2004 23:33:07 +1000
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@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
