Re: Oracle Patch

snip

> IIRC it all depends on *how* you create the database after said
patchset
> has been applied. If you are creating from scratch or using the "new
> database" option in DBCA then you don't need to do a startup migrate
on
> this database as you are running the catalog, catproc etc.. scripts
as
> part of this database creation. However, if you choose one of the
DBCA
> options that include datafiles then yes, you do need to "startup
> migrate" these DB's and re run the neccesary dictionary scripts to
get
> them up to date, as the databases created from the options that
include
> datafiles are essentially cloned databases from the base 9.2.0.1
> install, and the patchset does not update the datafiles that create
> these databases.

You are absolutely correct. I do this infrequently (at best) thru dbca and yes there are 2 options, create a new database or use a canned pre-created one.

The canned ones will have to be upgraded to match patchset. Received on Sat Feb 26 2005 - 14:50:23 CST