Monday, August 31, 2009

ORA-00704 Bootstrap process failure during the DBCA

After 11g1 Patchset 1 installation, i decided to to created a new database using DBCA with "General Purpose" template, error ORA-00740 raised around 40% of completion time.



Errors in file /u02/app/oracle/diag/rdbms/orcl11/ORCL11/trace/ORCL11_ora_25029.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER (ospid: 25029): terminating the instance due to error 704
Instance terminated by USER, pid = 25029
ORA-1092 signalled during: alter database "ORCL11" open resetlogs...
ORA-1092 : opiodr aborting process unknown ospid (25029_2201808)
Mon Aug 31 00:14:53 2009
ORA-1092 : opitsk aborting process



This was caused by incorrect permission during the installation. (Oracle owner should have "write" permission on these template files. (Similar issue occurs for 10.2.0.3, refer to notes 471765.1)


[oracle11g@vmxdb01 templates]$ cd $ORACLE_HOME/assistants/dbca/templates
[oracle11g@vmxdb01 templates]$ ls -lh
total 204M
-rw-r--r-- 1 oracle11g oinstall 5.2K Sep 10 2008 Data_Warehouse.dbc
-r-xr-xr-x 1 oracle11g oinstall 21M Aug 4 2007 example01.dfb
-r-xr-xr-x 1 oracle11g oinstall 1.1M Aug 4 2007 example.dmp
-rw-r--r-- 1 oracle11g oinstall 5.1K Sep 10 2008 General_Purpose.dbc
-rw-r--r-- 1 oracle11g oinstall 12K Jun 21 2007 New_Database.dbt
-r-xr-xr-x 1 oracle11g oinstall 9.3M Aug 4 2007 Seed_Database.ctl
-r-xr-xr-x 1 oracle11g oinstall 173M Aug 4 2007 Seed_Database.dfb


These write-protected files have different size comparing to these coming with 11.1.0.7 patchset.


[oracle11g@vmxdb01 templates]$ ls -lh /u02/stage/Disk1/stage/Patches/\
> oracle.rdbms.install.seeddb/11.1.0.7.0/1/DataFiles/Expanded/filegroup1/
total 186M
-rwxr-xr-x 1 oracle11g oinstall 9.3M Sep 12 2008 Seed_Database.ctl
-rwxr-xr-x 1 oracle11g oinstall 176M Sep 12 2008 Seed_Database.dfb

[oracle11g@vmxdb01 templates]$ ls -lh /u02/stage/Disk1/stage/Patches/\
> oracle.rdbms.install.seeddb.sample_schema/11.1.0.7.0/1/DataFiles/Expanded/filegroup1/
total 22M
-rwxr-xr-x 1 oracle11g oinstall 21M Sep 12 2008 example01.dfb
-rwxr-xr-x 1 oracle11g oinstall 1.2M Sep 12 2008 example.dmp


Solutions: Copy these files from patchset and re-run DBCA.



[oracle11g@vmxdb01 templates]$ chmod u+w *

[oracle11g@vmxdb01 templates]$ cp /u02/stage/Disk1/stage/Patches/\
>oracle.rdbms.install.seeddb/11.1.0.7.0/1/DataFiles/Expanded/filegroup1/* .
[oracle11g@vmxdb01 templates]$ cp /u02/stage/Disk1/stage/Patches/\
>oracle.rdbms.install.seeddb.sample_schema/11.1.0.7.0/1/DataFiles/Expanded/filegroup1/* .


[oracle11g@vmxdb01 templates]$ ls -lh
total 207M
-rw-r--r-- 1 oracle11g oinstall 5.2K Sep 10 2008 Data_Warehouse.dbc
-rwxr-xr-x 1 oracle11g oinstall 21M Aug 31 00:23 example01.dfb
-rwxr-xr-x 1 oracle11g oinstall 1.2M Aug 31 00:23 example.dmp
-rw-r--r-- 1 oracle11g oinstall 5.1K Sep 10 2008 General_Purpose.dbc
-rw-r--r-- 1 oracle11g oinstall 12K Jun 21 2007 New_Database.dbt
-rwxr-xr-x 1 oracle11g oinstall 9.3M Aug 31 00:22 Seed_Database.ctl
-rwxr-xr-x 1 oracle11g oinstall 176M Aug 31 00:22 Seed_Database.dfb