Re: catpatch.sql not applied after database creation on recently updated database.

From: Tapan Trivedi <taptriv_at_yahoo.com>
Date: Fri, 23 Apr 2004 15:08:28 -0700 (PDT)
Message-ID: <20040423220828.96891.qmail@web10002.mail.yahoo.com>

The damage is minimal if at all. Your partner probably created the database using dbca and one of the templates. That seed db is 92010. To prevent this in the future always check the values from dba_registry before you go on. The values of importance are catalog and catproc .

set pagesize 99
select * from dba_registry;

Tapan
Hope this helps.
Eric Jenkinson <ericjenkinson_at_conwaycorp.net> wrote:

Several weeks ago I updated one of my 9i R2 database servers to the 9.2.0.5.0 patch set and ran all of the necessary scripts on the database after patching the binaries. A partner of mine created a new database last week on the same server using the DBCA. After a week of loading data into this new database he discovered that he was not able to perform an export. After do some looking around the database I discovered he did not run catpatch.sql after creating the database.

My plan is to run catpatch.sql and the rest of the scripts detailed in the install instructions that pertain to our environment. My question is, how much damage, if any was done by not running these scripts after the database was created? Apparently all loads and subsequent processing that he did returned no errors. He only received errors when trying to export all of the objects from the schema he was working in.

Thanks,

Eric Jenkinson

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

RAC Specialist
HA Consultant
916 613 1921
Ask me about our interviewing services ?

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Apr 23 2004 - 17:06:07 CDT