Re: DBCA failing after 10.2.03 upgrade
- From: "Mike Jones" <mj2008b@xxxxxxxxxxx>
- Date: Sun, 27 Apr 2008 13:31:34 -0600
"Maxim Demenko" <mdemenko@xxxxxxxxx> wrote in message news:48147D83.9090504@xxxxxxxxxxxx
Mike Jones schrieb:"hpuxrac" <johnbhurley@xxxxxxxxxxxxx> wrote in message news:2a57619b-45a3-4833-bbe0-d2283b95ad37@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 26, 5:07 pm, "Mike Jones" <mj20...@xxxxxxxxxxx> 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@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@col-co5-01:/opt/oracle/product/10gR2/assistants/dbca/templates
>sha1sum Seed_Database.dfb
249727a3d7b1eca3f07cf5cf2806175e55e0436f Seed_Database.dfb
after patchset:
oracle@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@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.
.
- References:
- DBCA failing after 10.2.03 upgrade
- From: Mike Jones
- Re: DBCA failing after 10.2.03 upgrade
- From: Maxim Demenko
- Re: DBCA failing after 10.2.03 upgrade
- From: Mike Jones
- Re: DBCA failing after 10.2.03 upgrade
- From: hpuxrac
- Re: DBCA failing after 10.2.03 upgrade
- From: Mike Jones
- Re: DBCA failing after 10.2.03 upgrade
- From: Maxim Demenko
- DBCA failing after 10.2.03 upgrade
- Prev by Date: Re: library cache miss ratio very high - how to find out the rot cause
- Next by Date: Re: library cache miss ratio very high - how to find out the rot cause
- Previous by thread: Re: DBCA failing after 10.2.03 upgrade
- Next by thread: Re: DBCA failing after 10.2.03 upgrade
- Index(es):
Relevant Pages
|
