"Maxim Demenko" <mdemenko@[EMAIL PROTECTED]
> wrote in message
news:48136080.4070203@[EMAIL PROTECTED]
> Mike Jones schrieb:
>> After upgrading from Oracle 10g 10.2.0.1.0 to 10.2.0.3.0 I am no longer
>> able to use DBCA to create a new database. I believe the problem is the
>> 10.2.0.3.0 patch set does not upgrade the seed database used by DBCA
from
>> 10.2.0.1.0 to 10.2.0.3.0. Thus after DBCA completes the DB replication
>> and attempts to start the instance it fails with a disconnect
>> (essentially the same error one receives if they do not upgrade their
>> current databases after the patch installation). This behavior is
>> understandable given it's attempting to start a 10.2.0.1.0 instance. My
>> question is how can I update the seed database or otherwise utilize
DBCA
>> to create new databases after an upgrade?
>>
>> I am running Oracle 10g 10.2.0.1.0 with the 10.2.0.3.0 patch upgrade,
>> Oracle Enterprise Linux 4 Update 6 (x86, 32 bit, Oracles version of
>> Linux). I've used DBUA and/or catupgrd.sql to upgrade my existing
>> databases without problem. I've read the release notes, performed the
>> necessary pre/post installation tasks, etc. I can't seem to find any
>> reference to this issue through Google or in these forums. Am I the
only
>> one experiencing this problem?
>>
>> Thanks in advance
>
> I suggest, you should investigate the upgrade log file to find out, why
> your seed databases were not patched. In addition Note 556639.1 may be
> helpful.
Thanks Maxim. I have reviewed the installation log files and did not see
anything about a failure to install the seed database files. Is there
something specific I should be looking for? One thing to note from the log
file are a number of the following entries:
INFO: OUI-10070:The patch oracle.client 10.2.0.3.0, which is part of patch
set Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0 , has not been
selected for installation.
Perhaps the seed database is part of something I have not selected (though
I
don't recall being given the option to select anything)?
The article was helpful and after manually copying the seed database files
to the Oracle installation I am now able to use DBCA to create databases.
However I did check the permissions on the seed database files and the
parent (templates) directory and the OS permissions do allow the oracle
user
to replace the files in question (I copied the new files from the patch
DVD
as the oracle user and did not experience any problems).
I find it odd that I am the only person (so it seems) to have encountered
this problem. I've encountered it on three different systems. I've used
three different 10.2.0.3.0 patch downloads. The only thing common between
them all is the original DB (10.2.0.1.0) installation media. Perhaps I'll
download it again and give it another try.
Anyway I do have a work around (now that I know where the seed database
files are stored on the 10.2.0.3.0 patch DVD) that allows me to proceed
but
I would like to figure out what the root cause of this problem is.
|
