Re: catpatch.sql not applied after database creation on recently updated database.
- From: Tapan Trivedi <taptriv@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 23 Apr 2004 15:08:28 -0700 (PDT)
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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
