Re: CATPROC not valid error during DB creation

> Running DBCA to create a database and get this:

As an aside, do yourself a favor and run this SQL against your new DB:

SELECT comp_id, comp_name, version, status FROM dba_registry;

Make sure you know what got installed *and why*. I recently spent weeks trying to figure out how to untangle a v10.1 DBCA mess when apparently the person who ran it installed every module under the sun, licensed or not. This made the DB basically unable to be upgraded to 11.2 until I could remove them.

More than 15 MOS articles (those are just the ones with answers!), 3 SRs, some very careful and reasoned ignoring of certain Oracle Support advice, and weeks later, I got everything removed and the DB upgraded.

I'm sure the DBCA has changed -- the 11.2 DBUA is actually impressive! -- but it's still up to us to be vigilant about what's installed in our DBs. I'm a big fan of the Principle of Least Privilege here, as it applies to how Oracle is installed and how a DB is created. Not just for security's sake, but for ease of maintenance as well.

GL!

Rich

--
http://www.freelists.org/webpage/oracle-l