30 July 2010

Tiny

Are you always looking for Oracle documentation?
It can be found on http://tinyurl.com/oradoc.

For some reason it was never linked on tinyurl.

Have fun!

29 July 2010

Password expired in 11gR2

On most of our 11gR2 databases that we have been using over the last months, the passwords start expiring recently.
I noticed that the default password expiry time is 180 days on the DEFAULT profile, so:

ALTER PROFILE "DEFAULT" LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Or, you can create a profile for your application-owners with unlimited password life time - it's up to you.

Note: this is also a problem on your DBSNMP user in your EMREP database when you use Grid Control with a 11gR2 database for EMREP.

11g Grid Control running on Enterprise Linux - Virtualbox

I read this fine paper by Martin Decker on installing the 11g Grid Control.
It can be pretty easily done with Virtualbox and Oracle Enterprise Linux.


You should really try for yourself, especially those who have never worked on 11g Grid. Main difference is that you first install Weblogic application server, then a database (repository) and then the Grid Control. Have fun...!