Re: CATPROC not valid error during DB creation

From: Rich Jesse <>
Date: Thu, 23 Aug 2012 10:55:55 -0500 (CDT)
Message-ID: <>

Hey Steve,

> 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.



Received on Thu Aug 23 2012 - 10:55:55 CDT

Original text of this message