Friday, December 10, 2010

Something Interesting about the 11g Client

If you're just beginning to implement Oracle 11g, you need to be aware of the Automatic Diagnostic Repository (ADR).  It has nothing to do with AWR, ADDM, ASM, ASSM, or any of the other acronyms Oracle has come up with over the last two releases.

In terms of the database, ADR could be a great thing.  It's integration with Enterprise Manager is probably one of the best parts about the feature.  The database manages the retention policy of how long you want to keep these files around based on the scheduler, all things we know how to deal with.

However, you need to be aware that in a client-only configuration (such as a shared client over NFS) there is nothing to manage the logfiles generated by ADR.  The logs get place in /var/tmp and could potentially be across every machine in your environment.  That could be a nightmare if you're running with several hundred clients or multiple domains.  Left unchecked, it could fill up your root disk if that's where you have /var/tmp. I'll leave it to your imagination how I found out about this new feature.

Instead, you might want to turn ADR off by setting DIAG_ADR_ENABLED=off in your sqlnet.ora file.

Wednesday, December 08, 2010

Removing OLAP from 10g

There is a metalink note that describes how to remove the OLAP option if it was installed in your database incorrectly.  See ML Note 739032.1 for details.  Also know that the described procedure doesn't fully remove your OLAP object and that you have to drop some manually according to Note 1060023.1.

Friday, December 03, 2010

Working with Oracle 11g

As I continue to work on Oracle 11g, I am constantly reminded of a quote from Bertrand Russell:
In all affairs it's a healthy thing now and then to hang a question mark on the things you have long taken for advantage.

Wednesday, December 01, 2010

Most Ridiculous Password

I encountered a website yesterday that required a complex password.  It's password rules were:

  • at least 9 characters
  • must include a capitol letter
  • must include three digits
  • must not repeat a letter, but can repeat a number
  • must include one "special" character above a number [!@#$%^&*()]
  • can not include "special" characters that is not above a number
  • can not start with a capitol letter
  • can not start with a number

I am glad they have a "password reset" link.