Re: DBCA failing after 10.2.03 upgrade

"Maxim Demenko" <mdemenko_at_gmail.com> wrote in message news:48147D83.9090504_at_gmail.com...
> Mike Jones schrieb:
>>> "hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message
>>> news:2a57619b-45a3-4833-bbe0-d2283b95ad37_at_e39g2000hsf.googlegroups.com...
>>> On Apr 26, 5:07 pm, "Mike Jones" <mj20..._at_hotmail.com> wrote:
>>>
>>> snip
>>>
>>> 1) Can you in your environment create a reproducible test case? If so
>>> great otherwise my guess is that you possibly did something unusual
>>> somewhere along the way. The OUI error messages should mean
>>> something ...
>>
>> I have been able to reproduce the problem on three different systems and
>> repeated installs on a test system. It's very repeatable for me. Am I to
>> assume this repeatable behavior is limited to myself? I was unable to
>> find any references to this problem when doing my research.
>>
>>> 2) Did you try using the 10.2.0.4 patchset which should be available
>>> for your environment by now? In other words, why patch to 10.2.0.3
>>> when oracle has a newer patchset available now?
>>
>> I am downloading 10.2.0.4.0 right now. I'll post my results here.
>>
>>
>
> Just installed a fresh 10.2.0.1 on CentOS 5.1 - with base package
> downloaded from OTN, then patched to 10.2.0.4 - it appears, seed database
> is replaced by patchset.
> after base install:
> oracle_at_col-co5-01:/opt/oracle/product/10gR2/assistants/dbca/templates >ll
> total 112120
> -rw-r----- 1 oracle dba 5728 Jun 30 2005 Data_Warehouse.dbc
> -rwxr-xr-x 1 oracle dba 13017088 Jul 2 2005 example01.dfb
> -rwxr-xr-x 1 oracle dba 991232 Jul 2 2005 example.dmp
> -rw-r----- 1 oracle dba 5608 Jun 30 2005 General_Purpose.dbc
> -rw-r----- 1 oracle dba 12050 May 16 2005 New_Database.dbt
> -rwxr-xr-x 1 oracle dba 7061504 Jul 2 2005 Seed_Database.ctl
> -rwxr-xr-x 1 oracle dba 93569024 Jul 2 2005 Seed_Database.dfb
> -rw-r----- 1 oracle dba 5665 Jun 30 2005 Transaction_Processing.dbc
> oracle_at_col-co5-01:/opt/oracle/product/10gR2/assistants/dbca/templates
> >sha1sum Seed_Database.dfb
> 249727a3d7b1eca3f07cf5cf2806175e55e0436f Seed_Database.dfb
>
>
> after patchset:
> oracle_at_col-co5-01:/opt/oracle/product/10gR2/assistants/dbca/templates >ll
> total 114104
> -rw-r--r-- 1 oracle dba 5728 Feb 17 02:30 Data_Warehouse.dbc
> -rw-r--r-- 1 oracle dba 13017088 Feb 17 11:33 example01.dfb
> -rw-r--r-- 1 oracle dba 1048576 Feb 17 11:33 example.dmp
> -rw-r--r-- 1 oracle dba 5608 Feb 17 02:30 General_Purpose.dbc
> -rw-r--r-- 1 oracle dba 12050 Aug 18 2006 New_Database.dbt
> -rw-r--r-- 1 oracle dba 7061504 Feb 17 11:30 Seed_Database.ctl
> -rw-r--r-- 1 oracle dba 95543296 Feb 17 11:30 Seed_Database.dfb
> -rw-r--r-- 1 oracle dba 5665 Feb 17 02:30 Transaction_Processing.dbc
> oracle_at_col-co5-01:/opt/oracle/product/10gR2/assistants/dbca/templates
> >sha1sum Seed_Database.dfb
> df4a42c661f9fc02aec073060a72f91afd7b5121 Seed_Database.dfb
>
>
> Maybe you should try indeed with another installation media.

I've found the root cause of the problem. It turns out the file permissions on Seed_Database.ctl and Seed_Database.dfb were incorrect. They were set to -r-xr-xr-x on install instead of -rwxr-x-r-x. I am not sure how I missed this the first time I checked them. I suspect the oversight was due to the fact I checked them after I had manually copied the new seed files from the 10.2.0.3.0 upgrade media into the Oracle home. After performing a fresh install of 10.2.0.1.0, changing the file permissions to -rwxr-x-r-x, and upgrading to 10.2.0.3.0 I was able to use DBCA to create new databases.

I also downloaded another copy of 10.2.0.1.0 and installed from this new download and everything went fine. So in conclusion it looks as if the original media I was using has the incorrect permissions problem.

Now I have to decide if I should reinstall the two non-test database installations from the good media. Who knows what else might be messed up with those installations.

Thanks for everyone's assistance in this matter. Received on Sun Apr 27 2008 - 14:31:34 CDT