Archive for December, 2009

The usual end-of-the-year stuff, but honestly!

Before everyone diappears from The Net(tm) for Christmas:
Have a nice yule-tide, don’t eat too much of the feast, don’t drink and drive, and talk the RDBMS of your choice into operating itself for at least two or three days: You won’t miss the usual 6-in-the-morning phone calls on Christmas!

If you are lucky enough to have real holidays over the next days: A happy new year and let’s work on big red letters in January again! ;)

Yours
Martin Klier

PS: I hope you recognized: The usual omnipresent word starting with an X – it’s missing here. And, it hasn’t been too difficult. :)


By Martin Klier in About this blog,Community  .::. Read Comment (1)

Oracle 11g: Password expired, account locked – unwanted!

Hi,

it’s old news, but oracle 11g expires passwords after 180 days, and locks you out if you mistype your password 10 times, and most DBAs don’t like that. It’s unsecure, but for client-server-applications a locked account is no single-user-annoyance, it’s a downtime killing SLAs, nerves and – hopefully not – DBA jobs. So just make your DEFAULT user profile less secure:

select * from dba_profiles where resource_type='PASSWORD' \
  order by resource_name;
alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED;
alter profile DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED;
select * from dba_profiles where resource_type='PASSWORD' \
  order by resource_name;

Be careful
Usn


By Martin Klier in Oracle  .::. (Add your comment)


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.